I'm working on a fairly basic report pulling from a DB that contains no date dimension, but in my header, I need to have the month value be current month minus one, as it's for the previous month.
Is there anyway I can create a function inside the header text box that could do this, or some way I could manipulate the <<Date("MMMM")> value to be current month minus 1?
For instance, if I'm running the report in September, the report header would read the current month as September, and subtract 1 so that it displays XX August XX.