dbaSQL
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, "")
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
report-output.png
Great that the solution helped , Can you please send me your Rdl. Shall fix it.
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?
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?
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!
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!
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!
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!
ASKER
Thank you for your example, Pawan.
ASKER