Best approach to make multiple reports from database?

Spock's Brain · Apr 9th, 2002, 07:44 PM

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

kmiles · Apr 9th, 2002, 09:27 PM

Quote:

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?

Spock's Brain · Apr 9th, 2002, 09:39 PM

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)

Tom Schreiner · Apr 9th, 2002, 09:49 PM

What about an Access report from Excel?

Spock's Brain · Apr 9th, 2002, 10:23 PM

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'.

Tom Schreiner · Apr 9th, 2002, 10:35 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 07:44 PM	#1
Spock's Brain New Member Join Date: Mar 2002 Posts: 18	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

Apr 9th, 2002, 09:39 PM	#3
Spock's Brain New Member Join Date: Mar 2002 Posts: 18	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)

Apr 9th, 2002, 09:49 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	What about an Access report from Excel?

Apr 9th, 2002, 10:23 PM	#5
Spock's Brain New Member Join Date: Mar 2002 Posts: 18	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'.

Apr 9th, 2002, 10:35 PM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Creating reports in VBA = tedious and painful. At least too me... Have fun!