Suppressing dynamically based on user reqs.

[jhermiz2]

My boss wants to have a summary report showing just totals and a detailed report showing some details. I created the details report and rather than creating another report can I create code to suppress the five fields that are in one of the sections and just show the totals?

I would want the user to select whether they want a detailed report or a summary...but how can I do this as well? Is this a parameter value? If so ... can anyone give me an idea on how to go about doing this.

Thanks,
Jon

 

[BurnsORegan]

Jon

You are right, use a parameter value. On the fields you need to suppress right click and format / common tab, click on suppress and then in the formula button (x-2) use the following:

{?YourParameter} = "Your Value"

eg. If parameter id called DetailsRequired and the values possible are "Yes" or "No" then:

{?DetailRequired} = "Yes"

this would suppress the fields. You can alsodo this for entire sections.

Good Luck

BurnsORegan