Discussion in 'OT Technology' started by Black Light, Dec 23, 2003.
It has to be extremely dumbed down for Sr. level executives. Any ideas?
One idea I had was using form select feature in MS Access forms to filter data, then pass it to a pivot table/chart in MS Excel using Automation.
Why would you use Excel? I mean Access has built in reporting functionality
Generate the report from data gathered through a stand-alone or web-app, and use Crystal Reports to display it.
No use bring Excel into the mix, though it's rather handy if they want to play with figures on the fly without doing a complete recalc on the report.