Im trying to create a report for a purchase order very similar to the Northwind invoice report. I have everything figured out except how to repeat the entries in the detail section of the report. I have all the order information except all of the items. It will only list one of the items in the detail section, where in the Northwind report it repeats it as if it was a continuous form. Ive checked all the properties and they all seem to be the same. Does anyone know what i might be doing wrong here?
-
-
Have you checked the groups?Originally posted by crazytegger -
I have the grouping set up just like the northwind does
Grouped by
OrderID
ItemID
but it only displays one of the items from the orderdetailsComment
-
How is it displaying, if you have two groups one by order id and one my item id, with a page break between orders ids? it is giving you multiple pages? Are you only viewing one order number?Originally posted by crazytegger
order ID 123456
Item 1 widget 1.99
Item 2 blue widge 2.49
Do you need to group Item ID or if you want it in order do it by sort AZ. That should keep all your items within your order id together.Comment
-
I am viewing one order number with multiple items referenced by that order number. I have a pagebreak per order number. the item details are contained within the orderid break under the details break, its layed out just like northwinds is. grouping and everything is the same but it is only displaying one of many items that is associated with that order number. northwinds seems to repeat the detail section for each item record it is to display, mine is not repeating the detail section.Comment
-
Anyone??? please help me out, this is the only thing not working in my project and then im done!Comment
-
I created a PO program for my company a couple of years ago and this is how I did it.
Try creating a sub form with the detail information.Comment
Comment