How do I create a report from a DB query?

The best (although by no way the cheapest) is to use Crystal Reports or (if
you are using SQL Server) possibly SQL Server Reporting Services.

There are plenty of charting tools out there that will link to your DB and
generate the report as a web page but from experience they are difficult to
set up and usually very limited in functionality. Crystal or SSRS are proper
reporting tools and while expensive, will do everything you could ever want
from a reporting tool. I have recently designed a corporate booking system
for a company and used Crystal for their numerous reports and it is very,
very good.

"musicman2112" <webforumsuser@macromedia.com> wrote in message
news:fp4blg$36q$1@forums.macromedia.com...
>I have a few queries that I run in SQL Server to generate reports from my
> database. I know how to access a database from Dreamweaver, but I've never
> generated reports for viewing/printing. I searched the Exchange and did
> not see
> any extensions. I also searched Google and couldn't really find anything
> useful.
>
> What is the easiest way to display output from a db query in report format
> for
> viewing and/or printing?
>
> Thanks
>

> What is the easiest way to display output from a db query in report format
> for
> viewing and/or printing?

easiest would be to draw your report and then hand it off ot a back end web
developer. ;o)

Otherwise, the basic premise is to write a page that queries the DB, and
then generates HTML to display the data.

Do you work with any scripting language right now (ASP/.net/PHP/RoR/CF?)

-Darrel