in which i'm passing 3 parameter to the query
the third one is calculated on the basis of other two
when the there is no data in first two fields there is no data then the third field is disable but when the value is inserted in the two fields then the third field is enabled
i dont want the third field to be enabled even if the calculated data is comes inside the third field
Member
2 Points
19 Posts
Disable a Calculated Parameter ssrs report 2008 r2
Sep 30, 2013 07:17 AM|write2varun|LINK
Hi,
I have a Report created in SQl Server 2008 r2,
in which i'm passing 3 parameter to the query
the third one is calculated on the basis of other two
when the there is no data in first two fields there is no data then the third field is disable but when the value is inserted in the two fields then the third field is enabled
i dont want the third field to be enabled even if the calculated data is comes inside the third field
before value
after value
P.S. I'm new with ssrs report
thank you
SSRS SQLServer2008R2
Member
220 Points
64 Posts
Re: Disable a Calculated Parameter ssrs report 2008 r2
Sep 30, 2013 08:09 AM|Abhi.ssrs|LINK
Can you please elaborate or give a screenshot. This is pretty vague to give a solution.
SSRS SQLServer2008R2
Member
2 Points
19 Posts
Re: Disable a Calculated Parameter ssrs report 2008 r2
Sep 30, 2013 08:44 AM|write2varun|LINK
i uploaded the screen shorts i hope it helps
SSRS SQLServer2008R2
Participant
1061 Points
332 Posts
Re: Disable a Calculated Parameter ssrs report 2008 r2
Oct 07, 2013 10:40 AM|MSDN_ice|LINK
Hi,
# Right click the textbox and select Format Field
# Select the Common tab
# Click the Formula button next to the Suppress
# Change the formula to something like
aways be true
# Click Save and Close
That should about do it. Thanks.
SSRS SQLServer2008R2