Jasper 4.0.2 shows no doc pages

[mohammed.sardar]

Hi All,

 

I have written below query to get the result and it's fine when I run from SQL developer but when it's inserted in to Jasper report just gettin Document has no pages.   How can I trobleshoot this task. Please help.

 

SELECT DISTINCT

product.Name,

supplier.SupplierNo,

supplier.SupplierName,

supplier.Address,

supplier.ContactNo

FROM

Supplier, Purchase, PurchaseLine, Product

WHERE

Supplier.SupplierNo = Purchase.SupplierNo

AND Purchase.PurchaseNo = PurchaseLine.PurchaseNo

AND Product.ProductCode = PurchaseLine.ProductCode

ORDER BY  product.NAME, supplier.supplierNo