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