How to list a calculated column in Main Report from a subreport

[Former Member]

Hello all,

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 ?

[Former Member · Accepted solution]

if you just want to pull a value from the sub report you need to create shared variables

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.

SUB REPORT

whileprintingrecords;

SHARED Numbervar X := x + ;

MAIN

whileprintingrecords;

SHARED Numbervar X;

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.