locked
Condition for table in Report builder 3.0 RRS feed

  • Question

  • Hello all,

    I have created one parameter "Entity_Name" and two table "Entity_Lead" and "Entity_Opportunity" in my table.

    Entity_name parameter have two value 1)Lead 2)Opportunity

    what i want is, when lead is selected from parameter only Entity_Lead table is visible and Entity_opportunity table is become hidden.and vice verse for Opportunity.

    so, what is the way to put this condition.

    This is my first dynamic report in RB. so, please explain in detail.


    Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad

    Thursday, May 31, 2012 1:35 PM

Answers

  • Kartik,

    Assuming you have parameter called "Entity_Name" with available values Lead & Opportunity. On your report you have two tables

    Select first table/tablix called "Entity_Lead" go to properties >>  Hidden & write following expression

    =IIF(Parameters!Entity_Name.Value="Lead",False,True)


    Select second table/tablix called "Entity_Opportunity" go to properties >>  Hidden & write following expression

    =IIF(Parameters!Entity_Name.Value="Lead",True,False)

    You are good with yor first dynamic report with RB


    Thanks,
    Sandip Shinde(Blog:bi-bigdata.com|Twitter:@CloudBI_Sandip)

    Thursday, May 31, 2012 1:56 PM
  • Kartik,

    I noticed that your parameters does not have values they just has labels to it. Any dropdown/multivalue parameters you have always label & value.

    If you do not want to use values here then try following expression for first table/tablix

    =IIF(Parameters!Entity_Name.Label="Lead",False,True)

    Normally if you have values to your parameter as shown in following screen then my expression in previous reply will work

    Let me know if you have any queries.


    Thanks,
    Sandip Shinde(Blog:bi-bigdata.com|Twitter:@CloudBI_Sandip)

    Thursday, May 31, 2012 2:14 PM

All replies

  • Kartik,

    Assuming you have parameter called "Entity_Name" with available values Lead & Opportunity. On your report you have two tables

    Select first table/tablix called "Entity_Lead" go to properties >>  Hidden & write following expression

    =IIF(Parameters!Entity_Name.Value="Lead",False,True)


    Select second table/tablix called "Entity_Opportunity" go to properties >>  Hidden & write following expression

    =IIF(Parameters!Entity_Name.Value="Lead",True,False)

    You are good with yor first dynamic report with RB


    Thanks,
    Sandip Shinde(Blog:bi-bigdata.com|Twitter:@CloudBI_Sandip)

    Thursday, May 31, 2012 1:56 PM
  • Hi sandip,

    thanks for your reply.

    i have followed your step but i failed. i got blank screen when i select any of the parameter.

    am i missing any step???

    my doubt is in parameter property. Please see below image. is it correct?? or i have to provide any value.


    Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad



    Thursday, May 31, 2012 2:07 PM
  • Kartik,

    I noticed that your parameters does not have values they just has labels to it. Any dropdown/multivalue parameters you have always label & value.

    If you do not want to use values here then try following expression for first table/tablix

    =IIF(Parameters!Entity_Name.Label="Lead",False,True)

    Normally if you have values to your parameter as shown in following screen then my expression in previous reply will work

    Let me know if you have any queries.


    Thanks,
    Sandip Shinde(Blog:bi-bigdata.com|Twitter:@CloudBI_Sandip)

    Thursday, May 31, 2012 2:14 PM
  • Hi Sandip,

    It worked.

    Thanks


    Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad


    Thursday, May 31, 2012 2:20 PM