Hiding cross tab

[Abdel]

Hi all,

I have 3 cross tabs in my report but need to display them according to parameter specified by the user. If your requests for 1 and 2 cross tab, the third cross tab need not be displayed. I need to hide and also have to see that It does not get exported to excel when exporting the report after rendering.

Can anybody tell me how to hide a cross tab? Is it possible?
Please advice.

Thanks in advance,
Abdel Olakara

[jordi]

Use Crosstab Properties --> Visibility and mark 'Hidel Element' . Put the code to read the parameter and return true or false regarding your criteria.

You can also drop your crosstab element from the report using a little piece of code in the beforeFactory event in report. This is java code but javascript is really similar.

ReportDesignHandle rdh = (ReportDesignHandle)reportContext.getReportRunnable().getDesignHandle();
rdh.getElementByID(48).drop();

You can read your parameters with reportContext.getParameterValue("param_name");