Crystal Reports Limit length of a command

Tips and Tricks
Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks

Topic: Limit length of a command

Author	Message
Dzung Newbie Joined: 14 Dec 2009 Location: Vietnam Online Status: Offline Posts: 2	Topic: Limit length of a command Posted: 14 Dec 2009 at 12:40am
	Hi, I'm working on CR 2008. My query is too long that exceeds the limit length allowed by CR even though I tried to compress it. I have to do everything in one query instead of splitting it into sub-reports (because of performance problem) Is there any way to specify that limit length ? Thanks in advance Edited by Dzung - 14 Dec 2009 at 12:41am
	-- Dzung
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3702	Posted: 14 Dec 2009 at 8:53am
	What type of database are you using? Can you create a view that runs your sql? If you can, then Crystal will see the view as if it were a table and there will be no limitations on how long it can be. -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Dzung Newbie Joined: 14 Dec 2009 Location: Vietnam Online Status: Offline Posts: 2	Posted: 14 Dec 2009 at 6:38pm
	Hi Dell, I will try to refactor my SQL first. If it's still too long, creating a view seems to be the only way ;-) Thanks for your reply
	-- Dzung
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.