Multiple subreports in crystal

Yahoo Archive
1
Thanks Jerry, but so far it seems as though it makes no difference.
Actually, I have run into another problem. The way I have made this
calculation, I can no longer create a summary field. (this is in the
subreport):

if {PartRev.EffectiveDate}=Maximum ({PartRev.EffectiveDate})
then {PartOpr.EstSetHours}+({PartOpr.EstProdHours}*{PartOpr.QtyPer})
else 0

Since Maximum() is a summary function, does this not allow me to
create a grand total with this calculated field? I seem to remember
being able to do things like this in RB...

Thanks again,
John Mahala
KRB Machinery


--- In vantage@yahoogroups.com, "Jerry Boyle" <jboyle@s...> wrote:
> You should be able to add the shared detail value to a number
variable in
> the main report at each detail line and print it at your group
level. Then
> add that variable to your shared group variable in a formula field
at the
> group level. Then you should be able to have a grand total. You
would need
> to reset your detail level variable to 0 at the group header.
>
> Jerry Boyle, Controller
> Sipco Molding Technologies
> Meadville, PA. 16335
> p 814.724.2243 x53
> f 814.724.2244
> vantage 6.10
>
>
> -----Original Message-----
> From: John Mahala [mailto:john@k...]
> Sent: Wednesday, March 23, 2005 10:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] multiple subreports in crystal
>
>
>
> I have a report that uses two subreports. One at the group level,
and one
> at the detail level. I have shared the subreport values with the main
> report, however I would like to sum the detail-level subreport value by
> group and add that total to the group-level subreport value.
> (and ultimately have a report grand total). Unfortunately, Crystal
will
> not allow me to sum either shared value. Any insight?
>
> Thank you,
> John Mahala
> KRB Machinery
2
I have a report that uses two subreports. One at the group level, and
one at the detail level. I have shared the subreport values with the
main report, however I would like to sum the detail-level subreport
value by group and add that total to the group-level subreport value.
(and ultimately have a report grand total). Unfortunately, Crystal
will not allow me to sum either shared value. Any insight?

Thank you,
John Mahala
KRB Machinery
3
You should be able to add the shared detail value to a number variable in
the main report at each detail line and print it at your group level. Then
add that variable to your shared group variable in a formula field at the
group level. Then you should be able to have a grand total. You would need
to reset your detail level variable to 0 at the group header.

Jerry Boyle, Controller
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 6.10


-----Original Message-----
From: John Mahala [mailto:john@...]
Sent: Wednesday, March 23, 2005 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] multiple subreports in crystal



I have a report that uses two subreports. One at the group level, and one
at the detail level. I have shared the subreport values with the main
report, however I would like to sum the detail-level subreport value by
group and add that total to the group-level subreport value.
(and ultimately have a report grand total). Unfortunately, Crystal will
not allow me to sum either shared value. Any insight?

Thank you,
John Mahala
KRB Machinery