Crystal Reports Dynamic Parameters

[Former Member]

i am running crystal reports in unix environment, where i want to know how to set the maximum limit for a dynamic parameter list. i did the same in the registry editor in windows server environment. Please help,

[former_member205840 · Accepted solution]

Hi Karthikeyan,

Follow the below SAP note to increase list of values on UNIX

http://search.sap.com/notes?id=0001219715&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64...

SAP NOTE number : 1219715.. the procedure is same for all crystal reports versions.

Sastry

[Former Member]

Thanks Sastry. Now I got how to edit the registry keys for increasing the limit for the dynamic parameters in Unix environment.

I have one more question. i have been following various posts and all of them are showing that the default limit for a dynamic parameter is 1000.

I am using a cascading parameter where based on the company selected, the cost centers are populated in the low level parameter. I have verified with the database and I have only 760 records in it for a company.

But, when I am seeing at the run-time, it shows only 500 records (200/200/100) 3 pages. I am wondering how.

I have tried in both windows and unix environment, and I can see only 500 records out or 760 into the parameter field.

Can you please help me in this regard?

Thanks again,

Karthikeyan

[former_member205840]

Hi Karthikeyan,

Dynamic Cascading or Dynamic prompt will display only Distinct values.  You may be having more records in database tables but are you sure all 760 records dynamic field values are Distinct ?

Try to check count of distinct values at database.

Thanks,

Sastry

[Former Member]

Thanks for your prompt reply.

Yes. Actually i have two companies, each have 760 distinct cost centers.

If i select company, it has to display the 760 cost centers of that company and for the second company the another 760.

Please also note that all these 760+760 cost centers are in the same table with company codes

Example: Company 1 has one cost center 100 and Company 2 has another cost center 100

And if I select 1, it should display 100 and 2 it should display another 100. Also it works like this, as have checked this by changing the registry values in my local laptop which is running in windows 7.

Will the low level parameter will be again limited based on the no. of records on the high-level parameter when i am using cascading type of parameters? I think I am getting the problem here, but if you can confirm this would help me to understand this better.

Thanks,

Karthikeyan.G

[abhilash_kumar]

Hi Karthikeyan,

CR shows prompts in a batch of 200 values. There is another registry key to control this behavior

What version of Business Objects are you running?

In any case, I feel the question is more suited for the BI Platform space.

-Abhilash

[former_member205840]

Hi

It counts distinct values of Dynamic Cascading parameter. i.e. entire parameter including top to bottom levels.

Karthikeyan.. Small miss understanding.. I think it counts the records, but displays distinct values because we are enhancing 'Max Row Set Records' property ..

Yes it impacts low level cascading list of values.

Thanks,

Sastry

[Former Member]

Thanks again Sastry.

i realized what i did, that as i am using cascading parameters, even if I use distinct, it reads all the 1520 records and display only the first 1000 records out of which all each record has one duplicate one, hence it displays only 500.

I changed the logic by removing the cascading parameter and created two different parameters, so that it reads distinct accounting units which are lesser than 1000 (760) and displays the same in the parameter field.

I just have added the company parameter separately and a mandatory one, so that even if the user selects an accounting unit which is not in the selected company, the report displays NIL.

Thanks for your timely help. Have a great day.

[Former Member]

Thanks Abhilash for your prompt reply. Actually i am using CR 2008. The batch value in the registry is already 200 only. But as my table has same values with two different companies, it fetches the first 1,000 records and as all these 1000 records have a duplicate value, it display only 500 out of them.

Thanks again.