Focal Point
Passing parameters to an ASP page from a report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9521078331

June 22, 2005, 05:03 PM
dballest
Passing parameters to an ASP page from a report
Hi All,

I have a need to drilldown to an ASP page and pass the multiple parameters. I was able to save the code but when I run it, gives back an error: "(FOC3202) Bad value in Stylesheet at line: 21".

Below is the code:
TABLE FILE DMR_INFO
PRINT
LINE
LOT
WHERE ( DISPOSDATE GT DT(2005-04-16 13:58:59) );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N2,
URL=http://efab/LotNumber/LotnumberFrameSet.asp?LotNumber=N2,
$
ENDSTYLE
END

It looks to me that the = sign throws it off.

Also, if you have multiple parameters to pass, I would need to define the url as such:
URL=http://efab/LotNumber/LotnumberFrameSet.asp?LotNumber=N2&Linecode=N1

How do I make WF recognize that the field after the & variable is not really a parameter but a delimiter in ASP?

Thank you in advance for your help.

Dan
dan.ballesteros@necsam.com
June 22, 2005, 06:05 PM
codermonkey
I'm not 100% sure, but try this:

URL=http://efab/LotNumber/LotnumberFrameSet.asp? (\
LotNumber=N2 Linecode=N1), $

I think it will build the string correctly for you when the call is made.

The \ is needed on the first line as a continuation character.
June 22, 2005, 06:15 PM
dballest
It WORKED! Thanks Pam!
June 24, 2005, 03:33 PM
susannah
dballest, also in answer to your question about the &, use the pipe character to escape the & .
so for ex, to insert a blank space in a text field,   would be written in focus as &|nbsp;
Put pipes after the & in your url statement.
June 24, 2005, 03:46 PM
dballest
Thanks Susannah. I'll keep that in mind. Have a nice weekend. - Dan