Display parameter based on a condition 1

[Trishuli]

Hello!

I am stuck with a report. I don't know if CR can do this or not:

The report first prompts for invoice number. And if the customer for that invoice number happens to be "Blue Company" Then ask the report to display another prompt (yes or no) which then suppresses a certain section in the report if 'yes'.

If customer in that invoice is NOT "Blue Company" Then suppress the GroupFooter without the yes or no prompt.

Thanks!

 

[Trishuli]

Sorry, in my second paragraph, when I mean by 'suppresses a certain section', I mean the GroupFooter.

 

[lbass]

What is your CR version?

-LB

 

[Trishuli]

Hi Ibass,

It is CR XI

Thanks!

 

[lbass]

In CR XI, prompts are not optional, and so you would have to create a parameter {?Show Result for Blue Co} with options:

"Yes"
"No"

Add prompt text like this:

If you have selected an invoice for Blue Company, would you like to show <some result>? Choose "Yes" or "No." If you did not select, Blue Company, please select "No."

Then use a section suppression formula like this:

(
{table.company} = "Blue Company" and
{?Show Result for Blue Co} = "No"
) or
{table.company} <> "Blue Company"

-LB

 

[Trishuli]

Hi Ibass,

My report already has the same structure as your suggestion, but I was wondering if prompts were optional. Thanks heaps for confirming it and for your help!