A weired problem in exporting a drilldown report...

Hi,

I am having a report with a pie chart, each pie links(using Actions->Jump to report) to a child report showing the relevent data in tabular format.

Everything is working fine i am able to click on pie and drill down to relevent report. But when i try to export the child report (in excel/pdf...) instedd of getting the child report the parent report gets exported i.e the exported pdf/excel contains pie chart(parent report) instead of tabular report(child report).

Its not happening with other similar reports, and i am clueless regarding this...

Sometimes instead of exporting the wrong report report server throws

"Index was out of range. Must be non negative and less than the size of the collection. Parameter name: index"

This happens only for Excel and not for pdf.

|||

HI,akjoshi:

I have found some tips about this problem. Hope it will lead you to the right direction.

What seemed to finally do the trick was removing a couple of Line statements in the page footer in the RDL file. One had a height of 0 and a width of 10 inches, and the other had a width of 0 and a height of 0.375 inches. After that, I was able to resize the page and footer in Layout view, and the report is now rendering correctly.

So, if you're having this problem, take a good look at your RDL file. Chances are that VS screwed something up.

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance