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

[Karol-K]

Hi,

can you post a screenshot of your outline view? The description is confusing, do you have 3 data sources or only one data source connected to the 3 crosstabs?

You need for sure 3 data sources, then the state will be different.

Karol

[Former Member]

Hi Karol

I have 2 different crosstabs next to each other and each from different data source

and I would like to export both of them in one page of excel.

I did export them using an array, however each crosstab is showing in different page.

[Former Member]

same issue here, need way to export two crosstabs in one time for same data source or different.

[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.