Solved

Report Manager - Display reports in two columns

Posted on 2014-07-31
5
710 Views
Last Modified: 2014-08-05
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
Comment
Question by:PetEdge
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40232459
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
 

Author Comment

by:PetEdge
ID: 40241739
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
 
LVL 13

Accepted Solution

by:
Russell Fox earned 500 total points
ID: 40241819
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
 
LVL 13

Expert Comment

by:Russell Fox
ID: 40241902
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
 

Author Closing Comment

by:PetEdge
ID: 40242042
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question