Sendobject - Report with subform

[peterlee516]

For some reason the subform in my report is not showing up in the HTML and Rich Text Format. It works perfectly with the Snapshot format but not everyone receiving the email has MS Access and wont be able to open up the snp file.

Thank you in advance for your help.

 

[pbaldy]

I'm not sure how well subreports translate to those formats. There is a free snapshot viewer available from Microsoft for users without Access, or you might consider sending in PDF format, which is pretty universal.

 

[peterlee516]

we have over 100 extemely busy bankers who are receiving these emails so installing snp reader is not possible. i've tried to write to pdf but haven't been successul. there's tons of code out there for a pdf file but can't seem to make them work. some are very complicated.

 

[dkinley]

In these instances I have redesigned my reports to make them a bit friendlier for text reading only. Think of the old dot-matrix days. For instance, in reports I have used something like

******************************************************

to seperate a header and detail. It is also a great method for subreports.

******************************************************

This overcomes the issue of additional software or spending hours looking for a solution through coding. Worst case, it allows you to be functional with what you have until you find and incorprate the best solution.

-dK

 

[pbaldy]

I use this to create PDF files to email:

http://www.lebans.com/reporttopdf.htm

 

[dkinley]

Lookie there .. solution found! No redesign was even necessary.

Thanks Paul!

-dK

 

[pbaldy]

There's always more than one way to skin a cat, though the cat isn't particularly happy about it.