Thanks for responding.
I found my problem. I was defining my shared variable in the sub program, but I was not printing it. Once I printed my variable in the sub program, it passed the value to my main program.
Mike
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joshua Giese
Sent: Wednesday, April 17, 2013 11:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Shared Variables with Crystal 11.5.3.417
Try removing the while records printing. This really should be working if you wanted I would be willing to do a screen share with you to take a look at it. I don't know that it makes a difference, but for my own preference I usually have a formula field at the report header of the main report that declares the variable shared with a 0 or null value, then set the value in the subreport, then display it lower in the main report
Joshua Giese
CTO
920.437.6400 Ext. 337
Site ID: 27450-E905700B2-SQL64
I found my problem. I was defining my shared variable in the sub program, but I was not printing it. Once I printed my variable in the sub program, it passed the value to my main program.
Mike
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joshua Giese
Sent: Wednesday, April 17, 2013 11:29 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Shared Variables with Crystal 11.5.3.417
Try removing the while records printing. This really should be working if you wanted I would be willing to do a screen share with you to take a look at it. I don't know that it makes a difference, but for my own preference I usually have a formula field at the report header of the main report that declares the variable shared with a 0 or null value, then set the value in the subreport, then display it lower in the main report
Joshua Giese
CTO
920.437.6400 Ext. 337
Site ID: 27450-E905700B2-SQL64
----- Original Message -----
From: "Mike Numbers" <mnumbers@... <mailto:mnumbers%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, April 17, 2013 9:44:44 AM
Subject: RE: [Vantage] Shared Variables with Crystal 11.5.3.417
The sub report is in the footer 1 line a and the main report value is in the footer 1 line c below line a. I have not used WhilePrintingRecords before, but I assume this means when the report prints it will sum the values. Also I have entered the formulas in Field Explorer – Formula Fields – in the area where I normally enter the formula.
Mike
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Joshua Giese
Sent: Wednesday, April 17, 2013 9:34 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Shared Variables with Crystal 11.5.3.417
What order are they displayed in? If you have the shared var display higher in the report than the subreport it won't work. Other than that it looks right. Shared var is the correct one you want.
Joshua Giese
CTO
920.437.6400 Ext. 337
Site ID: 27450-E905700B2-SQL64
----- Original Message -----
From: "mike.numbers" < mnumbers@... <mailto:mnumbers%40cignys.com> <mailto:mnumbers%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Sent: Wednesday, April 17, 2013 8:16:39 AM
Subject: [Vantage] Shared Variables with Crystal 11.5.3.417
I haven't used shared variables before but from my research I think I have the syntax correct, but the values are not being displayed on my main report.
My subreport prints on Group Footer #1a and the formula is:
WhilePrintingRecords;
Shared CurrencyVar OpLab := Sum ({BAQReportResult.Labor_Burden})
In my main report I am trying to print this value on Group Footer #1c with the formula:
WhilePrintingRecords;
Shared CurrencyVar OpLab;
OpLab
My sub report prints correctly with values for BAQReportResult.Labor_Burden, but on my main report I am getting $0.00 for the OpLab value.
Does anyone see what I am doing wrong?
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]