Click here to Skip to main content
12,446,525 members (55,191 online)
   

Database

 
QuestionHow to create reports effectively Pin
Frygreen9-Nov-12 0:52
memberFrygreen9-Nov-12 0: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 Pin
David Mujica9-Nov-12 2:32
memberDavid Mujica9-Nov-12 2:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 4:08
memberMycroft Holmes9-Nov-12 4:08 
AnswerRe: How to create reports effectively Pin
Frygreen9-Nov-12 4:10
memberFrygreen9-Nov-12 4:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.160811.3 | Last Updated 25 Aug 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid