J
John
I have a report that have I want to associate a few
options on how things are displayed using a form. I
created an options form and have the related SQL
statements working nicely, but I am having problems in
getting the report to work correctly.
There are two options:
Monthly + Annual Total / Annual Total Only
Monthly + Annual Total is columns of Jan...Dec Total
Annual Total Only is column on Total only
Details / Summary
Details shows:
Group 1
Record 1
Record 2...Recond n
Group 1 Total
....
Group N
Grand Total
Summary Shows:
Group 1 Total
....
Group N total
Grand Total
So basd on Monthly/Annual and Detail/Summary, the report
changes what fields are shown.
I thought about maintaining 4 different reports for the
different combinations, but I have 3 seperate reports I
want this ability for and in the furture might add 1 or 2
more options so the number of reports to maintain would
bee overwhelming.
Any help would be aprreciated.
options on how things are displayed using a form. I
created an options form and have the related SQL
statements working nicely, but I am having problems in
getting the report to work correctly.
There are two options:
Monthly + Annual Total / Annual Total Only
Monthly + Annual Total is columns of Jan...Dec Total
Annual Total Only is column on Total only
Details / Summary
Details shows:
Group 1
Record 1
Record 2...Recond n
Group 1 Total
....
Group N
Grand Total
Summary Shows:
Group 1 Total
....
Group N total
Grand Total
So basd on Monthly/Annual and Detail/Summary, the report
changes what fields are shown.
I thought about maintaining 4 different reports for the
different combinations, but I have 3 seperate reports I
want this ability for and in the furture might add 1 or 2
more options so the number of reports to maintain would
bee overwhelming.
Any help would be aprreciated.