Method Community

Blog | Forums | Webinars | Release Notes | Help Center

Welcome to Method Community Sign in | Join | Help

Method Community » Method Forums » Method General Q&A » Detail Section of Purchase Order Report

Detail Section of Purchase Order Report

Last post 05-19-2009 3:37 PM by Anonymous. 4 replies.

Page 1 of 1 (5 items)
	Sort Posts: Previous Next

01-05-2009 12:19 PM

Laura
Joined on 11-10-2008
Posts 5

Detail Section of Purchase Order Report

Reply Contact

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.

01-05-2009 3:59 PM In reply to

Method_Valbon
Joined on 08-06-2008
Toronto, Ontario
Posts 1,480

Re: Detail Section of Purchase Order Report

Reply Contact

Hi Laura,

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

Regards,

Need more help? Ask us about customization packages!

Valbon Shabani
Consultant Representative
Method Integration
Toll Free: 1.888.925.6238 ext. 715
Local and overseas: 416.847.0400 ext. 715
Fax: 416.640.6027
E-mail: v.shabani@methodintegration.com
Website: http://www.linkedin.com/in/valbon

01-06-2009 12:35 PM In reply to

Method_Valbon
Joined on 08-06-2008
Toronto, Ontario
Posts 1,480

Re: Detail Section of Purchase Order Report

Reply Contact

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,

05-18-2009 7:15 PM In reply to

jallen
Joined on 03-10-2009
Atlanta, GA
Posts 49

Re: Detail Section of Purchase Order Report

Reply Contact

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?

05-19-2009 3:37 PM In reply to

Re: Detail Section of Purchase Order Report

Reply Contact

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?

Page 1 of 1 (5 items)