How to list a calculated column in Main Report from a subreport
I am using CR 2008 and I have a coulmn in my subreport which I was to list in my main report.
Let's say I have a main report which is run by item number and then I have a subreport where I have calculated annual usage of items and then I want to list the the annual usage in main report.
let's I have 3 columns in my main reprot item #, description and class code and then I am calculating annual usage in a subreport and list as 4th column to my main report.
How do I do that ?
sharon towler replied
if you just want to pull a value from the sub report you need to create shared variables
Shared variables are used to pass values from sub report to the main report.
(if you want to summarize totals from a sub report with totals from the main report, you would use the following formulas to pass the value from the sub report to main report.
SHARED Numbervar X := x + ;
SHARED Numbervar X;
Shared variables can not be suppressed.
Make the font white and the field very small.
They must be placed below the subreport to retrieve the value.