Condition for table in Report builder 3.0
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
May 31st, 2012 9:39am

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)
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2012 9:59am

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
May 31st, 2012 10:10am

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)
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2012 10:18am

Hi Sandip, It worked. Thanks Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad
May 31st, 2012 10:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics