Jump to content
Changes to the Jaspersoft community edition download ×

can someone explain how to report multiple items on order


Recommended Posts


my sql is fairly simple


select concat(a.invoice_prefix, a.invoice_no) as Invoice, a.order_id as OrderNo, a.email as Email, a.date_added as DateAdded, a.telephone as Phone, a.payment_method as PaymentMethod, concat( a.firstname, ' ', a.lastname) as Customer ,  a.payment_address_1 as Address , concat(a.payment_city,  a.payment_postcode) as City, a.comment as CollectionDate, c.name as Product,  c.quantity as QtyorWeight,  c.price as Price,  c.total as Total   from  oc_order as a,  oc_order_product as c where a.order_id = c.order_id and STR_TO_DATE(a.comment, '%d/%m/%y') = cast($P{CollectionDate} as date)

i had included group by order_id whn creating this sql in the wizard but it seems to have missed this...


i am testing an order with 3 items ... but it seems only to have printed one item...


can someone explain how i get all the data for one order on one page but at the bottom of the page individual items listed one after another...





Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...