July 12, 2016 at 4:09 am
I wonder how to proceed
My table structure is
Year State Division school studentpass studentfail
2015 State1 Div1 ScH1 6 2
2015 State1 Div1 ScH2 4 5
2015 State1 Div1 ScH3 2 4
2015 State1 Div2 ScH4 8 7
2015 State1 Div2 ScH5 3 9
2015 State1 Div2 ScH6 9 1
2015 State1 Div2 ScH7 6 4
2015 State1 Div3 ScH8 5 5
2015 State1 Div3 ScH9 10 9
2015 State1 Div4 ScH10 3 2
2015 State1 Div4 ScH11 7 5
2015 State1 Div4 ScH12 1 3
In my report there are multiple parameters.Let say when the user select the state 1 and the year 2015.
My requirement is to display the report in tabular format whose no of rows is equal to the no of distinct division (in the state selected) and no of column is equal to
one greater than maximum no of schools present in those divisions(for example here Div2 has maximum no of school i.e 4) so 4+1 columns are created.
Now row1column1 cell contain a pie chart which display no of studentpass and studentfail for school(ScH1).
row1column2 cell contain a pie chart which display no of studentpass and studentfail for school(ScH2).
row1column3 cell contain a pie chart which display no of studentpass and studentfail for school(ScH3).
row1column4 will be vacant.
.... row1columnn5 cell contain a pie chart which display the aggregate no of studentpass and studentfail for Division(Div1).
Now row2column1 cell contain a pie chart which display no of studentpass and studentfail for school(ScH4).
row2column2 cell contain a pie chart which display no of studentpass and studentfail for school(ScH5).
row2column3 cell contain a contain a pie chart which display no of studentpass and studentfail for school(ScH6).
row2column4 cell contain a contain a pie chart which display no of studentpass and studentfail for school(ScH7).
.... rowcolumnn5 cell contain a pie chart which display the aggregate no of studentpass and studentfail for that Division(Div2).
Similarly we will do for rest of the rows.
The issue is that both the no of rows and columns are dynamic.
I think I am able to give some idea of my report.Please get back to me if need more clarification.
And please suggest any idea to achieve this
Thanks.
joy
July 12, 2016 at 8:10 am
You're describing a matrix. You can add a totals column if you wish as part of the matrix.
July 12, 2016 at 10:14 pm
Thanks pietlinden.
It is a matrix.One more help How to hide or remove the data cell which does not contain any data and are displaying "No Data Available".
Regards,
Joy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply