Crystal Reports 2008 Parameter

[Mags2010]

Hello!

Looking for some assistance on how to resolve a problem. I have created a Dynamic parameter that prompts a user to select a company from a table of values. When I implement the parameter it prompts me with 1 to 5 meaning I can only choose a company from A to F which covers pgs 1 to 5. I also added the parameter in my record selection (ie: {CommissionReportingDetailView.CompanyName} = {?Company Name}).

Can someone please provide some context around what I am doing wrong. I can provide a screen shot but don't know how to upload it to this post.

Any assistance is appreciated!

 

[lbass]

Please explain how you set up the dynamic parameter. It is unclear what the numbers 1 to 5 reference. If you have a company ID field, you could use that for the value and then use the company name for the description--then choose to show only the description for the prompt. However, you would still set up the record selection formula like this:

{table.companyID} = {?CompanyName}

In other words, the underlying selection is based on the value, NOT the description field.

-LB

 

[Mags2010]

maybe that is where I am going wrong because the table I am pulling from is a Company Name & not Company ID. I'll have to find the corresponding ID's & try that.

 

[lbass]

You can select based on CompanyName, but then that should be the value field when you set up the parameter. Where did the 1 to 5 come from?

-LB

 

[Mags2010]

the 1 to 5 is the number of screens I can flip through to select the company I want to see when I run the report. My options are not all displayed on 1 screen. How can I upload a screen shot to you?

 

[lbass]

Screens? Do you mean there are so many companies that you have to page down multiple times on the the parameter screen? I still don't see where the 1 to 5 are coming from--you seem to be saying you see a prompt with options 1 to 5--so how did you create that?

-LB

 

[Mags2010]

yes I guess there are so many companies that I have to page down but the limit is 5 & that only takes me to the letter F.

 

[lbass]

There is a limit of 1000 rows for a parameter as determined in the registry--which can be adjusted, if you are careful and know what you are doing. However, I think if becomes difficult for a user when you have such an extended list. You might want to consider limiting the list by either adding criteria in a command that you then use to populate the parameter or by using a cascading parameter where the higher order parameter limits the resulting second-order list.

-LB

 

[Mags2010]

ok - I wasn't aware there was a limit but that makes sense now.

How would I go about implementing your suggestion below?:

You might want to consider limiting the list by either adding criteria in a command that you then use to populate the parameter or by using a cascading parameter where the higher order parameter limits the resulting second-order list.

 

[lbass]

How do you want to limit the list? What criteria would you apply?

-LB