Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Best approach to make multiple reports from database?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a large database on sheet1 and a drill-down report using sumif's and subtotals on sheet2.
    Of course the client now wants additional/ different drill-downs which I can do on additional sheets but recalc times are increasing.
    Is there a better/simpler approach? I think I'll have to get into VBA generated reports. ;o(
    Thx SB


  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-09 18:44, Spock's Brain wrote:
    I have a large database on sheet1 and a drill-down report using sumif's and subtotals on sheet2.
    Of course the client now wants additional/ different drill-downs which I can do on additional sheets but recalc times are increasing.
    Is there a better/simpler approach? I think I'll have to get into VBA generated reports. ;o(
    Thx SB

    Have you tried using a pivot table?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I like pivot tables for "my" work-in-progress stuff but can my end user create pretty presentation reports with the click of a button? (selecting pretty pivot table options from userform). More VBA. ;o)

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What about an Access report from Excel?

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That would be ideal but would be a quantum leap for my end users. (They are comfortable opening Excel files & clicking buttons).
    Pivot tables wouldn't work because I don't need to 'pivot' the data.
    Thank you for the suggestion tho'.



  6. #6
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Creating reports in VBA = tedious and painful.
    At least too me...
    Have fun!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •