export excel separate tabs

[tibo]

Hello,

I have a report with a crosstab and a chart. When I do an export to excel, the chart is displayed on top of the crosstab. I don't want this to happen.

Is there a way to export de crosstab to one tab in excel, and the chart to another?

thx in advance,
greetz

[lucasdnd]

You need to add a new Report Page. Then, place the Chart in one page and the Crosstab in the other. That way, each Object will be in a different tab in Excel.

[tibo]

thx for your reply lucasdnd,

but the thing is that I want te crosstab and the chart to be in the same page in report studio. I'd like it to be that way (both objects in the same page) in excel too, but every time I export the report to excel, the chart is shown on top of the crosstab. So I thought maybe exporting the objects to different sheets could be a solution...

You think it's possible to export 2 objects that are on the same page in report studio to different sheets in excel?

best regards,

[kalyan_y]

Did u try placing a table with two rows, with crosstab in the top and chart in the below?