Monday, March 26, 2012

Excel Drill Down not showing all details

In my report, I have one group and details. The group has two rows, with the
2nd row's visibility toggled by one of the textboxes in the first row. The
detail row is also toggled by the texbox in the top group row. (the second
row of the group has the titles above the detail row). Anyways, when this
report is run, all of the details show as expected when you drill down.
However, when you export this report to excel and drill down, only the second
group row appears. None of the detail rows appear in excel. Is there a work
around for this?Hi dachrist
Welcome to use MSDN Managed Newsgroup Support.
I have tested on my side with SQL Server 2005 Reporting Services. It works
fine.
Does this appear on all the report?
Could you please post the detail steps here about how to design your report?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I am seeing this behavior in RS2000 sp2.
"Steven Cheng[MSFT]" wrote:
> Hi dachrist
> Welcome to use MSDN Managed Newsgroup Support.
> I have tested on my side with SQL Server 2005 Reporting Services. It works
> fine.
> Does this appear on all the report?
> Could you please post the detail steps here about how to design your report?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi dachrist,
I have tested in Reporting Service 2000.
If you drill down in the report and then export to the excel, it works
fine. Please have a try. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment