Monday, March 19, 2012

Issues in SSRS

I need some inputs regarding the

following points related to the SSRS reports:

1. We have a table in

the report and we want to change the display order of the columns when

downloading the report in the CSV format. What could be the possible approach

for this?

2. How to set bookmarks for a report when

downloading the report in the PDF format?

3. We have a table in the report and we

are hiding few cells of the table based on some condition. Now when a particular

cell is made invisible, a blank space exists at the location of that cell. The

requirement is that if we hide one cell, the cell below it must shift above i.e

at the location of the hidden cell.

In SSRS if we hide one row of a table,

then the row below it automatically shifts upwards, but this is not applicable

for a table cell.

Could anyone please provide vaulable

feedback on these points?

Thanks,
S Suresh

1. Not possible

2. Yes, you can create bookmarks for groups in your report by using "Document map label" feature when you edit the group.

3. Instead of having different cells in a row, merge all the cells and then have a rectangle inside that merged cell and then have multiple textboxes inside the rectangle in the same positions as cells were before. When you control the visibility of these textboxes inside a rectangle, they will move up if the visibility of the above cell is hidden.

Shyam

No comments:

Post a Comment