Hi

I have a report which is grouped by Sales Person with total number of orders processed, total value etc. Below this group header is the details section which shows the individual orders per person.
I was aiming to have the user select either a Detailed or Summary version of the report on the prompt screen so that the orders are not displayed if they select Summary but I can't get this working. I created a new Parameter and gave it Detail and Summary Values. I then went into the Details section, checked Supress No Drill Down and clicked on the formula button. I was under the impression that I needed to add something like
{?SummaryorDetail}="Summary". I already have a conditional suppression in this section - {sophead.flag_delete}=2 which suppresses voided orders.
Any help greatly appreciated.

Hi

If the report is to be run displaying detail i.e. sales orders processed, then I need it to suppress any orders with a flag_delete status of 2 (Void). If the report is to be run just as a summary, i.e. just displaying the sales persons name, number of orders processed and total value, then I need all of the sales order detail to be suppressed. Just can't seem to get this working. Many thanks

FYI- you should be OK in this specific case but generally you want to use parenthesis in your formula to group the 'and' parts from the OR

({sophead.flag_delete}=2 and {?Summary or Detail} = "Detail")
or
{?Summary or Detail} = "Summary"   

Also for future reference have you considered using 'drill down' functionality?
Rather than creating the parameter you can just set the details to "Hide(drill down OK)" which starts the report as suppressed but allows the user to double click on the group to drill into the details.
In this report you can also set the details suppression criteria in "Suppress (No Drill-Down)" to {sophead.flag_delete}=2 to always hide those rows.

Edited by DBlank - 19 May 2016 at 4:17am

Hi Dee37,

Glad you have it. But I'm curious about your formula:

{sophead.flag_delete}=2 and {?Summary or Detail} = "Detail"
or
{?Summary or Detail} = "Summary"

If I'm not wrong, this formula gives exactly the same results that the one I've suggested in my answer (and it's shorter):

{?Summary or Detail}="Summary" OR {sophead.flag_delete}=2

So I don't see why it doesn't work. Can you confirm it really doesn't work?