Coding Question- HTML send steps

Markfre1

I'm having a little problem with sending an HTML document.

The Scenario is as follows. I have.

MainCompany
Stores (child of main company)
Sales Tax (child of Stores)

So a Main Company has stores and each store has a report that is sent each month.. There is a Detail and Summary report.

The Detail Report sends a SEPARATE Email Per Store which works fine. Coding below. There are more conditions but left them off for this.

FIND ALL MainCompany IN BATCHES OF 1
FIND Stores WHERE Stores.MainCompany=MainCompany
FIND StoreTaxes WHERE StoreTaxes.Store.MainCompany=Stores.MainCompany
MonthlyEmailSalesTaxReportSendDetail

This works in that it finds Cycles through each Main Company, finds the stores pertaining to that company, finds the sales tax for each store, and sends 1 HTML page.

I could also have said:
FIND ALL MainCompany IN BATCHES OF 1
FIND StoreTaxes WHERE StoreTaxes.Store.MainCompany=MainCompany
MonthlyEmailSalesTaxReportSendSummary

Works either way for Detail.

Where I have the problem is in the Summary. Instead of sending a page per Store with Taxes, I want one table and one email like below. So I want to send all the Stores and Store Taxes for a Main Company in 1 Email .

Need an Email to work like this.
Store # - Taxable Sales, Etc
1 - 1000.00
2 - 1002.00

2102.12

Next Company (next email)
Store # - Taxable Sales, Etc.
20 - 2232.00
25 - 1230.00

I change the code up a little, but still get one page per store. Thought maybe if I read the sales taxes by store it would work. No luck. I don't think I need to do anything because I am using an HTML table? Any help is appreciated as this is probably pretty basic but the grasp of what is in context at the time of sending is a little confusing.

This is the simplified code for the summary. Thanks in advance for any help. Mark

FIND ALL MainCompany IN BATCHES OF 1
FIND StoreTaxes WHERE StoreTaxes.Store.MainCompany=MainCompany
MonthlyEmailSalesTaxReportSendSummary

tford

Check out LIST and LIST_TABLE functions.

Markfre1

OK Researching now. Thanks.

Markfre1

Thank you for your input. So now somewhat lost in the respect that I am not sure where I would put this code and if I have to change my approach.

This is a Process as follows. (1 -4 are 1 process), 4 calls the Send Process

Step 1 is to Select a Date Parameter.

ENTER NEW DateSearch

Then go through each MainCompany

FIND ALL MainCompany IN BATCHES OF 1

Then Find all the Stores and StoreTaxes for that Main Company

FIND StoreTaxes WHERE StoreTaxes.Store.MainCompany=Stores.MainCompany AND StoreTaxes.Date=DateSearch.SearchDate

Then I call a process to send the email

SEND MonthlySalesTaxReportEmailSummary TO StoreTaxes.Store.MainCompany

This is an html template and it list the StoreTaxes. I get them all but 1 per page.

So in reading the List function I did not know if I have to change this whole approach.
I started adding the LISTnto the HTML but this did not work. So because I need the MainCompany, I am not sure where I would add the List function. In the HTML, in the process, etc. If you could point me in the right direction it would be greatly appreciated. I'm a little lost on this. Thanks again.

Mark

HTML
<<LIST('FIND StoreTaxes WHERE StoreTaxes.Store.MainCompany=MainCompany', 'StoreTaxes.StoreNum')>>