I want to create a report where the group header can change based on VBA (similar to what I can do with a page header or report header).
What I am looking to do is create a monthly report on each page. The data is daily and I want to have 7 columns going across repeated 4-5 times a month on each page. Each day should have its date printed above it. What I tried doing was creating a grouping on week and have unbound items in the group heading for each weekday.
That did not work as I can't modify the group heading at runtime. Any other ideas?
What I am looking to do is create a monthly report on each page. The data is daily and I want to have 7 columns going across repeated 4-5 times a month on each page. Each day should have its date printed above it. What I tried doing was creating a grouping on week and have unbound items in the group heading for each weekday.
That did not work as I can't modify the group heading at runtime. Any other ideas?
