locked
How to include the selected criteria in the generated report's header? RRS feed

  • Question

  • Prior to the generating of my report, I prompt the user to select six criteria/parameters--three data-driven dropdowns (each set to allow multiple values), one static dropdown, and starting and ending dates. I would like to include all of the selected criteria in the generated report's header. Is that possible?

    How to display report's selection criteria gave me some pointers, but I didn't have much success. When I add a textbox to the header and define it to use:

    • the .Label of one of my data-driven dropdown's parameters (i.e., "=Parameters!ParamTerritoryCode.Label"), BIDS displays a "The Value expression used in textrun "Textbox12.Paragraphs[0].TextRuns[0]' returned a data type that is not valid" warning but allows me to proceed. The generated report, however, displays "#Error" in the textbox.
    • the .Value of the same parameter (i.e., "=Parameters!ParamTerritoryCode.Value"), BIDS displays the same error and the same "#Error" in the generated report's textbox.
    • the .Value(0) of the same parameter (i.e., "=Parameters!ParamTerritoryCode.Value(0)"), BIDS displays the same error but displays only the first selected item in the corresponding dropdown. Since the user can select more than one value -- including the "(Select All") value -- I'm not sure how to effectively display the criteria in the generated report's textbox.

    Any suggestions?


    Chris



    • Edited by cgwaters Monday, January 7, 2013 4:57 PM
    Monday, January 7, 2013 4:52 PM

Answers

  • Hi Chris,

    Based on your description, you want to display the parameter values in the page header and some of the parametes are allow multiple vlaues. 

    To return the multi-value of the parameter, please refer to the following expression:
    =Join(Parameters!ParamTerritoryCode.Label," ").  

    The expression "Parameters!ParamTerritoryCode.Value(0)" will return the first Available Value from the Selected values in drop-down list of the parameter.

    If you have any question, please let me know.

    If you have any feedback on our support, please click here .

    Regards,
    Fanny Liu

    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Fanny Liu Friday, January 11, 2013 3:17 AM
    • Marked as answer by Fanny Liu Monday, January 14, 2013 1:20 AM
    Tuesday, January 8, 2013 2:54 AM