SSRS sql paramater that works in Query Designer but not in the report
Posted on 2016-09-27
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.BalanceAmount = 0) AND (FACT_GiftCommitment.LastPaymentDate BETWEEN @BeginDate AND @EndDate) AND (DATEADD(dd, - @Days, FACT_GiftCommitment.LastInstallmentDate) > FACT_GiftCommitment.LastPaymentDate)