Dynamic Column

Question

Hi Gurus,

i have following things in my report.

1. parametrs with Month name (jan,feb,mar..Dec)

2. Storeted procedure( sending   month selected parameter to SP )

SP Returns jan,feb,mar if we are sending mar parameter

i want to display the report with only SP RETURN Columns only and disable rest of the columns.

how can we display the dynamic columns.

Please let meknow how can we achive this.

Answer 1

Hi Vamsi1980,

In the Column visibility, you can write the expression for the report as,

=iif(Fields!monthname.value = Parameters!month.label,true,false)

Please revert if this doesnot work.

---

Thanks in advance, Akhila Vasishta

Answer 2

Not sure if I fully understand your question but I think you're describing dynamic datasets? In other words, sometimes your dataset contains the Jan column, sometimes it does not, and so on?

In that case I think you'll benefit from reading this article: Building Reports With Dynamic Datasets

---

MCITP SQL Server 2008 (BI & DEV); MCTS SQL Server 2008 (BI, DEV & DBA)
Check out my articles at BI: Beer Intelligence?

Answer 3

Hi,

Try using IsMissing visibility function,here is an example - http://sathyadb.blogspot.in/2013/01/ssrs-ismissing-visibility-function.html

---

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