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

 

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

 

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

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.