Using parameters from main report in a formula on subreport.

[Icebun]

I have a report containing a main report and a subreport.

Users enter a year and a month on the main report. This is used to calculate financial information in two columns :

1. a current month total (for the month and entered)
2. a cumulative total (for all months up to and including the month entered).

I have the same two fields on the subreport, but when I run the report, the values on the subreport are blank.

I am using shared variables to pass the month from the main report to the sub report.

Code in main report :

whileprintingrecords ;
shared numbervar mth ;
mth := {?Month} ;
mth;

(?Month is the parameter field)

Code on sub report :

whileprintingrecords ;
shared numbervar mth;
mth;

I then use the variable 'mth' in my formulae on the subreport.

Any ideas ?

 

[kenhamady]

Which section contains the formula in the main report?
Which section contains the formula in the subreport?
Which section contains the subreport?

A better approach would be to create the same parameter in the subreport and link this to the main report parameter. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Icebun]

Please ignore original message - now sorted.