| How to parse report parameter to dataset parameter [message #101441] |
Wed, 21 December 2005 21:30  |
Eclipse User |
|
|
|
Originally posted by: eric.chen.cheliu.cn
This is a multi-part message in MIME format.
------=_NextPart_000_0175_01C606E2.B2AAEE80
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
Hi:
I have problem when using parameter.
My sql query like this:
Select confirmation_no, status_flag from operator where status_flag =3D =
?
I defined a dataset parameter which called "paramSTATUS".
I also defined a report parameter which called "statusflag".
The I tried set the default value of "paramSTATUS" to =
params["statusflag"], there is an error message like this:
=B7=A2=C9=FA Birt =C0=FD=CD=E2=A1=A3
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:1.0.1
=B4=ED=CE=F3=B4=FA=C2=EB:data.engine.JSScriptInvalid
=B4=ED=CE=F3=CF=FB=CF=A2:=CE=DE=D0=A7=B5=C4 Javascript =
=B1=ED=B4=EF=CA=BD=A1=A3=D4=B4: ParamBinding(statusflag)=A3=AC=D0=D0: =
0=A3=AC=B1=ED=B4=EF=CA=BD:
params["statusflag"]
=BD=C5=B1=BE=D2=FD=C7=E6=B4=ED=CE=F3: ReferenceError: "params" is not =
defined.
Any helps? Thank you!
------=_NextPart_000_0175_01C606E2.B2AAEE80
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312">
<META content=3D"MSHTML 6.00.2800.1528" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Hi:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have problem when using =
parameter.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>My sql query like this:</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2>Select confirmation_no, =
status_flag=20
from operator where status_flag =3D ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I defined a dataset parameter =
which called=20
"paramSTATUS".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I also defined a report parameter =
which called=20
"statusflag".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The I tried set the default value of =
"paramSTATUS"=20
to params["statusflag"], there is an error message like =
this:</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2>=B7=A2=C9=FA Birt =
=C0=FD=CD=E2=A1=A3<BR> Plug-in=20
Provider:Eclipse.org<BR> Plug-in Name:BIRT Data Engine<BR> =
Plug-in=20
ID:org.eclipse.birt.data<BR> Version:1.0.1<BR> =20
=B4=ED=CE=F3=B4=FA=C2=EB:data.engine.JSScriptInvalid<BR> =
=B4=ED=CE=F3=CF=FB=CF=A2:=CE=DE=D0=A7=B5=C4 Javascript =
=B1=ED=B4=EF=CA=BD=A1=A3=D4=B4:=20
ParamBinding(statusflag)=A3=AC=D0=D0: =
0=A3=AC=B1=ED=B4=EF=CA=BD:<BR>params["statusflag"]<BR>=BD=C5=B1=BE=D2=FD=C7=
=E6=B4=ED=CE=F3:=20
ReferenceError: "params" is not defined.<BR></FONT></DIV>
<DIV><FONT color=3D#0000ff><FONT face=3DArial color=3D#000000 =
size=3D2>Any helps? Thank=20
you!</FONT></DIV></FONT></BODY></HTML>
------=_NextPart_000_0175_01C606E2.B2AAEE80--
|
|
|
| Re: How to parse report parameter to dataset parameter [message #101846 is a reply to message #101441] |
Thu, 22 December 2005 17:24  |
| Eclipse User |
|
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_00E1_01C6071C.841A4270
Content-Type: text/plain;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
Eric,
Dont set the default to params["statusflag"]
Set the default to something like "R".
Then in the table that uses the dataset, select the binding tab and =
enter params["statusflag"] where "R" shows up.
Jason
"Eric Cheb" <eric.chen@cheliu.cn> wrote in message =
news:dod38e$ucu$1@utils.eclipse.org...
Hi:
I have problem when using parameter.
My sql query like this:
Select confirmation_no, status_flag from operator where status_flag =
=3D ?
I defined a dataset parameter which called "paramSTATUS".
I also defined a report parameter which called "statusflag".
The I tried set the default value of "paramSTATUS" to =
params["statusflag"], there is an error message like this:
=B7=A2=C9=FA Birt =C0=FD=CD=E2=A1=A3
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:1.0.1
=B4=ED=CE=F3=B4=FA=C2=EB:data.engine.JSScriptInvalid
=B4=ED=CE=F3=CF=FB=CF=A2:=CE=DE=D0=A7=B5=C4 Javascript =
=B1=ED=B4=EF=CA=BD=A1=A3=D4=B4: ParamBinding(statusflag)=A3=AC=D0=D0: =
0=A3=AC=B1=ED=B4=EF=CA=BD:
params["statusflag"]
=BD=C5=B1=BE=D2=FD=C7=E6=B4=ED=CE=F3: ReferenceError: "params" is not =
defined.
Any helps? Thank you!
------=_NextPart_000_00E1_01C6071C.841A4270
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312">
<META content=3D"MSHTML 6.00.2900.2769" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Eric,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Dont set the default to=20
params["statusflag"]</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Set the default to something like =
"R".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Then in the table that uses the =
dataset, select the=20
binding tab and enter params["statusflag"] where "R" shows =
up.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Jason</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Eric Cheb" <<A=20
href=3D"mailto:eric.chen@cheliu.cn">eric.chen@cheliu.cn</A>> wrote =
in message=20
<A=20
=
href=3D"news:dod38e$ucu$1@utils.eclipse.org">news:dod38e$ucu$1@utils.ecli=
pse.org</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have problem when using =
parameter.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>My sql query like this:</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2>Select =
confirmation_no, status_flag=20
from operator where status_flag =3D ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I defined a dataset parameter =
which called=20
"paramSTATUS".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I also defined a =
report parameter which=20
called "statusflag".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The I tried set the default value of=20
"paramSTATUS" to params["statusflag"], there is an error message like=20
this:</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2>=B7=A2=C9=FA Birt =
=C0=FD=CD=E2=A1=A3<BR> Plug-in=20
Provider:Eclipse.org<BR> Plug-in Name:BIRT Data Engine<BR> =
Plug-in=20
ID:org.eclipse.birt.data<BR> Version:1.0.1<BR> =20
=B4=ED=CE=F3=B4=FA=C2=EB:data.engine.JSScriptInvalid<BR> =
=B4=ED=CE=F3=CF=FB=CF=A2:=CE=DE=D0=A7=B5=C4 Javascript =
=B1=ED=B4=EF=CA=BD=A1=A3=D4=B4:=20
ParamBinding(statusflag)=A3=AC=D0=D0: =
0=A3=AC=B1=ED=B4=EF=CA=BD:<BR>params["statusflag"]<BR>=BD=C5=B1=BE=D2=FD=C7=
=E6=B4=ED=CE=F3:=20
ReferenceError: "params" is not defined.<BR></FONT></DIV>
<DIV><FONT color=3D#0000ff><FONT face=3DArial color=3D#000000 =
size=3D2>Any helps?=20
Thank you!</FONT></DIV></BLOCKQUOTE></FONT></BODY></HTML>
------=_NextPart_000_00E1_01C6071C.841A4270--
|
|
|
Powered by
FUDForum. Page generated in 1.07764 seconds
Home