Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 754
  • Last Modified:

Report Manager - Display reports in two columns

Since our upgrade from R/S 2005 to 2008, the report options display in Report Manager in three columns, with only two lines of report description appearing.  

I would like to go back to the longer descriptions appearing (and preferably the two columns).

Attached are screenshots of how it is now and how it used to be.

Thanks,

Karen
new-old-reporting-services.jpg
0
PetEdge
Asked:
PetEdge
  • 3
  • 2
1 Solution
 
Russell FoxDatabase DeveloperCommented:
Thank for the picture - so much easier to see what you're talking about. There should be a "Details View" button under the search bar, neither of which I see in your image (see mine). My guess is that you're not logged in as an administrator. Generally, the details view will show hidden reports, like sub-reports that you don't want users messing with, so you just allow them to see the tile view. Try adding this to the end of your server url: /Folder.aspx?ViewMode=Detail
Capture.JPG
0
 
PetEdgeAuthor Commented:
Hi Russell,

Thanks but we used to see only two columns in the tile view, which is the view I would like to clean up.

Once again, using the image I posted ("OLD"), you can see how much more of the description is available to the report user and that there are only two columns.

Thanks,

Karen
0
 
Russell FoxDatabase DeveloperCommented:
Okay, I get it now. Those settings are not exposed in any easy way - there's no setting to change or menu that will get you there. To do this kind of customization you're going to have to alter Microsoft's default cascading style sheet (CSS), and possibly alter their default javascript files depending on how much customization you want to do. BACKUP EVERYTHING  before you alter these files in case you break something:
Htmlviewer.css
Provides a sample style sheet that you can use as a template to create custom styles for the report toolbar in HTML Viewer.
The default styles used by HTML Viewer are compiled into the report server. The Htmlviewer.css file provides a sample of the styles that the viewer uses.

ReportingServices.css
Defines styles for Report Manager.

ReportingServices.js
Javascript file.
The javascript file is difficult to read, so try tweaking the CSS first. You'll need to search your SSRS server for these files, but they may be here:
C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager
0
 
Russell FoxDatabase DeveloperCommented:
After playing with it a little, I think you're looking for this entry which I got here:
p.msrs-itemDescription  { white-space: nowrap; width: 250px; overflow: hidden; text-overflow: ellipsis; font-size:10pt; color:Gray; }
If you remove "overflow: hidden;" it will show the entire description but the text will not wrap. You can change "overflow: hidden;" to "overflow: auto;" and it will add a scroll bar so you can scroll over the entire description, but personally I find it kind of annoying. Just play with it a bit, but, again, back it up first.
0
 
PetEdgeAuthor Commented:
Thanks Russell.  Backing up the rss file was key; wish I'd done this prior to upgrading.  The scroll bar prooved too irritating, so I will live with the three column format.  I appreciate the help!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now