Excel export along with details

08-04-2010, 5:38 AM
Hi All,

I have an excel file which has two sheets. In which one sheet will have the data and another one will have the pivots associated to the data sheet.

My requirement is I will have to create two reports one is details which will have both pivots and data; and the other one is summary which will have only pivoted views. i.e. no data sheet and pivot filters.

Can anybody give me a solution for this.?

Thanks in advance!
Thanks
Vidhya R

Re: Excel export along with details

08-06-2010, 4:20 AM
Vidhya,

You can create two reports- one which uses Chart and any other Data Region (like Table, Matrix etc) to show the data in the report. In the second report, you can just use Chart, if you want to show only the pivot (data summarization) of the data.

The subject of this post suggests about the Excel export – so do you need help in excel export or creating such a report?
Amit Pal
GrapeCity- DataDynamics