*HOT* Exporting multiple subreports

[icq_giggles]

I have a report that gives me what I need but the customers have requested in
Excel. When I use the "analyze with Excel" option to output the report, the
second subreport does not transfer.

It is a comparison of two data sources and this is the cleanest way I can
bring the data together, I know there are other manual options for this but
I'm hoping to avoid them. Any help would be appreciated and this is somewhat
hot at this point.

 

[Jeanette Cunningham]

Hi icq_giggles,
have a look at this site
http://www.rogersaccesslibrary.com/...p?FID=63&SID=64514a93a6fd5eb6ez371712b4525cbc

there is a sample for exporting to excel



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[icq_giggles]

Thanks Jeanette, but those don't really cover the problem - I did find that
it was exporting the second subreport, just mixed in at the bottom of the
first subreport - I just manually re-aligned them to submit. It would be
nice if it kept those font styles to make it easier to differentiate but - I
was able to make do.

Thanks for taking the time to respond.