Problem in entering date range in url
Posted on June 13, 2016 at 3:55am
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.
.png)
.png)
Joined: May 18 2016 - 10:08pm
Last seen: 4 years 10 months ago
Posted on June 13, 2016 at 3:28pm
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.
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 12 months ago
Posted on June 13, 2016 at 7:28pm
I just did that but not working. thank you for answering
Joined: May 18 2016 - 10:08pm
Last seen: 4 years 10 months ago
Posted on June 13, 2016 at 9:26pm
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.
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 12 months ago
