Click here to Skip to main content
15,885,100 members
Home / Discussions / Database
   

Database

 
JokeRe: ask about mammogram Pin
Paul Conrad31-May-12 10:31
professionalPaul Conrad31-May-12 10:31 
AnswerRe: ask about mammogram Pin
JOAT-MON29-May-12 8:51
JOAT-MON29-May-12 8:51 
GeneralRe: ask about mammogram Pin
Chris Meech29-May-12 9:01
Chris Meech29-May-12 9:01 
GeneralRe: ask about mammogram Pin
JOAT-MON29-May-12 9:09
JOAT-MON29-May-12 9:09 
GeneralRe: ask about mammogram Pin
Chris Meech29-May-12 9:29
Chris Meech29-May-12 9:29 
GeneralRe: ask about mammogram Pin
JOAT-MON29-May-12 9:39
JOAT-MON29-May-12 9:39 
GeneralRe: ask about mammogram Pin
JohnPayton29-May-12 13:04
JohnPayton29-May-12 13:04 
QuestionBatch reporting framework for Oracle databases. Needed? Pin
Dmitri Novikov28-May-12 10:39
Dmitri Novikov28-May-12 10:39 
At my previous job at the computational center I dealt besides all with a great amount of reports getting data from an Oracle database - Crystal Reports & SQL*Plus HTML reports. Monthly we had to print some thousands of pages for co-working organizations. But what worst, we had to spend several days generating these reports in a special application written by our programmers. Until I have found a proper solution! I wrote an application that maintaned SQL-queries for generating report parameters for each kind of a report. So I had only to run such a query in this app, and I got a list of command lines for SQL*plus reporting script or a VBS script that acted like a bridge to Crystal Reports engine. Then I could save these lines to a .bat file and run it. But I also wrote a secondary app that took these command-lines and could run several child reporing processes simultaneously (SQL*Plus or Crystal Reports) that speeded up the whole job. While I was in my bed at home, the report generating job was performing during a night. By morning, the report files got ready and we only had to transfer them to our printing department.

I don't work there anymore for some personal reasons. Sometime ago I completele rewrote this app from the scratch (I had no original source files) and the result has no shadow of that organization specificity, so I think there will not be any copyright problems. Now it's a completely general app that can deal with Oracle databases of any look. Is there a need for such an application? Will be there any sense to maintain and develop it? Try to sell it?

P.S. If someone will like to try it, I have to say that I don't have an english version, only russian one. But if you ask me, I may perform an english-american localization, it will not take long.

modified 28-May-12 17:03pm.

AnswerRe: Batch reporting framework for Oracle databases. Needed? Pin
Eddy Vluggen29-May-12 0:54
professionalEddy Vluggen29-May-12 0:54 
GeneralRe: Batch reporting framework for Oracle databases. Needed? Pin
Dmitri Novikov29-May-12 8:22
Dmitri Novikov29-May-12 8:22 
AnswerRe: Batch reporting framework for Oracle databases. Needed? Pin
Eddy Vluggen29-May-12 8:51
professionalEddy Vluggen29-May-12 8:51 
GeneralRe: Batch reporting framework for Oracle databases. Needed? Pin
Dmitri Novikov29-May-12 9:35
Dmitri Novikov29-May-12 9:35 
NewsDatabase driven Controls Pin
mauricemcse25-May-12 3:27
mauricemcse25-May-12 3:27 
GeneralRe: Database driven Controls Pin
Corporal Agarn27-May-12 1:58
professionalCorporal Agarn27-May-12 1:58 
QuestionLinking ITS Typing Test System to database Pin
abhijitp8422-May-12 23:01
abhijitp8422-May-12 23:01 
AnswerRe: Linking ITS Typing Test System to database Pin
Mycroft Holmes23-May-12 13:00
professionalMycroft Holmes23-May-12 13:00 
QuestionSQL Query Issue Pin
Nayan Ambaliya22-May-12 19:09
Nayan Ambaliya22-May-12 19:09 
AnswerRe: SQL Query Issue Pin
Mycroft Holmes22-May-12 22:36
professionalMycroft Holmes22-May-12 22:36 
AnswerRe: SQL Query Issue Pin
vvashishta24-May-12 23:44
vvashishta24-May-12 23:44 
AnswerRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 0:01
professionalEddy Vluggen25-May-12 0:01 
GeneralRe: SQL Query Issue Pin
Pete O'Hanlon25-May-12 0:22
mvePete O'Hanlon25-May-12 0:22 
GeneralRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 0:25
professionalEddy Vluggen25-May-12 0:25 
GeneralRe: SQL Query Issue Pin
Pete O'Hanlon25-May-12 1:23
mvePete O'Hanlon25-May-12 1:23 
GeneralRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 1:28
professionalEddy Vluggen25-May-12 1:28 
QuestionCould anyone recommend an interactive application for mass data analysis? Pin
bestbird778822-May-12 16:24
bestbird778822-May-12 16:24 

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.