Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Oracle: saving ouput to a table daily

Avatar of Maliki Hassani
Maliki HassaniFlag for United States of America asked on
Crystal ReportsOracle Database
6 Comments1 Solution436 ViewsLast Modified:
Hello Experts!

I am not what is the best way to design this report.  I will provide you with my intentions and please provide me with some ideas.

Plan:

I am building a report in Crystal reports that will need to store data (counts) daily.  Example Monday Tuesdsay Wednesday etc.

The counts are being pulled from queries that will capture day within a 24 hr period.  I am using Oracle and Aqua Data studio for the database.  
Here is the issue.  Lets say I run it Monday and the data populates the fields in the report. But when I go on Tuesday to run the report, it will erase the data.  How can I make it run queries and not erase the data as the days go by?  

I was thinking..  Can I store the daily values in a table and then call them from my report?  But then how would I clear the data to reuse the table every week.  I am looking to make this easier than what I am currently using in Excel.  

Any suggestions?
ASKER CERTIFIED SOLUTION
Avatar of Naveen Kumar
Naveen KumarFlag of India imageProduction Manager / Application Support Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers