Is there a way to run a report for a specific table in a database, and a report for an entire database?
Say for example I have some employees, and I want to run a monthly report on the entire team, can I do that? If so, any idea on how to do this?
Also, say I want to run a report on a specific table for the month, can I do this? If so, any idea on how?
Note: I am using WAMP
Report Wizard
-
Jackolantern
- Posts: 10891
- Joined: Wed Jul 01, 2009 11:00 pm
Re: Report Wizard
Naturally there is a plethora of third-party tools you can buy to extract pretty much any data you could ever want from your database. But if your needs are fairly straight forward, you should be able to just make some adjustments to your database to track access times and then use that to create your own reports in PHP you can run anytime. If you aren't tracking access and modification dates right now, I don't think there is anything a 3rd-party tool could do to mine data retro-actively anyway. I don't believe MySQL stores mineable data timestamps on its own, but I could be wrong.
The indelible lord of tl;dr
-
SpiritWebb
- Posts: 3107
- Joined: Sun Jul 12, 2009 11:25 pm
Re: Report Wizard
I believe I found a way around it, on what I needed. I am just adding to more fields to my database to include what I need, then in PHP program a form type setup that searches through the new fields on what I need.
My question now is: How would I go about setting up a drop down box to include all the data in the database for one line. Say for example one field is month, and in the search option, I want it too show all tables that have that current month for that database?
I need 3 different drop down boxes. One showing month, day and year. You can either select the ALL option, or select from the drop down to produce the information requested. How would I do this?
My question now is: How would I go about setting up a drop down box to include all the data in the database for one line. Say for example one field is month, and in the search option, I want it too show all tables that have that current month for that database?
I need 3 different drop down boxes. One showing month, day and year. You can either select the ALL option, or select from the drop down to produce the information requested. How would I do this?
