March 8, 2011 at 12:26 pm
I am creating a report in SSRS 2008. Requirement is such that I need to create a Dynamic table structure. Based on certain selection in parameters, table need to show, say 8 columns and for a different selection of same parameter table needs to show, say 10 columns.
The point here is that the columns in these tables are not normal columns, rather they are Group Columns and on such Group columns the Column Visibility property is disabled. I tried using the .IsMissing property but that only Hides the column and doesn't shrink the table, this creates an annoying white space between columns.
Any help would be very much appreciated.
Example -
Col1 = Country, Col2 = State, Col3 = CIty and COl4,5,6 etc have measures...
I am interested in Visibility of Col2 and Col3.
When I select Col1= say, India, I need to Hide Col2 and Col3 and show values only for Country level, India.
When I select parameter for State and say 'Maharashtra'(this can be multivalued and I can select more than 1 state), run the report, now I should see Col2 populated with 'Maharashtra'. Col3 though should still be hidden.
When I select the value for the third Parameter and say City = 'Mumbai', Now I should see Col3 as well with Mumbai City and values in Col4,5,6 etc for this selection. Again, City is multi valued parameter.
Hope I have made my point clear.
March 8, 2011 at 2:13 pm
Not that you won;t get help here, but you may be better off posting this in an SSRS forum: http://www.sqlservercentral.com/Forums/Group416.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 8, 2011 at 2:21 pm
Thanks so much
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply