Method:Classic General Q&A

Re: Detail Section of Purchase Order Report

Anonymous — Tue, 19 May 2009 20:37:05 GMT

Hi John,

When setting the Detail Table, please keep in mind that the Detail Table can connect to a Master Table when a Dropdown field joins it to the Master Table, using the format: DetailTable.JoinField. I'll need to clarify some things before I attempt to answer your question. Which table is your Detail Table, Master Table and what is the Join Field? In your case where is the 'line' (estimate.line) coming from? Did you manually input estimate.line or was that an option in the Dropdown?

Re: Detail Section of Purchase Order Report

jallen — Tue, 19 May 2009 00:15:26 GMT

I am working in the report designer and trying to copy sampleEstimate to a new file. However, whenever I try to save as with the estimate.line in the detail table 1, I receive the following error: Failed at Context = 138.

Any thoughts?

Re: Detail Section of Purchase Order Report

Method_Valbon — Tue, 06 Jan 2009 18:35:19 GMT

Laura,

It looks like this is a bug with the developers of the report designer component we use. While we work to get a permanent solution, you can follow the steps below for a fix.

1.   Click on the Detail Report band.
2.   On the right hand side under ‘Property Grid’ look for ‘Data Member’.
3.   Notice that it is likely “….” between the PurchaseOrder and PurchaseOrderLine.
4.   Manually edit the Data Member so that it is just one “.”.
5.   Click Tab on the keyboard. It may replace the “.”by itself with “..”, but that’s okay.
6.   Preview the report and it should now work.

Hope this helps,

Re: Detail Section of Purchase Order Report

Method_Valbon — Mon, 05 Jan 2009 21:59:12 GMT

Hi Laura,

We`re taking a closer look at this and will have an update for you shortly.

Regards,

Detail Section of Purchase Order Report

Laura — Mon, 05 Jan 2009 18:19:12 GMT

I've had a couple of problems in designing a report for Purchase Orders. I cannot get the report to display all of the items properly in the detail section of the report. Also, I cannot get the report to display certain fields until the user clicks "Save" on the screen. For the details problem, I created the report using the PurchaseOrder table as the master table and the PurchaseOrderLine table as the detail table. -------- I added a Detail Report section to the report based on the PurchaseOrderLine table (but I've also tried it by just adding the fields directly into the Detail section): The problem is that for a PO with 3 different items, the report ends up listing the first item only but 3 times. The second problem is that the Ship To fields on the report show up as blank until the Save button is clicked on the PO form and the Report is refreshed.