Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple prompts 1

Status
Not open for further replies.

anilcognos

IS-IT--Management
Aug 6, 2002
14
0
0
US
Hi I wanted to pass multiple prompts using a macro to a report, whats the syntax for it?


I have tries
Set objImpRep = objImpApp.OpenReport ("D:\imr\test.imr","200212","005")

it doesnt work?

anil
 
Hi Anil,

To pass multiple prompts you need to set up a single item to pass, with prompts delimited by a bar (|)


eg
Set objImpRep = objImpApp.OpenReport "D:\imr\test.imr","200212|005")

Hope it helps

Kevin
**************************************************************
Rock is Dead (Long Live Paper and Scissors)**************************************************************
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top