how to get a value from subreport?

[francesguan]

Hi, all,

I am trying to count the number of total lines from subreport, then compare to how many lines need to be shown up in packing slip, which is in main report; the purpose is to prevent partial shipping.

is there anybody know how to get the value in subreport to use in main report?

Thanks in advance!
Frances Guan

 

[synapsevampire]

Do you mean the number of records in the subreport, or what is meant by number of total lines? Is this the number of summaries (number of total lines)?

You can place the following formula in the subreport report footer to get the number of records:

whileprintingrecords;
shared numbervar TotalRows:= count({table.field})

Then in any subsequent section to the subreport in the main report you can retrieve the value using:

whileprintingrecords;
shared numbervar TotalRows;
"There are " & TotalRows & " in the subreport."

-k

 

[IanWaterman]

YOu will need to create a shared variable in subreport.

Formula in Subreport.

@eval variable
Whileprintingrecords;

Shared Numbervar recordNo:= count(fieldName)

To use in main report add following to another formula

Whileprintingrecords;

Shared Numbervar recordNo;

You can then use recordNo any way in the rest of the formula.

Make sure you place the subreport in a group or position on the main whare it will be evaluated before you need to use the Variable value.

Ian

 

[francesguan]

Thank you very much! K and Ian