tis707
May 10th, 2006, 01:04 AM
In details two seperate formulas for date (current range ie: 4/1/06 to 4/30/06), second formula for prior year same month and day range. Grouping is daily.
The formulas work but are seperated by range not picked. How do I get the date ranges side by side for comparison. I am not using cross-tab.
Any help always appreciated.
ok, after starting from square one I finally have the data I was looking for but.....
formatting and suppression not doing as I had hoped.
The report looks like this:
Column1 Column2 Column3 Column4 Column5
Current date data data Prior Year data
4/1/05: Fri 200
4/2/05: Sat 47
4/1/06: Sat 247
4/3/06: Mon 30
How do I get these to line up in the same row without subreports?
I have suppressed everything I can think of...
Help
The formulas work but are seperated by range not picked. How do I get the date ranges side by side for comparison. I am not using cross-tab.
Any help always appreciated.
ok, after starting from square one I finally have the data I was looking for but.....
formatting and suppression not doing as I had hoped.
The report looks like this:
Column1 Column2 Column3 Column4 Column5
Current date data data Prior Year data
4/1/05: Fri 200
4/2/05: Sat 47
4/1/06: Sat 247
4/3/06: Mon 30
How do I get these to line up in the same row without subreports?
I have suppressed everything I can think of...
Help