RE: Parameter Selection

[allyne]

Hi Everyone,

I'm using Crystal XI. The report that I'm creating uses an ODBC Connection to SQL which links to a Stored Procedure.

The main report has the following fields.

ID,Name, Address, City, State, Zip, Location, Provider, DateSeen, Age, DOB.

It also has the following parameters:

DateSeen = ?DateSelection and
Location = ?LocationSelection and
Provider = ?Provider
age = ?Age

The age field is a numeric field.

This works great!

I now have an on-demand sub report which has the following fields: Name, Address, City, State, Zip using the same stored procedure as the main report and also has the same parameters. This report is so that the user can export just these fields for mailing labels.

What I would like the user to be able to do is enter the information from the parameters in the main report and pass those parameters to the sub report.

So far everything works great except I can't seem to get the Age parameter to work between the main report and sub report. All other parameters work great and ties into the subreport.

Any suggestions? Not sure why just the age parameter isn't working.

Thanks for your help!

 

[synapsevampire]

Presumably you've linked all of them together?

Right click the subreport and make sure that it demonstrates that the age is also linked.

I think you can also go into the Report->Selection Formulas->Record and see it referenced within.

-k

 

[allyne]

I've linked all of them together except for some reason the Age parameter doesn't seem to be linked. When The parameter selection box comes up for the user the age parameter shows twice. Once for the main report and once for the sub report. Not sure why this is happening when all the other parameters are working.