Method Community

Hi again!  OK, so I tried moving the fields into the detail section; no change in the report.  However, maybe I need to further understand the difference in the 2 sections.  I'm going to look into that. The 'Filter String Editor' can be found in the report designer.  If you click outside the report, look under ...

 

 Hey Kandy, I was able to link everything when I created the report from the Entity Table, give that a shot and see if it allows you to do what you are looking for. Master Table: Entity Detail 1: Bill.VendorRef Detail 2: Billlineitem.CustomerRef Detail 3: Transactions.EntityRef

How Can I join the following tables in the Report Designer?  Transaction Table to Bill and BillLineItem tables   

Hi Donham, We tested it and it worked fine for us as well.  

 I am trying to design a job Cost Report and making Transaction table as my master and when I do that I do not see any other tables in Detail Tables. Any idea? I want to join Transaction Table to Bill and BillLineItem tables Thanks

 Hey K.C. I just wanted to point out, my post above would be what you would need to do if we did not have that handy "Other Actions" button on the screen for you.    

Never mind, I found it! The OTHER ACTIONS button.  

 Hey K.C. Good to hear that you have been customizing reports!!! Now that you have your report done, you need to update your "Print Preview" button. Currently your actions point to the old report, you need to update it to point to the new report. Once you get that done, you should be able to start using your report right ...

I'm experiencing brain freeze and can't locate where to change my default invoice template to a customized one I've created in Report Designer. Can you please refresh my memory where these settings are located? Thanks.