Method Community

I'm creating a commission statement report based on the Invoice table. Each invoice record has a commission amount on it. To gen the report, a user will filter an Invoice grid based on date range and salesman. I'm passing the invoice record id's to the report no problem. I would like to have the date range and salesman search criteria also printed on the report. Is there any way to pass this information to the report from Method so I can print it on the report? I know I could create a custom report table with this search criteria as the master and the invoice record id's as the detail but that's a lot of hassle for just a couple pieces of information I need printed on the screen.

Anyone done something like this before?

Thanks..

Hi Blake,

One way, as you mentioned, would be to create a custom report table and upon hitting print have the values stored so they can be pulled into the report. Another option however is to create custom fields in the Company table or any relevant table. This means you would not be required to create a table and it is just a case of updating these fields with the entered start, end and sales rep used to filter to invoices.

I hope this helps.

-Cian

Heh...yeah I actually thought about shoving data into some other table like as well. I think I'll probably just go ahead and create master/detail tables for this report. It's more straight forward/obvious that way and easier to maintain.

Thanks