Wednesday, 15 September 2010

sql - SSRS 2008 Add value to parameter resultset -


We have implemented a new system-only read-only feature for the database Writing reports for current and historical data Using the drill through the report to display the number of places and people, calculate the location and go to the details.

I query the location table to populate the parameter values. It works properly

What I want is to add "pre-implementation" to the parameter result, which exists from the tap, because the data was before the date of implementation. The phrase needs to appear in the drop-down list of locations so that users can choose it. The above mentioned phrase needs to appear on the report. How would you do this?

Whatever I have tried: ask questions which give "pre-implementation", as well as active location for time period. SSRS will not display as a substitute in a drill through the report.


No comments:

Post a Comment