BusinessObjects Board

@Prompt - How do I retrieve all records for the prompt

in BOE XI 3.0

I want to build a condition using @prompt

@Select(Calls\Openprgn) IN @Prompt(‘Choose Status:’,‘A’,‘Calls\Openprgn’,Multi,Constrained,Persistent)

where the user can

  1. Select one or more values from the LOV or
  2. Retrieve all records ignoring the LOV

Is that possible? How do I get the SQL to bypass the @prompt if ALL records are wanted in the report??


thoda2999 (BOB member since 2006-10-30)

They’re called Frequently Asked Questions for a reason… :wink: … two of the Designer FAQ entries should prove useful for you:

and

Thanks


Dave Rathbun :us: (BOB member since 2002-06-06)

Thanks for the answer!


thoda2999 (BOB member since 2006-10-30)