[jasperreports-questions] Input Date Not working in Jasper reports?
Hello All,
I'm trying to run the bellow query through Jasper reports. The report ask
for two input paramters (startDate and endDate), so, I added two control
with the similar name what I'm using in query (pStartDate and pEndDate) of
date type. The format I'm using for date is
"mm-dd-".
But the problem is, whenever I'm running the same query with some date range
directly on mysql console, I'm getting the result properly. Same query with
same input is also running and giving me correct result through Open Reports
also. But whenever I'm running this query through Jasper Report, I'm getting
NOTHING (Saying ... reports data empty).
I think, the format of date or something somehow is going wrong here. Can
someone pls give me any idea what I'm missing here? I pasted the query below
of this mail.
thanks (in adv)
Ashish.
([EMAIL PROTECTED])
==
select
PO.created as 'Date',
PO.purchase_order_id as 'Transaction ID',
L.price as 'Transaction Amount',
concat(PO.status, '-', ifnull(PO.delivery_status,'')) as 'State',
'paypal' as 'Payment Source',
UB.userId as 'Buyer User ID',
UB.userEmail as 'Buyer email',
PPPVB.email as 'Buyer Paypal ID/Email',
URB.buyerRating as 'Buyer Rating',
US.userId as 'Seller User ID',
US.userEmail as 'Seller email',
PPPVS.email as 'Seller Paypal ID/Email',
URS.sellerRating as 'Seller Rating',
G.gameShortName as Game,
UAB.userAvatarName as 'Buyer Avatar Name',
UAS.userAvatarName as 'Seller Avatar Name',
CI.catalogItemTitle as Item,
L.price as Amount
from
ps_purchase_order PO
join ps_listing L on (PO.listing_id = L.listing_id)
join useravatar UAB on (PO.avatar_id = UAB.userAvatarId)
join ps_purchase_attempt PURCHA on (PURCHA.purchase_order_id =
PO.purchase_order_id)
join ps_payment_attempt PAB on (PURCHA.payment_attempt_id =
PAB.payment_attempt_id)
join ps_payment_vehicle PVB on (PVB.payment_vehicle_id =
PAB.payment_vehicle_id)
join ps_paypal_payment_vehicle PPPVB on (PPPVB.payment_vehicle_id =
PVB.payment_vehicle_id)
join user UB on (UAB.userId = UB.userId)
join useravatar UAS on (L.avatar_id = UAS.userAvatarId)
join user US on (UAS.userId = US.userId)
join ps_account ACCTS on (US.userId = ACCTS.user_id)
join ps_payment_vehicle PVS on (ACCTS.account_id = PVS.account_id)
join ps_paypal_payment_vehicle PPPVS on (PPPVS.payment_vehicle_id =
PVS.payment_vehicle_id)
join catalogitem CI on (L.item_id = CI.catalogItemId)
join game G on (CI.gameId = G.gameId)
join userrating URB on (UB.userId = URB.userId)
join userrating URS on (US.userId = URS.userId)
where
PO.status in ('PAID', 'INVOICED')
and PVS.status = 'ACTIVE'
and (date_format(PO.created, '%m-%d-%Y') >= $P{pStartDate})
and (date_format(PO.created, '%m-%d-%Y') <= $P{pEndDate})
group by
PO.purchase_order_id
order by
PO.created desc;
--
View this message in context:
http://www.nabble.com/Input-Date-Not-working-in-Jasper-reports--tp14612558p14612558.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Input Date Not working in Jasper reports?
You are talking about JasperServer, right?
How have you set up the parameters in the JRXML?
The date parameters in JasperServer will come in as java.util.Date objects.
Sherman
JasperSoft
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Ashish.Anant
Sent: Friday, January 04, 2008 7:40 PM
To: jasperreports-questions@lists.sourceforge.net
Subject: [jasperreports-questions] Input Date Not working in Jasper reports?
Hello All,
I'm trying to run the bellow query through Jasper reports. The report ask
for two input paramters (startDate and endDate), so, I added two control
with the similar name what I'm using in query (pStartDate and pEndDate) of
date type. The format I'm using for date is
"mm-dd-".
But the problem is, whenever I'm running the same query with some date range
directly on mysql console, I'm getting the result properly. Same query with
same input is also running and giving me correct result through Open Reports
also. But whenever I'm running this query through Jasper Report, I'm getting
NOTHING (Saying ... reports data empty).
I think, the format of date or something somehow is going wrong here. Can
someone pls give me any idea what I'm missing here? I pasted the query below
of this mail.
thanks (in adv)
Ashish.
([EMAIL PROTECTED])
==
select
PO.created as 'Date',
PO.purchase_order_id as 'Transaction ID',
L.price as 'Transaction Amount',
concat(PO.status, '-', ifnull(PO.delivery_status,'')) as 'State',
'paypal' as 'Payment Source',
UB.userId as 'Buyer User ID',
UB.userEmail as 'Buyer email',
PPPVB.email as 'Buyer Paypal ID/Email',
URB.buyerRating as 'Buyer Rating',
US.userId as 'Seller User ID',
US.userEmail as 'Seller email',
PPPVS.email as 'Seller Paypal ID/Email',
URS.sellerRating as 'Seller Rating',
G.gameShortName as Game,
UAB.userAvatarName as 'Buyer Avatar Name',
UAS.userAvatarName as 'Seller Avatar Name',
CI.catalogItemTitle as Item,
L.price as Amount
from
ps_purchase_order PO
join ps_listing L on (PO.listing_id = L.listing_id)
join useravatar UAB on (PO.avatar_id = UAB.userAvatarId)
join ps_purchase_attempt PURCHA on (PURCHA.purchase_order_id =
PO.purchase_order_id)
join ps_payment_attempt PAB on (PURCHA.payment_attempt_id =
PAB.payment_attempt_id)
join ps_payment_vehicle PVB on (PVB.payment_vehicle_id =
PAB.payment_vehicle_id)
join ps_paypal_payment_vehicle PPPVB on (PPPVB.payment_vehicle_id =
PVB.payment_vehicle_id)
join user UB on (UAB.userId = UB.userId)
join useravatar UAS on (L.avatar_id = UAS.userAvatarId)
join user US on (UAS.userId = US.userId)
join ps_account ACCTS on (US.userId = ACCTS.user_id)
join ps_payment_vehicle PVS on (ACCTS.account_id = PVS.account_id)
join ps_paypal_payment_vehicle PPPVS on (PPPVS.payment_vehicle_id =
PVS.payment_vehicle_id)
join catalogitem CI on (L.item_id = CI.catalogItemId)
join game G on (CI.gameId = G.gameId)
join userrating URB on (UB.userId = URB.userId)
join userrating URS on (US.userId = URS.userId)
where
PO.status in ('PAID', 'INVOICED')
and PVS.status = 'ACTIVE'
and (date_format(PO.created, '%m-%d-%Y') >= $P{pStartDate})
and (date_format(PO.created, '%m-%d-%Y') <= $P{pEndDate})
group by
PO.purchase_order_id
order by
PO.created desc;
--
View this message in context:
http://www.nabble.com/Input-Date-Not-working-in-Jasper-reports--tp14612558p1
4612558.html
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
jasperreports-questions mailing list
jasperreports-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Re: [jasperreports-questions] Input Date Not working in Jasper reports?
Hi
i am having the same problem.. my reports without parameters are running
well in jasperserver but not the ones with parameters... what do i need to
do in Jasperserver to make the parameters work... please help...
Sanu
Sherman Wood wrote:
>
> You are talking about JasperServer, right?
>
> How have you set up the parameters in the JRXML?
>
> The date parameters in JasperServer will come in as java.util.Date
> objects.
>
>
> Sherman
> JasperSoft
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of
> Ashish.Anant
> Sent: Friday, January 04, 2008 7:40 PM
> To: jasperreports-questions@lists.sourceforge.net
> Subject: [jasperreports-questions] Input Date Not working in Jasper
> reports?
>
>
> Hello All,
>
> I'm trying to run the bellow query through Jasper reports. The report ask
> for two input paramters (startDate and endDate), so, I added two control
> with the similar name what I'm using in query (pStartDate and pEndDate) of
> date type. The format I'm using for date is
> "mm-dd-".
>
> But the problem is, whenever I'm running the same query with some date
> range
> directly on mysql console, I'm getting the result properly. Same query
> with
> same input is also running and giving me correct result through Open
> Reports
> also. But whenever I'm running this query through Jasper Report, I'm
> getting
> NOTHING (Saying ... reports data empty).
>
>
> I think, the format of date or something somehow is going wrong here. Can
> someone pls give me any idea what I'm missing here? I pasted the query
> below
> of this mail.
>
>
> thanks (in adv)
>
> Ashish.
> ([EMAIL PROTECTED])
> ==
> select
> PO.created as 'Date',
> PO.purchase_order_id as 'Transaction ID',
> L.price as 'Transaction Amount',
> concat(PO.status, '-', ifnull(PO.delivery_status,'')) as 'State',
> 'paypal' as 'Payment Source',
> UB.userId as 'Buyer User ID',
> UB.userEmail as 'Buyer email',
> PPPVB.email as 'Buyer Paypal ID/Email',
> URB.buyerRating as 'Buyer Rating',
> US.userId as 'Seller User ID',
> US.userEmail as 'Seller email',
> PPPVS.email as 'Seller Paypal ID/Email',
> URS.sellerRating as 'Seller Rating',
> G.gameShortName as Game,
> UAB.userAvatarName as 'Buyer Avatar Name',
> UAS.userAvatarName as 'Seller Avatar Name',
> CI.catalogItemTitle as Item,
> L.price as Amount
> from
> ps_purchase_order PO
> join ps_listing L on (PO.listing_id = L.listing_id)
> join useravatar UAB on (PO.avatar_id = UAB.userAvatarId)
> join ps_purchase_attempt PURCHA on (PURCHA.purchase_order_id =
> PO.purchase_order_id)
> join ps_payment_attempt PAB on (PURCHA.payment_attempt_id =
> PAB.payment_attempt_id)
> join ps_payment_vehicle PVB on (PVB.payment_vehicle_id =
> PAB.payment_vehicle_id)
> join ps_paypal_payment_vehicle PPPVB on (PPPVB.payment_vehicle_id =
> PVB.payment_vehicle_id)
> join user UB on (UAB.userId = UB.userId)
> join useravatar UAS on (L.avatar_id = UAS.userAvatarId)
> join user US on (UAS.userId = US.userId)
> join ps_account ACCTS on (US.userId = ACCTS.user_id)
> join ps_payment_vehicle PVS on (ACCTS.account_id = PVS.account_id)
> join ps_paypal_payment_vehicle PPPVS on (PPPVS.payment_vehicle_id =
> PVS.payment_vehicle_id)
> join catalogitem CI on (L.item_id = CI.catalogItemId)
> join game G on (CI.gameId = G.gameId)
> join userrating URB on (UB.userId = URB.userId)
> join userrating URS on (US.userId = URS.userId)
> where
> PO.status in ('PAID', 'INVOICED')
> and PVS.status = 'ACTIVE'
> and (date_format(PO.created, '%m-%d-%Y') >= $P{pStartDate})
> and (date_format(PO.created, '%m-%d-%Y') <= $P{pEndDate})
> group by
> PO.purchase_order_id
> order by
> PO.created desc;
>
> --
> View this message in context:
> http://www.nabble.com/Input-Date-Not-working-in-Jasper-reports--tp14612558p1
> 4612558.html
> Sent from the jasperreports-questions mailing list archive at Nabble.com.
>
>
> -
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
> ___
> jasperreports-questions mailing list
> jasperreports-questions@lists.so
