Complex Report Design Questions
Posted: Wed Apr 20, 2011 11:46 am
I have been tasked with designing a report, with the ViewerFx, which is somewhat complicated. I'll provide the general layout below, and I'm looking for info on how to do this in a single report, or at least as few subtypes as possible.
We need a mechanism by which the end user can select one of three subtypes of report. These correlate directly to Groups (by date, by product, by account).
We need to be able to choose between full details and summary info, or just the summary info (by group, of course).
Finally, we have a handful of columns which are optionally displayed. They exist in all the above configurations, but should only be rendered when requested. As a final difficulty, the optional columns must be presented in a "float: right" type of display, so I can't just simply hide/show them, but rather need them to be all pushed to the right margin.
Can you explain to me the best approach to solving each of these distinct problems? Is it possible to have a single 'master report' that displays only certain subtypes (groupings)? Can the detail layer be turned off via some kind of parameter mechanism (either collected before report display, or after...). Same question for the optional columns; is there a way to pass in variables, or to ask of the user at runtime, about the values of these options, and then adjust the report columns dynamically based on the selections?
Thanks much.
We need a mechanism by which the end user can select one of three subtypes of report. These correlate directly to Groups (by date, by product, by account).
We need to be able to choose between full details and summary info, or just the summary info (by group, of course).
Finally, we have a handful of columns which are optionally displayed. They exist in all the above configurations, but should only be rendered when requested. As a final difficulty, the optional columns must be presented in a "float: right" type of display, so I can't just simply hide/show them, but rather need them to be all pushed to the right margin.
Can you explain to me the best approach to solving each of these distinct problems? Is it possible to have a single 'master report' that displays only certain subtypes (groupings)? Can the detail layer be turned off via some kind of parameter mechanism (either collected before report display, or after...). Same question for the optional columns; is there a way to pass in variables, or to ask of the user at runtime, about the values of these options, and then adjust the report columns dynamically based on the selections?
Thanks much.