Software

Ask something
Question Locked

Opinions on an updateable database reporting option

0 helpful
2 replies

by ironjava

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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!

2 replies

by patlawler

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.

This discussion is closed to new replies.