Opinions on an updateable database reporting option

By IronJava ·
I'm working with a client that needs the ability to pull from multiple databases into different report formats/templates and ultimately into an Excel format that their clients can use. I'm trying to sway them towards Crystal but they do not have the staffing to maintain CR. Any ideas with other reporting formats that can export to Excel templates? Or has anyone created an Excel report with database parameters (date ranges, vendor ID, PO#, etc.)? I'm looking at Pivot Tables but they seem to be not as "flexible" as CR. Thanks!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

ODBC and then Pivot tables

by patlawler In reply to Opinions on an updateable ...

I'm using ODBC connections to three different data bases. I bring in the data fields that are needed. Then create pivot tables for some to "pre-sort" the data. After that I have an "answer? sheet that uses VLOOKUP or GETPIVOT data to create the reports needed.
I have my ODBC connections set for the fiscal year data. I have added colums at the end to us "endofmonth" function to help in the pivot table with monthly data.
This way I updata each of the ODBC data sheets. I have these on separate worksheets.
Then I update each of the pivot table worksheets, again separate sheets.
Then my "answer" sheet is updated with current information. I have one cell in the "answer" sheet that has the month number. Then each of the formulas refers to this cell for the month information. You could also change the date information in each of the pivot tables or ODBC connections to get the same information.

Related Discussions

Related Forums