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?

Hi wendy,

Based on my understanding, the numeric value 999 exists in the database, then you want to display the value as OWN in the drop-down list of the parameter, detail rows and page header, right?

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?

For this requirement, you can create a parameter and specify the data type as Integer on General page, then specify the label as OWN and corresponding value as 999.

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?

For this requirement, you can specify the value in the tablix like below:
=IIF(Fields!value.Value=999,"OWN",Fields!value.Value)

Then use the parameter to filter data.

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?

For this requirement, you can also specify the expression as below:
=IIF(Fields!value.Value=999,"OWN",Fields!value.Value)

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Thank you very much for your answers so far! They have been extremely helpful!

I do have one more question to ask about parameter values. The other  parameter numeric  values are valid. Some of the other numeric parameter values are:

05,10, 15,20,30, 40, 50, and 60.

I want these parameter values to be displayed also. Thus can you tell me and/or show me what I need to do to make the parameter values I just listed above and the 'OWN' display as parameter values in the dropdown list for the user to select?

Hi wendy,

You can specify the available values for the parameter as those numeric values, please refer to screenshots below:

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu