Need help with Prompt to run for all the companies.

system · May 20, 2011, 9:50pm

Hello,

I need to create a condition in the universe which will allow them to run the report for all companies or only to the companies that they entered during Prompt.

Here is the one that i am using for only 1 company. How to convert this to run for all the companies or for the multiple companies that the user wants to run.

@Select(Financial Management\Company Number) = @Prompt(‘Enter Company Number’,‘n’,‘Financial Management\Company Number’,mono,free)

Thanks,
Raju

Rajua99 (BOB member since 2004-12-16)

system · May 23, 2011, 5:56am

Hi ,
Just change the Option Mono in your @ Prompt condition to Multi .

Hope this helps

Regards
Sapan

swapnil_taz (BOB member since 2006-04-06)

system · May 23, 2011, 6:17am

It will not work with the “=” (equal sign) in the condition.

Marek Chladny (BOB member since 2003-11-27)

system · May 23, 2011, 7:32am

Either construct this as an optional prompt (Webi) or define this as:
@Select(Financial Management\Company Number) in @Prompt(‘Enter Company Number’,‘n’,‘Financial Management\Company Number’,multi,free)

tbunnik (BOB member since 2005-06-08)

system · May 23, 2011, 3:42pm

Thanks, This is working. is there a way to make this prompt to run for all the companies when they enter 0 or not instead of selecting or entering all the companies in the prompt.

Rajua99 (BOB member since 2004-12-16)

MarkP · May 23, 2011, 4:06pm

Check out the Designer FAQ

system · May 24, 2011, 2:19pm

Yes you can.
@Select(Financial Management\Company Number) in @Prompt(‘Enter Company Number or 0 for all companies’,‘n’,‘Financial Management\Company Number’,multi,free) or 0 in @Prompt(‘Enter Company Number or 0 for all companies’,‘n’,‘Financial Management\Company Number’,multi,free)

tbunnik (BOB member since 2005-06-08)