Complex Report Design Questions

brianj774 · Post by **brianj774** » 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.

Post by **Vladimir** » Thu Apr 21, 2011 5:49 am

Hello,

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...).

If we understand you correctly, then, as an option, you can create several templates and reports and, in your application, give the user the ability to select the required type.

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?

In this case, you can use the "Request from User" variables and Conditions. Please see the attached sample report.

Thank you.

brianj774 · Post by **brianj774** » Thu Apr 21, 2011 7:51 am

Thank you...

When I try to load that .mrt file in DesignerFx, I got an error, but on updating to the latest released 2011.1 swc's, I got it working. Very helpful indeed.

Post by **Vladimir** » Fri Apr 22, 2011 2:36 am

Hello,

In the new version a lot of improvements are made. We recommend you always use the latest version, if possible.

Thank you.