November 13, 2012 at 4:16 am
Hi all,
Problem with setting default values to a paramater with true or false condition.
I have 2 reports and I am navingating from report 1 to report 2 using a textbox.
Report 1 :
I have two paramaters passing from report one.
Param 1: gets data from the defined paramater dataset
Param 2: Check for a condition like =iif(1=1,true,false) (some dummy condition)
In report 2, even though I specify values for available/default values(for reportparameter2), it is not taking it into account.
Every time I drill down to report 2 from report 1, the drop down of reportparameter2 is shown. Can we set it to a default value?
Thanks
November 13, 2012 at 4:47 am
Did you mark param2 as hidden?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2012 at 6:47 am
No where the parameters are hidden in any of the reports.
While navigating from Repor 1-> Report 2, I wanted to set a default value for Reportparameter2. I am not able to set a default value at all...
I wanted to set a default value.. I suspect default values cannot be set if a parameter accepts true /false condition.. I am not sure thou
Any help?
November 13, 2012 at 7:01 am
I tried it myself, and I could set a default value for a boolean parameter without a problem.
How did you try to set the default value?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2012 at 7:15 am
Ya as u say if we set the parameter to Boolean then we are able to set a default value.
But as we deploy the reports, and when we navigate from report1 ->report 2, the entire paramater tab is getting hidden automatically.
Every time I got click on the button show/hide parameters. In order to avoid this issue, I am trying to create a dummy param say iif 1=1,true/false... In such a case when I deploy, the parameter selection tab doesnt get hidden. I thot this would be a work around to display the parameter tab always..
November 13, 2012 at 7:25 am
Ah ok, now I get it. As far as I know, this is a common issue with drillthrough reports. If you drillthrough, the prompt area is hidden (unfortunately).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2012 at 7:28 am
Ya true 🙁
Is there any work around for it??
One option is : Jump to URL... But I wannted to check if there is any other way for Drill through reports using Jump to report option itself...
Thanks for ur responses. Much Appreciated if any work around is there for it..
November 13, 2012 at 7:30 am
If there is, I haven't found it yet.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2012 at 7:31 am
Alright!! Thanks
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply