Connecting Tech Pros Worldwide Forums | Help | Site Map

Report Maker

ddtpmyra's Avatar
Familiar Sight
 
Join Date: Jun 2008
Location: CA
Posts: 222
#1: Oct 24 '09
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
best answer - posted by 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

ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: 4 Weeks Ago

re: Report Maker


There's a SQL Server Reporting Service

Good luck!!!

--- CK
ddtpmyra's Avatar
Familiar Sight
 
Join Date: Jun 2008
Location: CA
Posts: 222
#3: 4 Weeks Ago

re: Report Maker


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's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#4: 4 Weeks Ago

re: Report Maker


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's Avatar
Familiar Sight
 
Join Date: Jun 2008
Location: CA
Posts: 222
#5: 4 Weeks Ago

re: Report Maker


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's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#6: 4 Weeks Ago

re: Report Maker


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's Avatar
Familiar Sight
 
Join Date: Jun 2008
Location: CA
Posts: 222
#7: 4 Weeks Ago

re: Report Maker


CK,

do you mean html button to do 'refresh' inside the html code?
ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#8: 4 Weeks Ago

re: Report Maker


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
Reply