Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Retrieving Data Post Reply Post New Topic
Author Message
crist
Newbie
Newbie


Joined: 21 Jun 2010
Location: Singapore
Online Status: Offline
Posts: 29
Quote crist Replybullet Topic: Retrieving Data
    Posted: 30 Jun 2010 at 6:11pm

Dear Expert,

Please advise me if there are certain limitations and restrictions in Crystal Report in parameters in retriving data?
 
I used both dynamic and statis for this parameter, but both have same result.
 
Because I have hundreds of suppliers and may database i used started 2005 - to date.
 
For list of supplier (parameter) - it only shows starting with 1 to C, while rest does not showed in the list.
 
for the date (parameter) - it only shows from 1-1-2005 until 20-5-2008. also the rest does not showed Cry
 
i should retrieve all the transactions from 2005 - to date.  so that the user can select from which date to what date.
 
Please help me.
 
Thanks in advance.
Crist
 
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 01 Jul 2010 at 5:26am
Hi
If you are using Crystal Version below 2008 , you will need to make changes to the regedit settings for Maxrowset, I think there is a post in the forum somewhere related to the changes which needs to be done so all the values are listed in the Parameters.
 
note:-once the change is done it will take a while to reterive all the values for the parameters.
 
I would suggest why don't you run a sql query for the parameters then export the output to text file and the export the values in crystal for parameters, the major drawback in this is if the table is updated with new records you need to do the same process all over .
 
Cheers
Rahul
IP IP Logged
crist
Newbie
Newbie


Joined: 21 Jun 2010
Location: Singapore
Online Status: Offline
Posts: 29
Quote crist Replybullet Posted: 01 Jul 2010 at 8:59pm
Dear Rahul,
Please be advise that I am using V11-developer edition of Crystal.
 
Further on, if i never set parameter for suppliers - i can see all of them in list of my report but i want my users to select which supplier they want,
 
with regards to the date, still it is incomplete, the rest are not showing.
 
 
Please help.
IP 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.