asked on SSRS sql paramater that works in Query Designer but not in the report
I have a parameter in a where statement that works fine when I am using query designer in SSRS 2008. But when I go back out to the report section, I get a pop up screen that says define query paramaters and my parameter that I used has been stripped from the code or all of the fields in the dataset are gone. The parm I'm having an issue with is the @Days. If I substitute 90 for the @Days in query designer, it works in both the query designer and the SSRS report... I'm not quite sure how to fix this... Can anybody help?
WHERE (FACT_GiftCommitment.Balan
WHERE (FACT_GiftCommitment.Balan
SSRS
Last Comment
cindyfiller
- @Days should really be -1 * @Days
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Yes that popup was asking for the values of the parameters. In the past when I saw that pop up I thought there was an error and would click out of it and go back to try and fix the program. I'd never tried entering the values again. Wow - that actually solved the problem. Learned a good lesson today.