Solved

Report Manager - Display reports in two columns

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Optimization of SQL Stored Procedure 7 72
SSRS Report Runtime Error 20 57
Grid querry results 41 78
SQL Server 2008 R2 - Sums/Grouping 7 60
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

809 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