Problem in entering date range in url

[ely78144]

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.

 

 

 

 

 

[hozawa]

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.

[ely78144]

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

[hozawa]

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.