Customize with VBA Script!

sdk development
1

Hi Folks,

Can I add a check box to ‘Select All’ the values from list of values through VBA Script to the Prompt box? Is that possible? If yes, how do I attach that script to the report? Any suggestions folks.

Thanks
Ravi.
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

2

You cannot add a check box to the prompt dialog box. But you could design your own Prompt dialog box. If you want to a generic prompt box, it might get very complicated. If it is for a specific report (or few reports) you could design the forms for accpting prompt values and polpulate the variables and refresh from the vba script.

You must have seen some postings suggesting the use of OR clause in the where condition to achieve the Optional prompts. That will be the easiest way of implementing optional prompts. But when you consider performance you are in soup. We have a table with just 7 million rows. When we run a query with some conditions i get back the result in seconds but when I specify OR clause I have to wait for hours.

In such scenario, it’s really worth designing custom prompt boxes.

Vasan
Baton Rouge International Inc
Data Warehousing Division

businessobject@HOTMAIL.COM on 04/03/2000 08:15:38 PM

Hi Folks,

Can I add a check box to ‘Select All’ the values from list of values through VBA Script to the Prompt box? Is that possible? If yes, how do I attach that script to the report? Any suggestions folks.

Thanks
Ravi.

******************************************************************************* Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Ernst & Young LLP

Listserv Archives (BOB member since 2002-06-25)