Link to home
Start Free TrialLog in
Avatar of dbaSQL
dbaSQLFlag for United States of America

asked on

SSRS -- hover over value OR column in grid report to display vaule

Not sure if this can be done.  I have a repot which just outputs a very simple gridview.  I am adding a new column to the report that will have display one of four values, based on a CASE.  These are the four values:

TOWER FAT, TOWER SALT, TOWERMOIST, TOWERPH

They will be displayed, however, as TF, TS, TM, TP.   I wonder if there is any way to hover over either the values in the report, or the column in the report, and display what each of the abbreviations equate to.  

I guess I have two questions.  A., can I hover over and provide details for the abbreviations above, and B., is it sort of a CASE statement on the single column, to display based on the found value? Something like this:

Switch(Fields![test code].Value = TOWER FAT, "TF", Fields![test code].Value = TOWER SALT, "TS", Fields![test code].Value = TOWER MOIST, "TM",Fields![test code].Value = TOWERPH, "TP", True, "")
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dbaSQL

ASKER

Wow, Pawan.  Thanks!!  I will try to download your example and see what you've done.
Avatar of dbaSQL

ASKER

Hello Pawan.  I am finally looking at your example now, but my current output is a little askew.  Surely these are quickly corrected, but I wonder if you an tell me how.  First, note the headers are crazy exaggerated in size, and secondly, do you see the top row in that first record in the return is blank.  Do you know what element in the report design could be causing either of these problems?
report-output.png
Great that the solution helped , Can you please send me your Rdl. Shall fix it.
Avatar of dbaSQL

ASKER

Unfortunately, I don't think I can send it, Pawan.  Are you able to provide the details I need to correct the header and that first blank record?
What controls are you using? What kind of report it is?
Avatar of dbaSQL

ASKER

The most simple.  It's just a simple grid detail report.
Hi,
Pls increase the column width for all the columns and try...

Also have you press enter between column names?
Hi,

Well the issue is your Header for most of the columns have blank spaces. Remove blank spaces from them and you should be fine. Please try

Hope it helps!
Avatar of dbaSQL

ASKER

Hello Pawan.  This is not a new report.  I have only been asked to make one change, so I cannot really go and change anything outside of the item I am working on.  Hence, I won't worry about the header appearance.  I wonder, however, if you can help explain the last four columns of the report coming back empty, as I showed in the previous attachment.  Any ideas?
Hi dbosql,

The source of the report is a stored procedure and i dont have access to your machine and data. So in that case I can't help with access.  Basically we need dig into the stored procedure why it is not returning data for last 4 columns.

Try executing the stored proc for few scenarios and check.

Hope it helps!
Avatar of dbaSQL

ASKER

Thank you for your example, Pawan.