Report 4B :- Cross Tab Header

nuraniuscc

Hi Mike,

As I mentioned earlier, I have a cross Tab that looks like this, as an Example

Jan 08 Feb 08 Mar 08

The month is coming in as a Parameter. How do I Capture that "Text" and show it on the Cross Tab header.

Ok, this is your response in Post # 45 on the thread (Birt 2.3 Questions I would like to ask... ).

Nurani,

As I said in post 29, the crosstab will automatically set the correct column headings for dates. If you break a crosstab down to months, you'll only see the months that have data. The data would be limited by your parameters, so only the correct column headers would be shown. You can see how I used start and end date parameters in the example I posted in that post as well. To get the months to read as January...etc. rather than 1, 2, 3...etc, you can double click on the "month" dimension in the crosstab, change the type to string and create an expression to check for the month number and change it to the string month.
__________________
Regards,

Michael


So, How do I create the expression. Show me the base version of How I would go about writing it?

My input value will be like 012008. I need to be shown as Jan-08.

Thanks
Nurani Sivakumar

mwilliams

Hi Nurani,

So, they will be entering the date in a non-date format like that and you need to use it as a parameter value?