question

adesai018 avatar image
adesai018 asked

How to remove extra row in drill down report in SSRS while exporting in to excel?

I am using SSRS to create report. I have created one drilldown report using matrix. It is having row groups and one column group in matrix. When i am running the report in SSDT there is no extra row is showing in grouping. **SSDT Design and Report Output:** ![alt text][1] Same report when i am exporting into Excel it is showing some extra row on each row group (Highlighted in Yellow) ![alt text][2] I have tried with all possible grouping steps, but not able to hide these extra rows in Excel export. Can anybody help me to fix this. [1]: /storage/temp/3519-test24.png [2]: /storage/temp/3520-test-2.png
reportingreportgrouping
test24.png (34.7 KiB)
test-2.png (23.2 KiB)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
surbhi_mishra avatar image
surbhi_mishra answered
firstly split first column after that add extra row(group after total row) then hide that total row (Row Visibility) .
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.