none
dependent parameters

    Question

  • hi dear support!

    i have a multi-value integer parameter (w/o NULL) with dates-months in format "YYYYMMDD",i.e. 20130131,20130228...20120131,20120229 etc...

    else i have 2 other multi-value parameters for year 2013 and 2012 with the same values as in the first parameter. I need to populate DEFAULTS of these 2 params depending on the selected values of the 1st parameter.

    I specify the DEFAULTS for each of those 2 params, but they populate only if i choose values in the 1st param starting with 2013 OR 2012...if i select some values starting with 2013 and some starting with 2012, the dafaults of the 2 parameters are empty.

    Help me please.

    Thanx.

    Wednesday, October 09, 2013 6:41 AM

Answers

All replies

  • Hello,

    If I understand correctly, you have add three parameters in your report. These parameters with the same values. The default values of Parameter2 and Paramter3 is depending on the Parameter1, and will fill with the same values of Parameter1.

    I created a simple report in my test environment, and achieved the result. You can refer to the steps below:
    1. I created three datasets DataSet1, DataSet2, DateSet3 with the same query code.
    2. Add three parameters in the report, set “Get values from a query”. Get values from DataSet1, DataSet2, DateSet3.
    3. Right-click ReportParameter2, select Parameter Properties. Set the Default Values with “Specify values”.
    4. Click Add icon below. Click the expression bottom, and type the expression in the text box: =Parameters!ReportParameter1.Value
    5. Configure ReportParameter3 with the same setting.

    You can refer to the screen shots below:
     
    Preview the report:

    If there are any misunderstanding, please elaborate the issue for further investigation.

    Regards,
    Alisa Tang


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    Friday, October 11, 2013 9:46 AM
  • Not exactly.

    let`s assume Dataset1 has values (YYYYMMDD format) :20120131,20120229,20120331...etc...up to 20131231

    Dataset2 has values (YYYYMMDD format):20130131,20130228...etc...to 20131231

    Dataset3 has values (YYYYMMDD format):20120131,20120229...etc...to 20121231

    ReportParameter1 available values come from Dataset1.

    ReportParameter2  and RepParam3 are cascading parameters and their DEFAULTS come from RepParam1 choice.

    BUT!!! RepParam2 available values come from Dataset2 and RepParam3 avaialable values come from Dataset3.

    If i select in RepParam1 values for year 2013 (20130131,20130228...etc) DEFAULTS of RepParam2 will be CORRECTLY selected. the same thing for RepParam2, if i select values for year 2012 in RepParam1.

    If i select, for example, in RepParam1 20130131 and 20120131 defaults in Param2 and Param3 will be EMPTY - that`s the problem :)

    Friday, October 11, 2013 1:05 PM
  • Hello,

    Thank you for your reply.

    As you post, I can reproduce the issue. I tried to work around the issue in my test environment. You can refer to the following steps, maybe it would help you.
    1. I created DataSet2 with the query:
        Select TimeDate
        From Demo1
        Where TimeDate in (@ReportParameter1)
    2. Configure ReportParameter2 Available Values with Get values from a query from DataSet2.
    3. Configure ReportParameter2 Default Values with Get values from a query from DataSet2.
    4. Created DataSet3 and ReportParameter3 with the same method.

    You can refer to the screen shot below.
     
    However, because of ReportParameter2 and ReportParameter3 is related with ReportParameter1, we cannot select with one year values. Could you post more information about your requires? Maybe we can use another method to work around the issue.

    Regards,
    Alisa Tang


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    Saturday, October 19, 2013 6:11 AM