locked
How To Create Dynamic SSRS RDL File???? RRS feed

  • Question

  • I want to create rdl file where Report Columns(no of columns) will change base on the parameter selected by the user..

    So is it possible to create this type of rdl??

    if yes plese guide me step by step process for it  

    Tuesday, December 31, 2013 9:37 AM

Answers

  • Hi Mahendra_007,

    If I understand correctly, you want to use parameter to control report columns’ Visibility.

    Suppose we have a dataset (Sales) with following fields: SalesTerritoryGroup, SalesTerritoryCountry, CalendarYear, SalesAmount. Please refer to the following steps:

    1. Add a table in the report body. Then, add these four fields in the table.
    2. Create a parameter (Hide) configure with following values:
      Available Values:
      “Specify values”
      Label: SalesTerritoryGroup              Value: SalesTerritoryGroup
      Label: SalesTerritoryCountry              Value: SalesTerritoryCountry
    3. Click the blank arrow after “Column Groups” icon in the Groups dialog box. And select “Advanced Mode”.
    4. Click the first “(Static)” icon.
    5. Select "Hidden" property in the Properties dialog box, and fill with following expression:
      =IIF(Parameters!Hide.Value=” SalesTerritoryGroup”, True, False)
    6. Use the same method configure the second static column.

    Please refer to the following screenshot:
     
    If you have any questions, please feel free to ask.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Proposed as answer by Uri DimantMVP Wednesday, January 1, 2014 6:28 AM
    • Marked as answer by Alisa Tang Monday, January 6, 2014 1:04 AM
    Wednesday, January 1, 2014 2:48 AM
  • Hi,

    Try below links for some examples :

    http://www.allaboutmssql.com/2013/01/ssrs-ismissing-visibility-function.html

    http://social.technet.microsoft.com/wiki/contents/articles/19333.ssrs-how-to-set-column-visibility-property-for-many-columns-based-on-parameter-s-value.aspx


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    • Marked as answer by Alisa Tang Monday, January 6, 2014 1:04 AM
    Wednesday, January 1, 2014 2:56 AM

All replies

  • Well your question is very vague. You will have create different report layouts for different parameters. For instance Parameter A create a table or a matrix layout and set its visibility just for Parameter A and do the same for all the different parameters.

    Hope this helps....let me know should you have more questions.............


    Ione

    Tuesday, December 31, 2013 4:06 PM
  • Hi Mahendra_007,

    If I understand correctly, you want to use parameter to control report columns’ Visibility.

    Suppose we have a dataset (Sales) with following fields: SalesTerritoryGroup, SalesTerritoryCountry, CalendarYear, SalesAmount. Please refer to the following steps:

    1. Add a table in the report body. Then, add these four fields in the table.
    2. Create a parameter (Hide) configure with following values:
      Available Values:
      “Specify values”
      Label: SalesTerritoryGroup              Value: SalesTerritoryGroup
      Label: SalesTerritoryCountry              Value: SalesTerritoryCountry
    3. Click the blank arrow after “Column Groups” icon in the Groups dialog box. And select “Advanced Mode”.
    4. Click the first “(Static)” icon.
    5. Select "Hidden" property in the Properties dialog box, and fill with following expression:
      =IIF(Parameters!Hide.Value=” SalesTerritoryGroup”, True, False)
    6. Use the same method configure the second static column.

    Please refer to the following screenshot:
     
    If you have any questions, please feel free to ask.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    • Proposed as answer by Uri DimantMVP Wednesday, January 1, 2014 6:28 AM
    • Marked as answer by Alisa Tang Monday, January 6, 2014 1:04 AM
    Wednesday, January 1, 2014 2:48 AM
  • Hi,

    Try below links for some examples :

    http://www.allaboutmssql.com/2013/01/ssrs-ismissing-visibility-function.html

    http://social.technet.microsoft.com/wiki/contents/articles/19333.ssrs-how-to-set-column-visibility-property-for-many-columns-based-on-parameter-s-value.aspx


    sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.

    • Marked as answer by Alisa Tang Monday, January 6, 2014 1:04 AM
    Wednesday, January 1, 2014 2:56 AM