Version 10 Passing Parameters to Record Selection in Peactree 1

[AlohaMichael]

Using standard version 10 of Crystal Reports.
Database is Peachtree = Btrieve (customized) does not allow for SQL expressions.
I have multiple companies in Peachtree. Each Company has its own set of tables. Table definition for each company are identical but are not linked in any way.

I would like to pull GL detail from each company in one consolidated report. The report must be able to pull data from a user specified date range.

Since each company has its own set of tables there are multiple starting points Crystal will not allow me to merge the information. IF it will allow me I don't know how.
Therefore, I am using a subreport for each company. Each subreport is identical to each other. They all point to their own respective data locations. Not as elegant as having Crystal merge the data into one report but it works.


PROBLEM:
How do I create the parameters in the main report to allow the subreports to use the parameters for their respective record selection?


My solutions so far...
I create a parStartDate and parEndDate in the main report and each subreport. Which forces the user to enter in the same dates over 30 times.
main parStartDate
main parEndDate
Sub1 parStartDate
Sub1 parEndDate
Sub2 parStartDate
Sub2 parEndDate
....
You get the idea. I don't want the user having to enter in the same dates time and time again.

The ideal solution would be to have Crystal merge the data into one report without having to use subreports but it keeps on complaining about multiple starting points not supported.

Second best solution is to have one parStartDate and one parEndDate that the subreports can read and use in their record selection.

Suggestions, ideas, or can't be done....

 

[lbass]

I'm assuming you have set up the parameters in each subreport and used them in the subreport record selection formulas. You should then go to the main report->edit-> subreport links and at the top of the screen move each main report parameter to the right. For each one, in the bottom left corner, use the dropdown box so that you can select the corresponding parameter in the subreport. Note that this is NOT the field starting with "{?pm-?xxx}. The actual subreport parameter will be found below this. You will have to repeat these links for each subreport.

-LB

 

[AlohaMichael]

DOH! I feel like such an idiot for not remembering that.
Thank you for your help.
Works like a charm.