February 25, 2015 at 9:57 am
In an existing .net application that allows users to execute SSRS 2012 reports, I want to leave the value in the database as a numeric value but display all the applicable values in the SSRS report as char(3) values. Basically every place that a '999' is the real value in the database, I want the SSRS 2012 reports to display a value of 'OWN'. I want to see if this is an option since this would be a major rewrite for the .net application. Thus I have the following questions:
1. When the user selects parameter values is there a way to display 'OWN' instead of '999' in the dropdown list for parameter values that can be selected? If this is a possibility, would you show me how to change the display of the parameter value?
2. When the detail line is displayed in the ssrs 2012 report, would you show me how to change the value displayed in the detail of the SSRS 2012 report? If this is not possible in the SSRS 2012 report, would I need to change the values that are brought into the report in the original sql? Would I need to do a 'replace' in the sql?
3. In one of the SSRS 2012 reports the header displays the value of 999, would you show me how to change the header of the report so 'OWN' displays instead of 999?
February 25, 2015 at 5:03 pm
If you're in your dataset, you'd create a calculated column and use IIF(Parameters!MyParam="9999","ShowThis","Show That") Then just use the calculated value instead of the numeric value. Then you can filter by that. If you don't need to filter by it, you can create a calculated column in your report.
February 26, 2015 at 8:31 am
According to your answer, "If you're in your dataset, you'd create a calculated column and use IIF(Parameters!MyParam="9999","ShowThis","Show That")", I would like to know how to setup this option using a dataset. How will the number values plus the value of 'OWN' show up in the dropdown list for the user to select?
February 26, 2015 at 12:41 pm
Most if this is trivial once you set up the calculated column/field/whatever you call it in the dataset. Then anywhere you want to show this value, you'd use the calculated field instead of the original value. You could still filter on either one, though.
If that doesn't help, could you post a really small dataset, then I can upload a dummy report.
So you would have
"OWN"
123
125
....
That's easy. Use another column (hidden) in the dataset that you sort by as the source for your values... for example:
SELECT "OWN" AS SomeGroup, 999 AS SortValue
UNION ALL
SELECT TextColumn, ColumnID
FROM MySourceTable
ORDER BY SortValue
If I completely missed the mark, post a dummy report with enough data to make it clear what you're doing. Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply