Click here to Skip to main content
13,550,050 members
   

Database

 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 8:19
memberSQL Ed12-Nov-12 8:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 11:33
memberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 19:03
memberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 10:08
memberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 12:51
memberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 18:40
memberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively Pin
Frygreen9-Nov-12 0:52
memberFrygreen9-Nov-12 0:52 
AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 2:32
memberDavid Mujica9-Nov-12 2:32 
Search a topic like "Business Intelligence" and you will get an idea of what others are doing.

At a high level, you have a central database which collects data from different systems, then you have reporting tools which either you or your user community can write their own reports. Also, sometimes you can have these reports run on a scheduled basis and have their output delivered to whoever needs it.

The cost of implementing such a system can be quite high.

You might want to implement some pieces of this.

For example:
1) Build a tool which will load your data extracts (xml files) into a central database.
2) Create views or stored procedures which "normalize" your data
3) Use a reporting tool to generate the reports you need or show your users how they can connect to the central database via Excel to get their own data. (See topics like Microsoft Query)

Empower the user to access the data and you will spend less time on maintenance.

Good luck.
Thumbs Up | :thumbsup:
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 
Suggestionsql server 2008 security Pin
Member 36227527-Nov-12 8:00
memberMember 36227527-Nov-12 8:00 
GeneralRe: sql server 2008 security Pin
Mycroft Holmes7-Nov-12 11:27
memberMycroft Holmes7-Nov-12 11:27 
GeneralRe: sql server 2008 security Pin
jschell8-Nov-12 8:56
memberjschell8-Nov-12 8:56 
QuestionHelp me my Sql expired Pin
mehdi_nassiri00986-Nov-12 10:03
membermehdi_nassiri00986-Nov-12 10:03 
AnswerRe: Help me my Sql expired Pin
Jörgen Andersson6-Nov-12 10:22
memberJörgen Andersson6-Nov-12 10:22 
AnswerRe: Help me my Sql expired Pin
Joy Sinha22-Nov-12 20:09
memberJoy Sinha22-Nov-12 20:09 
QuestionADO.NET Pin
M.T.H.Danish6-Nov-12 6:25
memberM.T.H.Danish6-Nov-12 6:25 
AnswerRe: ADO.NET Pin
Richard MacCutchan6-Nov-12 7:28
mvpRichard MacCutchan6-Nov-12 7:28 
AnswerRe: ADO.NET Pin
Eddy Vluggen6-Nov-12 9:18
memberEddy Vluggen6-Nov-12 9:18 
GeneralADO.NET Pin
M.T.H.Danish6-Nov-12 6:11
memberM.T.H.Danish6-Nov-12 6:11 
AnswerRe: ADO.NET Pin
ihoecken6-Nov-12 6:27
memberihoecken6-Nov-12 6:27 
QuestionSQL SERVER 2008 Pin
M.T.H.Danish6-Nov-12 2:49
memberM.T.H.Danish6-Nov-12 2:49 
AnswerRe: SQL SERVER 2008 Pin
David Mujica6-Nov-12 3:27
memberDavid Mujica6-Nov-12 3:27 
AnswerRe: SQL SERVER 2008 Pin
J4amieC6-Nov-12 3:31
memberJ4amieC6-Nov-12 3:31 
AnswerRe: SQL SERVER 2008 Pin
djj556-Nov-12 4:43
memberdjj556-Nov-12 4:43 

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 |
Web04-2016 | 2.8.180515.1 | Last Updated 17 May 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid