INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...This is a very good site. Please keep it running. Thanks and wishing a great health and success for the site and its owners..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Reporting Solutions > Business Objects: Crystal Reports 1 Formulas Forum

Passing the summary total into a database table automatically

Read More Threads Like This One

infinitizon (MIS)

28 Jun 12 7:51

Hi all,

I dont know if this is possible but I have created a WIP report (WIP report is a kind of report that tells you about your works that you have not finished - Work In Progress) and it is working fine.

The challenge is this the GM is now asking that he want an automated process that runs the report and sends it into another table where he can now run another report to pull weekly summaries.

Stated simply, It runs the report this week, stores the summary total in a database table, runs it next week, stores the summary total in the table and the process continues weekly; He can then go to the database and pick the results for comparison at his own time.

Really what I want is... is it possible to push the running total automatically into a database (MSSQL 2008) table without human interference.

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.

infinitizon (MIS)

28 Jun 12 7:54

Forgot to mention that I'm using crystal reports embedded in VS2008.

Appreciate all responses

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.

jklewis (TechnicalUser)

5 Jul 12 23:46

Your best bet would be to use your Visual Studios and just create an SSIS package on the SQL Server itself. Either that or just get the DBA's to write a quick procedure and put it into a SQL job.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Business Objects: Crystal Reports 1 Formulas