Best approach to make multiple reports from database?
Best approach to make multiple reports from database?
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!

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
  •  

 

 
DMCA.com