[Solved] Conditionally hide columns based on user prompt

[bdybldr]

Hi everyone,
I 'm developing a report that shows MTD, QTD, and YTD sales data, grouped by Division and product.Ã,  I've created a value prompt with static choices (MTD, QTD, YTD) and based on the users selection, I want to display only the data the user selected.Ã,  This all one query, so I need to conditionally hide irrelavant data based on the user selection.

Any suggestions?

Thanks.

[JoeBass]

This sounds like a straight forward conditional report.  What is giving you trouble?

[bdybldr]

Ok, I figured it out.  I just used a conditional block and copied 3 different list reports to it.  Sorry.

[JoeBass]

If the fields you are hiding or displaying aren't related to query filters, you can use one query and show or hide columns with conditional formatting at the column level