Creating a printable report

[Niavlys]

Hi,
I want to create a report from data retrieved from an access database and display it in a web page.

how can I do this?

Thanks!

 

[TonyU]

[tt]Create a page with a link "Get Report" which will submit to a processing page with an SQL statement like:

"Select * from Your_Table where whatever = whatever"

then the design part as to how to display that information is up to you.

Delete * from brain Where MaxLevel = "Full" and reaction = "Slow" order by StartOver
​

 

[TonyU]

[tt]And of course there are more options like:
Exporting your data directly to word, excel, PDF, crystal reports etc..

It's all about how you want to present it.

Delete * from brain Where MaxLevel = "Full" and reaction = "Slow" order by StartOver
​

 

[Niavlys]

Maybe I wasn't clear enough, this part is done. My problem is that I wan't to print a page that's well formatted. I though I could create a report in access and then print it by ASP.

I tried with

doCmd.OutputTo acOutputReport, "Report1", acFormatHTML

but I get an error telling me that I can't do this at the moment.

 

[TonyU]

[tt]I could be wrong, but I don't think one can export/display an internal access report with ASP, You would use a combination of VBScript/SQL/JavaScript to build/display/print your report

Delete * from brain Where MaxLevel = "Full" and reaction = "Slow" order by StartOver
​

 

[lottastuff]

If the report is already defined in MS Access, try outputing it from MS Access as either Rich Text (filetype RTF, can be viewed using MS Word which will launch within the browser) or as a "snap" (filetype .snp).

This latter type is specifically for web viewing and requires the user to have a lightweight app called the "snapshot viewer" (free from Microsoft). The snapshot viewer does an excellent job of retaining the same view of the report you get from within MS Access and runs happily within any browser.

Used this years ago, so it's conceivable Micorsoft has since gone a different direction.