• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Exporting Live Web Reports

Exporting live Web reports ensures that users have up-to-the-minute data. Live Web reports execute a query against an SQL Server table, view, function, or stored procedure when users open the ReportName.htm or ReportName.asp file that's generated by the export process. Live Web reports are well suited for displaying current sales and inventory data, as well as summaries of hourly or daily Web site statistics. An advantage of live Web reports is that you don't need to periodically refresh the .xml file that provides the report's data; live Web reports obtain their data directly from SQL Server in XML format. Like static Web reports, you must export live Web reports that specify a ReportName.asp file to your Web server.

Note

Only ADP connected to SQL Server 2000 databases (including MSDE 2000) can export live Web reports. Live Web reports issue an SQL Server HTTP query to the project's database. SQL Server 7.0 and earlier don't support HTTP queries, which also are called URL queries.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint