Solved

Report Manager - Display reports in two columns

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Reporting Services Date Issue 2 48
SSRS Report error in deployment 5 209
SSRS Status field from text to number 2 37
Executing multiple ssrs reports from ssis package 20 53
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.   …
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 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