HELP! Reporting from a Web Page

HELP! Reporting from a Web Page

Post by 2710 » Fri, 10 Oct 1997 04:00:00



How do you generate reports from a web page?

I wrote a VB3 app that accesses an ACCESS 2.0 db. The reports were
generated using CRYSTAL REPORTS. The app was used on 5 different servers,
each server with different data in the db.

The group using the app wanted to consolidate the data and use one central
app from their respective servers. The solution seemed to be to convert the
app to a web application.

I re-wrote the VB3 app in VB5 and ran the ACTIVEX DOCUMENT WIZARD to
convert the .FRM files into .DOB files. Some errors were created and I
fixed those. Testing the app on the browser, everything seems to work
except the reporting. This was something I hadn't considered. How do you
generate reports in a web app?

I'd appreciate any help or suggestions as to resources available. Thanks!

 
 
 

1. Help: Access/SQL Memos/Reports/Web pages

I have an application, in Access 2000, with a form and report, which gets
data from a linked SQL Server table.

I'm trying to display the table's data both in an Access report, as well as
in an active server page, online.

Problem #1:  On the access report, the formatting is okay, but the memo
fields (defined as text in SQL, but I've also tried SQL's varchar 3000, with
the same results) truncate after 255 characters.  These fields are not
formatted, in any way, though.

Problem #2:  When I try to display the contents on the web, all of the data
prints, but there are no line breaks, where they're entered into the SQL
table from the Access front-end (everything wraps).  However, if I enter the
HTML <br> command into the field, where I want the break, the line will
break on the web, but the <br> will display on the Access Report.

Does anyone out there know of a workaround for either of the 2 problems?
Thank you, in advance.

Bari

2. pgAccess and Tcl/Tk

3. Help: Retaining Report Page Layout When Calling Report From Form

4. Change Logging

5. Access 2000 reports and running from ASP web page

6. Database extensions DATA.TRT & DATA.INX??????

7. Running Access Reports on a Web page

8. Paradox Report Display on Web Page

9. Running Reports on a web page from access database

10. view paradox reports on web page?

11. Filemaker Pro Unlimited for Windows, custom web showing page after page

12. how to run a dts from a web page like an asp.net page