Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem with Default value for Parameters Expand / Collapse
Author
Message
Posted Tuesday, November 13, 2012 4:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
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
Post #1384026
Posted Tuesday, November 13, 2012 4:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 12,176, Visits: 9,127
Did you mark param2 as hidden?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1384030
Posted Tuesday, November 13, 2012 6:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
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?
Post #1384057
Posted Tuesday, November 13, 2012 7:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 12,176, Visits: 9,127
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1384069
Posted Tuesday, November 13, 2012 7:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
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..
Post #1384076
Posted Tuesday, November 13, 2012 7:25 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 12,176, Visits: 9,127
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).



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1384085
Posted Tuesday, November 13, 2012 7:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
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..
Post #1384089
Posted Tuesday, November 13, 2012 7:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 12,176, Visits: 9,127
If there is, I haven't found it yet.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1384092
Posted Tuesday, November 13, 2012 7:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 2:14 PM
Points: 100, Visits: 435
Alright!! Thanks
Post #1384093
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse