Subreport Data not printing in pdf

0

I have a subreport embedded in the first page of the jasper. I have to change the sql query for the subreport but when I do that no subreport data is printed.

I am passing a parameter from the main report to the subreport, Also invoice_date is matched from two table like this

inv_sumary_invoice_date = TO_DATE ($P{INVOICE_DATE}, 'DD-MM-YYYY') --[inv_sumary_invoice_date (DATE)]

invoice_date = $P{INVOICE_DATE} -- [invoice_date (VARCHAR2)]

 

NOTE: When I replace the new query with the old one, data is available again

I can not share the code

kosalendra.singh1's picture
Joined: Dec 25 2018 - 8:17pm
Last seen: 1 month 5 days ago

1 Answer:

0

From the information you've provided, all I can say is that you have a bug in your code. Try printing out the result of the sql query to make sure they are what you want.

 

hozawa's picture
41974
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 hours 59 min ago
Feedback