Solved

Report Manager - Display reports in two columns

Posted on 2014-07-31
5
662 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
  • 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now