Best way to filter to avoid duplicate pages in report

[mikenelena]

We print single page reports and e-mail them to clients. When a client has multiple e-mail addresses (stored in a table), the report prints a duplicate page in the pdf document for each e-mail address. We would like only 1 page to print.

If this is to be solved through a filter, should that be done by setting criteria on the query, or in the filter setting on the report itself? Or, might I be better off pursuing a way to specify the print range of the pdf? (To save time on the query.)

I've tried all 3 methods. Setting criteria on the query does in fact limit the number of returned rows to 1, but then inexplicably (to me at least), the report fields are all blank. Setting the filter on the Report simply doesn't filter anything at all. I have tried experimenting with Do.Cmd.PrintOut, but I cannot find an example of how to specify the file name and path with this method such as I can with Do.Cmd OutputTo.

If someone can point me in the right direction, I'd greatly appreciate it!

Thanks!

 

[xenou]

Have you investigated the data source for the report? It is likely it involves a join to email address information and this query/join needs to be tweaked to take only the default or primary email address.

 

[mikenelena]

Have you investigated the data source for the report? It is likely it involves a join to email address information and this query/join needs to be tweaked to take only the default or primary email address.

I have, BUT... only on the final query. This query pulls from another intermediate query. Maybe your idea will work on that step. I'll try it this afternoon. Thanks!

 

[xenou]

Great. Post back if you run into any difficulties.

 

[mikenelena]

Xenou's suggestion worked. I was too fixated on the final query, and hadn't considered that an intermediate query might be a more appropriate location for the filter. Thanks very much!