Click here to Skip to main content


QuestionHow to create reports effectively [modified] PinmemberFrygreen9-Nov-12 1:52 
First, I am an absolute "database-beginner" Smile | :)
Here is my szenario in my daily business-live:

I have a lot (~30) different datatables which I combine to produce usefull-information.
The main topics are:
My datatables are stored in xml-files. The xml-files are actually generated by reading out information from other tools in my business
For the "production of usefull information" (this is reporting) I use my own proprietary C#-Programs, where I perform "the logic". Means: Filtering, Joining, Combining,.....
The final result is written into Excel-Sheets. The end-users use these excel-files for their needs
Here is my question:

Especially, step b, with my proprietary C#-Programs needs a lot of time for maintenance/updates/.... due to heavily changing environment. It is time-consuming to maintain it.
How do "professional database-engineers" handle such a task?. What is their approach? Which tools are they using?

modified 9-Nov-12 7:14am.

AnswerRe: How to create reports effectively PinmemberDavid Mujica9-Nov-12 3:32 
AnswerRe: How to create reports effectively PinmemberMycroft Holmes9-Nov-12 5:08 
AnswerRe: How to create reports effectively PinmemberFrygreen9-Nov-12 5:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Advertise | Privacy | Mobile
Web03 | 2.8.150327.1 | Last Updated 30 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid