john471
Registered User.
- Local time
- Tomorrow, 03:53
- Joined
- Sep 10, 2004
- Messages
- 392
OK - Stretching things here a bit...
I have this lovely cross tab Pass Through query, which I can run from my PC to another database. It seems to need a special ODBC driver, which I have installed. The query runs and returns desirable data. No problem.
I want to run the query, and distribute results to managers in three other states. I cannot install the particular ODBC driver on their PCs. Therefore they cannot run the query themselves, or interact with that database.
The results could easily run to over 10,000 rows. I want to summarize the data (group) at up to four levels, but I want to offer a "click-through" or "drill-down" style of interactive report such that areas of interest can be explored in more depth, and areas of non-interest can be "ignored" at the summary level. So although I'm happy for the data to be static, I would like the report to be "interactive" (I guess that's the right term). I would like to automate the production of said interactive report, such that I can run it monthly and email them the result. (e.g. zipped up HTML files).
Does anyone know of a good tool to achieve this ?
More info ??? …….
The company has three sites.
Each site has numerous teams.
Each team has one or more employees.
Each employee has none or more rostered hours of work in the reporting period.
Each employee has taken none or more hours of sick leave in the reporting period.
Statistics are calculated. (no problem)
Big boss wants to know % of sick leave for the company as a whole and at each site.
Site boss wants to know % of sick leave for site as a whole and for each team.
Site boss wants to be able to say "team x has a very high rate of sick leave - why is that?" click on "team x" to get the totalled stats for each employee. Employee Z has a very high rate of sick leave, what days did he have off ? Click on Employee Z to get to her/his detail data.
A single access report would take too many pages (hundreds of employees, with the reporting period likely to be 3 months). Ultimately they should be able to get to Employee Z’s data, and print off just that page, with only her/his data on it.
Suppressing employees below a certain threshold would cause distrust of the summary statistics.
? Any suggestions ?
I’ve only now thought of the “obvious” – build an access interface to the data, and send them the query result (in form of 'raw data') every month such that they can link to it and "explore" it with the access interface, but I think I’d still prefer the HTML approach, if anyone can suggest any neat (free ???) tools that might do the trick.
Oh - and if that's not challenging enough, I'm stuck using AC97 !!
I have this lovely cross tab Pass Through query, which I can run from my PC to another database. It seems to need a special ODBC driver, which I have installed. The query runs and returns desirable data. No problem.
I want to run the query, and distribute results to managers in three other states. I cannot install the particular ODBC driver on their PCs. Therefore they cannot run the query themselves, or interact with that database.
The results could easily run to over 10,000 rows. I want to summarize the data (group) at up to four levels, but I want to offer a "click-through" or "drill-down" style of interactive report such that areas of interest can be explored in more depth, and areas of non-interest can be "ignored" at the summary level. So although I'm happy for the data to be static, I would like the report to be "interactive" (I guess that's the right term). I would like to automate the production of said interactive report, such that I can run it monthly and email them the result. (e.g. zipped up HTML files).
Does anyone know of a good tool to achieve this ?
More info ??? …….
The company has three sites.
Each site has numerous teams.
Each team has one or more employees.
Each employee has none or more rostered hours of work in the reporting period.
Each employee has taken none or more hours of sick leave in the reporting period.
Statistics are calculated. (no problem)
Big boss wants to know % of sick leave for the company as a whole and at each site.
Site boss wants to know % of sick leave for site as a whole and for each team.
Site boss wants to be able to say "team x has a very high rate of sick leave - why is that?" click on "team x" to get the totalled stats for each employee. Employee Z has a very high rate of sick leave, what days did he have off ? Click on Employee Z to get to her/his detail data.
A single access report would take too many pages (hundreds of employees, with the reporting period likely to be 3 months). Ultimately they should be able to get to Employee Z’s data, and print off just that page, with only her/his data on it.
Suppressing employees below a certain threshold would cause distrust of the summary statistics.
? Any suggestions ?
I’ve only now thought of the “obvious” – build an access interface to the data, and send them the query result (in form of 'raw data') every month such that they can link to it and "explore" it with the access interface, but I think I’d still prefer the HTML approach, if anyone can suggest any neat (free ???) tools that might do the trick.
Oh - and if that's not challenging enough, I'm stuck using AC97 !!
Last edited:
