I'm working in a cross tab report and I need to place the Week # (data field in a table - datatype is Number) and the Day number (formula I built) in the X axis of the report. The fields need to be 1 atop the other like this:
Week: 1 2 3 4 etc
Day: 1 8 15 22 etc
The weeks need to display in numerical order across the top of the crosstab.
EDIT: OK, I noticed that the numbers in my illustration are not aligned like they should be. Just bear in mind that I need 1 & 1 vertically aligned with each other, 2 & 8 aligned, 3 & 15, etc.
The Day field is a formula I built that is simply
My idea was to create a formula that placed the Week # on line 1, do a Carriage Return then place the Day # below the Week #. Here's the formula I built to do that: