Sage 100

I need some help from our Crystal gurus out there: I've written a report that pulls revenues by segment, and a subreport that is pulling the expenses by segment - in this case, the third segment of the GL account. I have a shared variable pulling the total for the expenses to the main report in a group footer for the segment. Works fine when there are expenses to calculate, but if the segment has no expenses, the total from the previous segment is repeated on each segment until another account has expenses. I need to have a zero or null in the shared var when there are no records in the sub report - any ideas? We're on a tight deadline here.

More info: Group 1 is the Fund - or third segment of the GL account. Using a formula to calculate. Same formula for Group 1 in the sub report, and this is the main link between the main report and the subreport.

Do another formula where you set the shared variable value to zero and put it before the place where you go get it in the subreport.

If you do the subreport in the group header, you'd have to create a second group header section, then switch their order.

Thanks Beth for the quick response. Thought of you on Sunday night - intimate night at Jellyrolls - only around 50 people in the room at any one time, and most of the night was much less. Had the best lineup on that night as well, and it was fantastic.

And no doubt cooler outside, as well. :-)

Beth said ""...put it before the place where you go get it in the subreport."" Formulas within the same section trigger in the order that they were added to the report. Their position doesn't affect the sequence. Adding a second second section as Beth describes it the only way to force the sequence to do the reset formula before calling the subreport.

Got that Dan - placed it in the group footer above the subreport's group footer. Working like a charm.

Ed - I like to reset my shared variables as part of the Section Expert Suppress formula for the header section. Example: Shared NumberVar MyVar := 0; False This works great, and they are easy to find later. :) See you in Nashville! Jon