Limit length of a command
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8627
Printed Date: 04 May 2024 at 5:34pm
Topic: Limit length of a command
Posted By: Dzung
Subject: Limit length of a command
Date 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
-------------
--
Dzung
|
Replies:
Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: Dzung
Date 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
|
|