Eclipse Community Forums: BIRT » retrieve parameter from address bar to birt report

Home » Archived » BIRT » retrieve parameter from address bar to birt report

retrieve parameter from address bar to birt report [message #201121]

Wed, 15 November 2006 20:04

Eclipse User

Originally posted by: keeling040982.yahoo.com

hi...

i have pass the parameter to birt via a address bar as below:

String uri =
Global.BIRT_REPORT_PATH+"receivedSummaryReport.rptdesign&stmt= "+sql+"&titles="+titles;

then, what should i done to retrieve the parameter at the address bar into
my report?

is that by using the script? how to make it?

thanks for reply...

Re: retrieve parameter from address bar to birt report [message #201381 is a reply to message #201121]

Thu, 16 November 2006 15:45

Eclipse User

In script or the expression builder you should be able to access the
parameter with
params["stmt"];

Jason

"ice" <keeling040982@yahoo.com> wrote in message
news:da5efc85fb08c833a0a408b2d19af59f$1@www.eclipse.org...
> hi...
>
> i have pass the parameter to birt via a address bar as below:
>
> String uri =
> Global.BIRT_REPORT_PATH+"receivedSummaryReport.rptdesign&stmt= "+sql+"&titles="+titles;
>
> then, what should i done to retrieve the parameter at the address bar into
> my report?
>
> is that by using the script? how to make it?
>
> thanks for reply...
>

Re: retrieve parameter from address bar to birt report [message #201526 is a reply to message #201381]

Thu, 16 November 2006 21:17

Eclipse User

Originally posted by: keeling040982.yahoo.com

hi...jason..

yup...at the script, it can access the params["stmt"];
is that correct for putting it at the method afterOpen??
or have to put at the method beforeOpen??

but how could i call it out and display it when running the report?

Re: retrieve parameter from address bar to birt report [message #201630 is a reply to message #201526]

Fri, 17 November 2006 12:33

Eclipse User

You can drop a dynamic text or data element and put
params["stmt"] in the expression.

Jason

"ice" <keeling040982@yahoo.com> wrote in message
news:fb815c0c4d03b18fa4267d924adbcc64$1@www.eclipse.org...
> hi...jason..
>
> yup...at the script, it can access the params["stmt"];
> is that correct for putting it at the method afterOpen??
> or have to put at the method beforeOpen??
>
> but how could i call it out and display it when running the report?
>

Re: retrieve parameter from address bar to birt report [message #201728 is a reply to message #201630]

Fri, 17 November 2006 20:02

Eclipse User

Originally posted by: keeling040982.yahoo.com

hi...
i drop a data element and i define
params["titles"];

when i run my system, whole the data can pass through the uri as below:

http://127.0.0.1:8080/birt/run?__report=report\InventorySubI tem.rptdesign&stmt=FROM
SP_INVENTORY WHERE SP_INVENTORY.UPDATE_ON
SP_INVENTORY.UPDATE_ON>='01/10/2006' &titles=Update Date > 01/10/2006

but it also have the error message appear at the eclipse:

Unhandled event loop exception
Reason:
java.lang.NullPointerException

what the error mean? how can i take the data from the uri into the
report?? since i am using the birt2.1.1 and eclipse3.0 only...

please show my a clear way to get the data...thanks...

Re: retrieve parameter from address bar to birt report [message #201894 is a reply to message #201728]

Mon, 20 November 2006 10:44

Eclipse User

This may be an encoding issue.
Enter &stmt=test in the url just to check.

Jason

"ice" <keeling040982@yahoo.com> wrote in message
news:726723c7d1ce9363254312cc7664a349$1@www.eclipse.org...
> hi...
> i drop a data element and i define
> params["titles"];
>
> when i run my system, whole the data can pass through the uri as below:
>
>
> http://127.0.0.1:8080/birt/run?__report=report\InventorySubI tem.rptdesign&stmt=FROM
> SP_INVENTORY WHERE SP_INVENTORY.UPDATE_ON
> SP_INVENTORY.UPDATE_ON>='01/10/2006' &titles=Update Date > 01/10/2006
>
>
> but it also have the error message appear at the eclipse:
> Unhandled event loop exception
> Reason:
> java.lang.NullPointerException
>
> what the error mean? how can i take the data from the uri into the
> report?? since i am using the birt2.1.1 and eclipse3.0 only...
>
> please show my a clear way to get the data...thanks...
>

Previous Topic:	Parameter passing in BIRT Report Through JSP
Next Topic:	DEAPI Requirements?

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jun 02 18:24:21 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter