Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Issue with drilldown matrix report - export excel

Author  Topic 

ramya_g
Starting Member

3 Posts

Posted - 2008-05-22 : 20:37:53
Hi,

I have a drilldown matrix report with 2 levels drilldrown. It works fine when I deploy to the report server. But, when exported to excel the "+" sign of the first level drill down appears on the heading of the matrix instead on the data row. (basically, the collapsing + sign appears one row above for the groups defined) Could you please help me fix this issue?

Thanks,
Ramya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-23 : 05:02:30
Can you try increasing hight of matrix 1st row?
Go to Top of Page

ramya_g
Starting Member

3 Posts

Posted - 2008-05-25 : 20:11:25
Hi, It doesn't work. I have attached the screenshot to explain what I meant. You can notice that "+" appears one row above for each data row; (the first + appears at the heading.)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-25 : 21:50:18
Your image is not visible to us from C:\excelissue.jpg. You must upload it to a web server for us to see it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

ramya_g
Starting Member

3 Posts

Posted - 2008-05-26 : 20:14:16
The image looks pretty much like this

+ col1 col2 col3
+ row1 1 1.5 3
+ row2 7.5 6.3 2
row3 6 2 5.7

So, you can see that + sign appears one row above the data row.

Thanks,
Ramya
Go to Top of Page
   

- Advertisement -