Disable a Calculated Parameter ssrs report using SQL Server 2008 r2

Posted by Write2varun under Sql Server on 9/30/2013 | Points: 10 | Views : 957 | Status : [Member] | Replies : 2
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

[URL=http://s869.photobucket.com/user/write2varun/media/1_zps8a4fd3aa.jpg.html][/URL]

after value

[URL=http://s869.photobucket.com/user/write2varun/media/2_zps7daa7ee8.jpg.html][/URL]

P.S. I'm new with ssrs report

thank you




Responses

Posted by: Bandi on: 9/30/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Alternate for the above scenario:
Instead of report parameter add one textbox in Page Header
1) Right-click on empty area (just below the report design area)
2) Click on "Add Page Header"
3) Place one TextBox and then write expression as follows:
Assume that your calculation for third parameter is concatenation of first & Second parameters
   Parameter!ParamName1.Value + "-" + Parameter!ParamName2.Value


Then it will display the calculated value at runtime.. We cannot change the value in report...

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Write2varun, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 9/30/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
>> which i'm passing 3 parameter to the query

For this add filter in the main dataset by using first two report params and same calculation

Refer:
http://prologika.com/CS/forums/p/1020/3664.aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Write2varun, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response