December 20, 2005 at 5:34 pm
I am try to design a report to dynamically display the columns based on today's date. For example, table reservation has a summary result of total reservation per each of my site broken down by Month. Table looks like this:
Site,Jan, Feb, March, April, May
1 , 5, 10, 20, 4, NULL
5 , 10, 2, 0, 0, NULL
If I run it in May1, which I don't have any data yet for anything beyound May. I just wanted to show on 4 months column instead of hard code all the months columns in my report.
Is there a way I can dynamically create column names based on my columns in my table and pull the data accordingly to it base on the result of the columns?
What should I do?
thanks
--Jon
DBA/OLAP Developer -
San Francisco, CA
December 22, 2005 at 6:43 am
If the month names (Jan, Feb, etc) are the columns in your table you could simply place them as fields on your report and toggle the visibility of those fields based off the current date or off the value returned
December 22, 2005 at 11:08 am
Does it matter if I use the Matrix? or Table? Do I set the visibility of these field int he report property?
thanks!!!
DBA/OLAP Developer -
San Francisco, CA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply