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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing input parameter to the drill down report

Status
Not open for further replies.

H1004

MIS
Oct 28, 2003
136
US
Can I pass my input parameters to my drill down.
For example

TABLE FILE TABLENAME
SUM
CNT.UNIQUE_ID
WHERE DATE GE '&BEGDATE';
WHERE DATE LT '&ENDDATE';
.....


TYPE=DATA,
COLUMN=N1,
FOCEXEC=EXAMPLE(ID=N1),
$
...

I got it to pass ID, but I want the date to be able to pass to the example fex as well. So I add it by typing
FOCEXEC=EXAMPLE(ID=N1, BDATE='&BEGDATE', EDATE='&ENDDATE'),
But that doesn't work...
Has anybody done this b/4??
Thank you!!!
 
Yes this should work,try removing the commas between the arguments,I dont think it likes commas
 
Hi,
This should work:
FOCEXEC=EXAMPLE(ID=N1 BDATE='&BEGDATE' EDATE='&ENDDATE'),
You cannot place comma in between.
Let me know if it worked or not.
-WFRaj
 
HI
You can the following too
FOCEXEC=EXAMPLE(ID=N1 BDATE='&BEGDATE' EDATE='&ENDDATE' UDATE='&UPDATE'),$
 
It works when I don't put in the comma. Thank you very much for your help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top