Skip to Content
0
Former Member
Mar 04, 2009 at 01:59 PM

Text-Variables for 12 selection based on 1 Date Variable

42 Views

Hello.

I have a report where the user is being prompt to enter a start date (YYYYMM) in a variable. Based on that, my report have 12 selection using the variable + offset(1), + offset(2) .... + offset(11).

For the label of my columns, I'd like to display the the YYYYMM value, what the best way to achieve that? From what I see, I might have to create 11 variables that are equals to my original variable entered by the user with the use of offset and then create 12 text variables to get that information but I really hope I'm wrong...

Thanks.

Regards,

John