Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Group footer spacing
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Pat
Past 24 Hours:
0
Prev. 24 Hours:
2
Overall:
5296
People Online:
Visitors:
470
Members:
0
Total:
470
Online Now:
New Topics
Lawson Portal
Lawson ESS customization
6/23/2025 10:28 AM
I want to add new links and customize the ESS (sel
S3 Security
Securing forms and programs that use Company Group
6/17/2025 5:41 PM
Is there a way to write a rule, that looks up a co
S3 Customization/Development
Self-Serve Customization and Modification of home page
6/17/2025 3:40 PM
Hi, I want to add new links and customize the E
S3 Customization/Development
Data / List view on Lawson Portal
5/21/2025 2:37 AM
Client is on S3 V10. All delivered and custom form
Lawson S3 Financials
Applying credits to open AP invoices
4/28/2025 1:26 PM
Hello, I am new to the Lawson system and after ru
Lawson S3 Financials
Lawson APIA
4/28/2025 1:22 PM
Has anybody recently installed Lawson's APIA m
Lawson S3 Procurement
Tolerance Settings
3/31/2025 2:01 PM
I've been trying to set a tolerance for some t
Dealing with Lawson / Infor
Printing Solutions other than MHC
3/27/2025 1:00 PM
What are others using for printing solutions besid
Lawson S3 Procurement
Green check marks in Lawson 9.0.1
3/20/2025 4:55 PM
Hi, How to remove green check mark on items when o
Lawson S3 HR/Payroll/Benefits
Pay Rate History to Show All Positions
2/26/2025 3:34 PM
Does anyone know how to modify payratehistory.htm
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1377
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Group footer spacing
Please
login
to post a reply.
2 Replies
0
Subscribed to this topic
22 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
mcl
Advanced Member
Posts: 29
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
7/13/2009 3:24 PM
Split
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
7/13/2009 6:28 PM
Split
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
Please
login
to post a reply.