Click here to Skip to main content
       

Database

 
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:
a)
My datatables are stored in xml-files. The xml-files are actually generated by reading out information from other tools in my business
 
b)
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,.....
 
c)
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
Web04 | 2.8.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid