I'm facing a weird problem with a Report Builder 1.0 report. The report has two filters: a Start Date and an End Date. I have selected the "prompt" property of these filters to use them as report parameters. When I run the report in Test, it runs just fine
and shows correct data as per selected filters. When I copy the report to Production, it again runs fine.
The problem begins if I try to make any changes to the report in Production. I open the report in RB 1.0 and add another column. When I now run the report, it returns ALL the records in the DB regardless of the Start Date and End Date specified. Strangely,
this does not happen when I change the report in the test environment.
Any ideas on why this could be happening will be very much appreciated!
View Complete Post