Export Report to HTM

MEDolin · Jan 13, 2004

I've done a few searches on this board I can’t seem to find a post with an answer I'm looking for.

I have a report in my database that can be multiple pages based on the amount of data queried. I want to be able to export the report as an htm file as one page or one document. Basically what happens is that if my report is 5 pages then the export is 5 pages with hyperlinks on the bottom of the report to navigate between each page.

When I publish the report to word and then save it within word as an htm file type it create one file or one document.

My question is this... Is there a setting that I can turn on or off that will allow me to export a 5 page report to an htm format as 1 document instead of 5?

Thanks for any help!

Matt

spacepro · Jan 14, 2004

Hi ,

There isn't a setting that I know off but an alternative can be this:

Export your report in snapshot format to a folder.
Create a html file or using Notepad enter the following:

Code:

<html>
<title>My Report</title> 
<body>
<object CLASSID="CLSID:F0E42D60-368C-11D0-AD81-00A0C90DC8D9"
      width="100%" height="100%"
   CODEBASE="C:\Program Files\Common Files\Microsoft Shared\Snapshot Viewer\snapview.ocx">
   <param name="_ExtentX" value="16722">
   <param name="_ExtentY" value="11774">
   <param name="_Version" value="65536">
   <param name="SnapshotPath"
      value="GoodsIn_Report.snp">
   <param name="Zoom" value="0">
   <param name="AllowContextMenu" value="-1">
   <param name="ShowNavigationButtons" value="-1">
</object>
</body>
</html>

Change the value="GoodsIn_Report.snp"> to the snapshot file you have exported.

save it as filename.html in the same dir as the report.
Then open the html file as it is one page with snapshot embedded, so that you can print all of the pages, but only one file.

Hope this helps you out as an alternative.

A copy of the html file is attached, just change the filename in the html code.

Regards

Andy

lekmall · Jan 23, 2004

Hi spacepro,

I had the same problem with multiple html files. I don't have the Snapshop Viewer folder on all my machines though, so what I did was to export the report ( which created the multiple files). Then I read the first file into a string variable leaving out the last 2 tags - BODY and HTML. Then I search for multiple files, go into a loop, and read in just the tables into the string variable. When out of the loop, I add the last two tags. The string variable now has all of the report and can be inserted into the body of the email.

EleanorG · Feb 12, 2004

I exported my query in datasheet view.....opened it in dreamweaver and edited it.

Export Report to HTM

MEDolin

Registered User.

spacepro

Registered User.

Attachments

lekmall

Registered User.

EleanorG

Registered User.

Similar threads

Users who are viewing this thread