Change form-based report to table-based report

**drewship** · 07-16-2009, 08:52 AM

Hello all,
I have a very challenging problem I hope someone can help with.

I am going to convert our current non-standard database over to a standard one using the Order Management Database from the Microsoft site. I have attached the database with only 2 changes which I need to work out before I can proceed with the conversion.

The first change is I added a button under tasks to open the OrderDetails1 report. The second change is I included a copy of the OrderDetails1 report which is a static document to mimic our current database report and this is the sticking point for the conversion.

Basically, we have a report, similiar to the OrderDetails1 report provided here, which has been manually drawn and saved in our database with only certain information being dynamic. Those dynamic fields are tied to a control source on the 'Add an Order and Details' form (I know this is not the correct way but that is why I am trying to convert the database). This allows us to print a report of the items selected on the form.

I need to be able to use the same static report but retrieve the data from a table instead of the form. Is this possible? Is there a way to change our static report into a dynamic report created on the fly like what is normally done? Any help is greatly appreciated.

Thanks,
Andrew

**bhill** · 07-20-2009, 07:56 AM

Rather than use the Order Details table directly as the report's recordsource, you need to create a query with the Orders and Order Details in it, then set that to the report's recordsource. When you do that, you will be able to replace the form references (which all appear to come from the Orders table) to the fields in the query.

**drewship** · 07-27-2009, 08:55 AM

Thanks bhill, I will give it a try, but I am not sure how to place the results in the exact locations on the report. I will look at how normal reports reference the data and see if I can figure it out.

Thanks,
Andrew