Is there something special that needs to be done? Could I have an old file?
Could it be something in my report? We always have the following components:
-- textboxes in the page header and footer
-- page header refers to parameter values; page footer refers to globals
-- 2 date parameters and 1 hidden boolean parameters
We're running SQL 2005 Reporting Services, and I have SP2 installed.
(I write the reports, not the web app)
It turns out a report parameter and a field in the dataset had the same name.
SELECT *, bad=@.bad FROM Employees
Changing the parameter name fixed it.
SELECT *, bad=@.notBadAtAll FROM Employees
No comments:
Post a Comment