locked
Pass values to dril down report RRS feed

  • Question

  • I have a drill down report that has 2 parameters, from teh main report page I want to be able to pass down certian parameters that are integers.

    THe values are categroy and subcategory, from the main report you can pass in the paramerters and I pick the parameter but my question is how can I pass multiple parameters the field only takes 1.  If I put in 1,2,3 in the sub category field while using the action fucntion from main report it errors out.

    If I put them in brackets (1,2,3) it still errors out.  I put on defaults on the sub report but he problem is that a person has to go back and pick the correct ones, how can I pass multiple parameters from main to sub report.

    1st Parmeter  (Category)  Ids that can pass are 1,2,3 or all together

    2nd parameter (SubCategory)  Id are from 1 to 12 but subcategorized from 1st parameter but I want to be able to pass more than one.

    Friday, November 18, 2011 6:50 PM

Answers

  • Hi kedeutsch,

    Thanks for the question. If my understanding is correct, you would like to pass 1,2,3 as the values from main report to the sub report’s parameter @Category, right? If so, I would give you two approaches:

    1. Using Split and Join function to achieve the target.

    =Join(Split("1,2,3",","),",")

     Note that this expression based on the assuming that the @Category in Text data type. If you want to use the @Category in Integer data type, please format it from Text into Integer firstly.

    2. Add one parameter in the main report to contain the 1,2,3, such as @mCategory, then passing @mCategory’s value to the sub report.

    Please add the 1,2,3 as @mCategory’s Available values, then passing its values to @Category by using :

    =Join(Parameters!p2.Value,",")

    Thanks,
    Sharp Wang

      


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by Sharp Wang Tuesday, November 22, 2011 1:26 AM
    • Marked as answer by Sharp Wang Friday, November 25, 2011 2:22 AM
    Monday, November 21, 2011 9:57 AM

All replies

  • Hi kedeutsch,

    Thanks for the question. If my understanding is correct, you would like to pass 1,2,3 as the values from main report to the sub report’s parameter @Category, right? If so, I would give you two approaches:

    1. Using Split and Join function to achieve the target.

    =Join(Split("1,2,3",","),",")

     Note that this expression based on the assuming that the @Category in Text data type. If you want to use the @Category in Integer data type, please format it from Text into Integer firstly.

    2. Add one parameter in the main report to contain the 1,2,3, such as @mCategory, then passing @mCategory’s value to the sub report.

    Please add the 1,2,3 as @mCategory’s Available values, then passing its values to @Category by using :

    =Join(Parameters!p2.Value,",")

    Thanks,
    Sharp Wang

      


    Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
    • Proposed as answer by Sharp Wang Tuesday, November 22, 2011 1:26 AM
    • Marked as answer by Sharp Wang Friday, November 25, 2011 2:22 AM
    Monday, November 21, 2011 9:57 AM
  • Your post is highly informative. I appreciate your efforts.

    http://www.bestgrandprairieplumbing.com
    http://www.sharpelizabethplumbing.com
    http://www.scotchplainsplumbing.com
    http://www.nicefortlauderdaleplumbing.com

    • Edited by Plumbing007 Monday, November 21, 2011 11:43 AM
    Monday, November 21, 2011 11:28 AM