Problem in entering date range in url

0

Hello,

 

I have a problem in date range. When I typing the exact date referenced from the database the data are showned (first picture). But when I am typing a date in url that will show all of the data, It become empty.

(second picture) I am a beginner using Jasper Ireport and Jasper server. How can I make a scripts for a date range for this? thanks for help.

 

 

 

 

 

ely78144's picture
Joined: May 18 2016 - 10:08pm
Last seen: 1 year 3 months ago

3 Answers:

1

It seems like the url between the 2 images differ in not just the pc_from and pc_to fields. Try setting the same value for csr_no and other uri.

hozawa's picture
53142
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 1 week ago
0

I just did that but not working. thank you for answering 

ely78144's picture
Joined: May 18 2016 - 10:08pm
Last seen: 1 year 3 months ago
0

Try printing out the values passed to the report. It seems like there's a problem with your sql statement. Date functions are dependent on database type.

Try checking if you're able to retrieve data from Jaspersoft Studio Dataset and Query dialog.

hozawa's picture
53142
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 1 week ago
Feedback