D
DianeF
We have a report that needs to be exported to Excel. Unfortunately, because
of the complexity of the report [we have 4 rows of 8 labels and fields in
columns in a Group Header] plus 3 queries, the export does not format
correctly, even using Subreport.
However, we can export the report to HTML, rename the extension to xls and
it retains the format perfectly.
The only problem now is the html creates multiple pages on the export.
We've tried creating a data access page, and can get all the data on one
page, but the report format is not retained in Excel.
The question is...does anyone know how we can work around the multiple page
export? I see the source code of the finished first page, but don't know how
to remove the Navigation button or run the data into just one page.
We have several reports to run each day for each product and need to
automate this instead of something like a manual copy and paste.
Any ideas would be appreciated!
of the complexity of the report [we have 4 rows of 8 labels and fields in
columns in a Group Header] plus 3 queries, the export does not format
correctly, even using Subreport.
However, we can export the report to HTML, rename the extension to xls and
it retains the format perfectly.
The only problem now is the html creates multiple pages on the export.
We've tried creating a data access page, and can get all the data on one
page, but the report format is not retained in Excel.
The question is...does anyone know how we can work around the multiple page
export? I see the source code of the finished first page, but don't know how
to remove the Navigation button or run the data into just one page.
We have several reports to run each day for each product and need to
automate this instead of something like a manual copy and paste.
Any ideas would be appreciated!