Related Parameters

[RikHess]

As a relative newby to Crystal Reports, I am trying to set up a report that needs two parameters.

The report is a receipt for dues payment, but we have a number of members who make partial payments during the year.

While the member's record is active in the membership app, I want the operator to be able to run a CR receipt report that lists all the payment dates for that member, so the operator can select the appropriate payment date for the receipt. The membership app allows CR reports to be added to the app menu.

I can handle the first paramenter (member ID) being passed by the app to CR.

My question is "how can I set up the second parameter to show the payments made by that member in a drop-down list"?

If it helps, we are using CR ver. 9 and the database is SQL Server 2000. I can create views if needed.

Thanks for any help!

 

[synapsevampire]

Unfortunately Crystal 9 does not have dynamic nor cascading (conditional) parameters, meaning that it cannot read in data at runtime to populate a drop down parameter listing, nor will it conditionally filter a parameter based on data or another parameter.

You can read in the entire list into a parameter from a field in a table, but you cannot filter it based on any conditions.

CR XI does allow for this.

-k

 

[RikHess]

Thanks, at least CR knows the problem is real.

 

[synapsevampire]

They know that they didn't support it before CR 9, they do now.

It was one of the most annoying things about Crystal, that they just didn't get how important this was.

-k

 

[RikHess]

Now I only have to wait until my membership app works with CR XI. Version 9 is the highest they support!

 

[synapsevampire]

Perhasp the application has a parameter collection means, and it supports this, many do have their own parameter collection methodologies.

-k