How do I create a report from a DB query?

[musicman2112]

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

[Newsgroup_User]

> 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

[musicman2112]

Yes, I did a lot of ASP/DB work in Dreamweaver, but that was quite a few years ago. So I know I can query the database and format the output. I was just wondering if any "report writing" capabilities have been implemented in the last few years to make is easier to create and format reports. Sounds like Dreamweaver is still lacking in this area. I think DNN has a "report" module. I may check that out.

Thanks

[Newsgroup_User]

> ago. So I know I can query the database and format the output. I was just
> wondering if any "report writing" capabilities have been implemented in
> the
> last few years to make is easier to create and format reports. Sounds like
> Dreamweaver is still lacking in this area. I think DNN has a "report"
> module. I
> may check that out.

Dreamweaver is an HTML editor, DNN is a web CMS platform, so they really are
different beasts.

There are lots of report writing systems...in the MS world, there's MS's own
reporting services, crystal reports, and, as you state, plenty of add ons
and modules for a variety of CMS prosducts.

-Darrel

[Newsgroup_User]

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
>