Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sahred Variable help plz

Status
Not open for further replies.

fsreport

Programmer
Mar 23, 2007
128
US
Hello All
Cr 9.0
MS SQL

i have a main report and a sub report
on the main report i have 2 subtotal
{@Sub_Tot_1}
{@Sub_Tot_2}

in my sub report i have {@Sub_Tot_3}

I need to pass the value from {@Sub_Tot_3} to my main report
so i can add {@Sub_Tot_1}+{@Sub_Tot_2}+{@Sub_Tot_3} to give me my {@total}

i tried this
in my sub report i created a formula like this
@Total
Shared NumberVar Sub3Total:= {@Sub_Tot_3};
and place it on my sub report and supress

in my main report i created this formula
WhilePrintingRecords;
Shared NumberVar Sub3Total;
Sub3Total+{@Sub_Tot_1}+{@Sub_Tot_2}

only add the {@Sub_Tot_1}+{@Sub_Tot_2}
and not Sub3Total


fsreport
 
ok
got it figured out
i had the formula of the sub report place on the grong group
now works
Thanks all

fsreport
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top