Last post May 19, 2014 04:08 PM by jesalynolson
May 19, 2014 10:44 AM|amills30|LINK
We have a report that needs created that is causing some problems.
The report can have multiple items with tables inside.
For example: the report will print a listing of orders but inside of the orders will be sections with the parts ordered.
So the report will display the orders placed for the day.
Page 1: the order information (Order Name, Address, Sale Details, etc).
Page 2: the order details (a table of individual parts ordered)
So each time the report runs, there could be numerous orders, each with numerous detail items.
We have Page 1 working, just put the items inside a "List" from the toolbox and set the dataset on the "List" object. But when we go to add a Table to the report for the Order Details, the dataset is preselected to that of the "List" object. We can't select
Order.Parts or anything like that to show the parts object of the order.
Would anyone know of a way to have a multiple display inside a multiple display for a report?
May 19, 2014 04:08 PM|jesalynolson|LINK
You have two options:
1) Subreport with parts information using an OrderID parameter. http://msdn.microsoft.com/en-us/library/dd220581.aspx
2) Have your dataset for your list group on OrderID and have text boxes for the information you need on the order and a table for the parts information. This means your dataset should include the order information and parts information within the same text.
As long as they are in the list it should group properly and show the correct data.