By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Report Maker

ddtpmyra
100+
P: 333
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
Oct 23 '09 #1

✓ answered 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

Share this Question
Share on Google+
7 Replies


ck9663
Expert 2.5K+
P: 2,878
There's a SQL Server Reporting Service

Good luck!!!

--- CK
Oct 26 '09 #2

ddtpmyra
100+
P: 333
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.
Oct 26 '09 #3

ck9663
Expert 2.5K+
P: 2,878
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
Oct 26 '09 #4

ddtpmyra
100+
P: 333
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.
Oct 26 '09 #5

ck9663
Expert 2.5K+
P: 2,878
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
Oct 26 '09 #6

ddtpmyra
100+
P: 333
CK,

do you mean html button to do 'refresh' inside the html code?
Oct 27 '09 #7

ck9663
Expert 2.5K+
P: 2,878
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
Oct 27 '09 #8

Post your reply

Sign in to post your reply or Sign up for a free account.