I need ideas for interactive reporting using VBA/Access/Excel

Discussion in 'OT Technology' started by Black Light, Dec 23, 2003.

  1. Black Light

    Black Light Guest

    It has to be extremely dumbed down for Sr. level executives. Any ideas? :x:
     
  2. Black Light

    Black Light Guest

    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.
     
  3. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Why would you use Excel? I mean Access has built in reporting functionality
     
  4. Scoob_13

    Scoob_13 Anything is possible, but the odds are astronomica

    Joined:
    Oct 5, 2001
    Messages:
    73,787
    Likes Received:
    38
    Location:
    Fort Worth. Hooray cowgirls.
    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.
     

Share This Page