Method Community

Hi

I have created a new object called SalesOrderPackage to store details of the shipping packages sent to customers to fulfill orders.

I now want a report which shows all sales orders where a SalesOrderPackage exists.  I have created a report on the SalesOrder table with the SalesOrderPackage linked as a child to it, however my report is listing all orders with or without any packages associated.  How do I change the report so it only returns rows where there is a SalesOrderPackage

Thanks!

Rick

Hi

Please can anyone shed any light on this.  I have a hack which is to add my required fields from the SalesOrder as linked fields on my child table, but it doesn't seem a very elegant solution!

Any guidance/pointers appreciated.

Rick

I'm not sure I fully understand your issue, but perhaps this will help...?

Filter for your SalesOrderPackage (yes only) at the Method Screen level. You can do it in the report properties.

Hi Mike

Imagine I was looking at customers and their sales orders. I have 3 customers, 2 of which have ordered off me.  My data would look like:

Customer            SalesOrderNo         Amount

Customer 1

Customer 2         1                          $50

Customer 3         2                          $100

My master table in the report is the customer with the detail table of the Sales Order. 

I only want a row to be returned where a sales order exists.

I have looked at setting the filter in the generate report action on my button, to filter where the SalesOrderNo is blank, but I am getting the following error:

Error^Action Sequence Order:1^ERROR:You have specified that a filter should be applied to your report, however no filter criteria was sent. For security purposes, this report cannot be shown.

Any help appreciated!

Thanks

Rick

HI Rick,

Not quite sure what you are doing..but...

If you just want to find records where SO exists, why is your report not using the SO table as master and SOLine (if need) as detail or your SO Pkg detail.  Only SO will be in the SO table.  

I have found that the report generator action can be kinda fussy as to what record id's are chosen for a report and can be based on screen you are on. Its frsutrating, cause you expect the report to follow the rules of the Report you set up and not be governed by the scren you are on. 

hope that helps...