Eclipse Community Forums: BIRT » Dataset parameter GregorianCalendar getYear()

Home » Archived » BIRT » Dataset parameter GregorianCalendar getYear()

Dataset parameter GregorianCalendar getYear() [message #160801]

Sun, 14 May 2006 11:49

Eclipse User

Hello,

I have a SQL-Statement thats need the Year as parameter.
I want generate the Year with the funktion "getYear()" but allways I have an
error "getYear() is not a function."

Thanks for any help!!!

Re: Dataset parameter GregorianCalendar getYear() [message #161568 is a reply to message #160801]

Tue, 16 May 2006 14:40

Eclipse User

Hi,

I have a report he must run every month.
(run?__report=test.rptdesign&__format=pdf)
The SQL-Statement is "select * from xxxx where extract(month from
create_date) = ?(Monat) and extract(year from create_date) = ?(Jahr)"
I hope that the parameter Monat und Jahr i can generate with the function
getMonth und getYear.

can anyone help me????

Thanks Kurt

"Kurt Knippschild" <kurt@ingenieurbuero-knippschild.de> schrieb im
Newsbeitrag news:e47j7t$aar$1@utils.eclipse.org...
> Hello,
>
> I have a SQL-Statement thats need the Year as parameter.
> I want generate the Year with the funktion "getYear()" but allways I have
an
> error "getYear() is not a function."
>
> Thanks for any help!!!
>
>

Re: Dataset parameter GregorianCalendar getYear() [message #163242 is a reply to message #161568]

Sat, 20 May 2006 14:35

Eclipse User

Hi, ha nobody else the problem, and can help????

"Kurt Knippschild" <kurt@ingenieurbuero-knippschild.de> schrieb im
Newsbeitrag news:e4d5vp$hik$1@utils.eclipse.org...
> Hi,
>
> I have a report he must run every month.
> (run?__report=test.rptdesign&__format=pdf)
> The SQL-Statement is "select * from xxxx where extract(month from
> create_date) = ?(Monat) and extract(year from create_date) = ?(Jahr)"
> I hope that the parameter Monat und Jahr i can generate with the function
> getMonth und getYear.
>
> can anyone help me????
>
> Thanks Kurt
>
> "Kurt Knippschild" <kurt@ingenieurbuero-knippschild.de> schrieb im
> Newsbeitrag news:e47j7t$aar$1@utils.eclipse.org...
> > Hello,
> >
> > I have a SQL-Statement thats need the Year as parameter.
> > I want generate the Year with the funktion "getYear()" but allways I
have
> an
> > error "getYear() is not a function."
> >
> > Thanks for any help!!!
> >
> >
>
>

Re: Dataset parameter GregorianCalendar getYear() [message #163248 is a reply to message #163242]

Sun, 21 May 2006 05:55

Eclipse User

Originally posted by: sangria.gmx.net

Hi
are you looking for something like this?

new java.util.GregorianCalendar()).get(java.util.Calendar.YEAR)
new java.util.GregorianCalendar()).get(java.util.Calendar.MONTH)

michael

Kurt Knippschild schrieb:
> Hi, ha nobody else the problem, and can help????
>
> "Kurt Knippschild" <kurt@ingenieurbuero-knippschild.de> schrieb im
> Newsbeitrag news:e4d5vp$hik$1@utils.eclipse.org...
>> Hi,
>>
>> I have a report he must run every month.
>> (run?__report=test.rptdesign&__format=pdf)
>> The SQL-Statement is "select * from xxxx where extract(month from
>> create_date) = ?(Monat) and extract(year from create_date) = ?(Jahr)"
>> I hope that the parameter Monat und Jahr i can generate with the function
>> getMonth und getYear.
>>
>> can anyone help me????
>>
>> Thanks Kurt
>>
>> "Kurt Knippschild" <kurt@ingenieurbuero-knippschild.de> schrieb im
>> Newsbeitrag news:e47j7t$aar$1@utils.eclipse.org...
>>> Hello,
>>>
>>> I have a SQL-Statement thats need the Year as parameter.
>>> I want generate the Year with the funktion "getYear()" but allways I
> have
>> an
>>> error "getYear() is not a function."
>>>
>>> Thanks for any help!!!
>>>
>>>
>>
>
>

Previous Topic:	default value of parameter
Next Topic:	cannot open report editor

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Nov 18 20:08:00 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter