Report Maker

[ddtpmyra]

Hi Gurus :)

Anys suggestion for reporting tool like PHP report maker for MS SQL database?

thanks in advance!

Im looking for a web base tool for publishing

[ck9663]

There's a SQL Server Reporting Service

Good luck!!!

--- CK

[ddtpmyra]

I only have access thru ODBC and Im using MS SQL Studio Express, basically what I wanted to do is to have a dynamic (adhoc) reporting that is a webbase just like PHP report where the user can select or filter the colulmns results.

[ck9663]

Try crystal report. I'm not sure if MS Access can output report as HTML, but you might also want to consider that.


Good luck!!!


--- CK

[ddtpmyra]

Hi CK,

I tried it, but it seems its not real time. I have to refresh the connection inside the crystal repot once a while.

Its my first time to use crystal ver9, im not sure if im doing it correctly. I create the report and have it in html exported to my webroot.

[ck9663]

Yes, you're going to refresh it if that's case. Try to create a button that will generate the report for you so the user can rerun it every time he needs it.

--- CK

[ddtpmyra]

CK,

do you mean html button to do 'refresh' inside the html code?

[ck9663]

Yes, that's what I mean.

You can also create a dynamic page to display the report in HTML format and just let the user to print it through the browser. You have to consider the page orientation, margin, etc... or... you can create a "printable page" as well..

Good luck!!!

--- CK