March 8, 2011 at 2:23 pm
Hi,
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.
Also note that col1, col2, col3 are also groups, So records would be grouped by City, State, Country in the report. This is what I mean by saying Group Columns.
Hope I have made my point clear...
June 11, 2015 at 1:20 pm
Does anyone have an answer to this question? I have a similar problem!
June 17, 2015 at 2:20 am
Hi Laurel,
Its long time back and I don't remember now the fix I have got at that time. Would I have cared posting the solution then it would have been helpful to you now.
Anyways, for some reason I remember that I wasn't able to control this behaviour from SSRS design, instead I have changed the Source query accordingly to return the required number of columns only. So the source DataSet query would accept the Parameters and accordingly return only required columns.
But as I said, I really don't remember now the fix very well. I would be glad if this info is of any help to you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply