Export to excel

[Former Member]

Hello All

In my design studio dashboard i have 2 tabs and each tab has 3 different tables which get selected based on the radio button.

These 3 crosstabs use the same datasource with different measures selected for each table through script.

Though i use the below script,

APPLICATION.export(ExportType.EXCEL_xls,[CROSSTAB_1, CROSSTAB_2, CROSSTAB_3 ])

the initial view that has been selected for crosstab_1 gets exported for all the 3 tables.

Is there a way to handle this issue?

Regards

Merlin

[Former Member]

Hello Experts

Any inputs/ suggestions are very much appreciated.

-Merlin

[alexandre_dussac]

Hi Merlin,

Can you share how you switch the selection for your 3 crosstabs?

I'm guessing you are changing the data source so when you want to export the 3 crosstabs, they have actually the same data source so same data comes out.

Cheers,
Alex.

[Former Member]

Hi Alexandre

Yes the Bex query which i have used is same for all the datasources. Through script i do the restriction as which measure has to be displayed in each crosstab.