Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Group footer spacing

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
mcl
Advanced Member
Posts: 29
Advanced Member
7/13/2009 2:09 PM
    This may sound a little crazy but I cannot figure out how to do it. 
    (1)  I am checking some items in our legacy system against the count and amounts that have been converted to Lawson.
    (2)  No problem doing the actual comparison, I read legacy files in main report, summarize data for a group, at the group footer I call a subreport to read Lawson, share variables from Lawson-subreport back to main, and print in a second footer line if the accumulated legacy total is not equal the Lawson-subreport shared.
    (3)  I want to print a blank line separator (based on a higher group) only if there are actual lines in the lower group.  In other words, I need to suppress the higher group blank line if there were not inconsistencies in that group.

    I think I could do it  IF  I could figure a way to accumulate the amounts shared from the Lawson-subreport, but "running totals" will not let me use the shared variable.   Any ideas how to make this, or another approach work?
    Char
    Veteran Member
    Posts: 62
    Veteran Member
    7/13/2009 3:24 PM
      The section you suppress based on values from shared variables must be below the sub report that returns the shared variables so you may need to rearrange what is in headers vs. footers and use multiple group footers - that being said, you could return a booleanvar easily from the sub it seems based on approrpriate values and then create an additional group footer in the main report (for your spacing) and conditionally suppress that footer based on the booleanvar = false. Make sure you reset that variable in the sub report header as if there are no records, the prior value is maintained. I'm not sure where you were going with using a shared variable in a running total - I try to avoid running totals as they happen whilepringing records and will therefore slow the report down considerably if there are many and espcially since you already had to use a sub report which is generally also a detriment to efficient processing. It's not often that running totals couldn't be acccomplished through summarized formulas (where shared variables can be used if needed). I hope it's helpful..
      mcl
      Advanced Member
      Posts: 29
      Advanced Member
      7/13/2009 6:28 PM
        That helped. I could not set the booleanvar in the subreport, it had to be set based on a total from the subreport compared to a running total in the main report. But I set it there, and suppressed the higher level printing based on it. It worked. Thanks