Re: excecuting stored procedures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 1 Feb 2006 21:31:30 -0800, someone posing as hems took a five minute
break from flipping burgers to boot up the etch-a-sketch and scribbled:

Hi,

Can I Schedule excecution of stored procedure in crystal report XI.
I want to schedule it for daily. Please anyone help me on this.

Not quite sure what you're asking here.

You want to schedule the stored proc (I'm assuming on MSSQL?) to run based
on a given time from within Crystal Reports?

AFAIK, Crystal has no built-in method for calling stored procs on a
scheduled basis.

You do have several options, however.

The stored procedure will return a dataset at a given time - that is the
data at the time the procedure was run. You can put this into a "temporary"
or "holding" table and schedule the stored procedure to run at any given
time. This would be done on the SQL Server itself.

(If you've upgraded from MSSQL to MySQL , DB2 or Oracle you probably have
similar options, but I'm not as familiar with them.)

You can then run the report against the "temporary" table to pick up the
data that had been placed there.

FWIW, you might want to just look at scheduling the report to run at a
given time. IIRC, there are many third-party packages to schedule the
running of crystal reports. Thus, you simply select your dataset from the
results of the stored procedure, and schedule the report to run at x time
and you're done.

I think many of these products even run on Wintendo if you're still stuck
using that and haven't upgraded to Linux yet.

HTH!


--
kai - theperfectreign at yahoo dot com
remember - a turn signal is a statement, not a request
.

Relevant Pages

  • Re: scheduling a t-sql stored procedures name in table column without creating a job for each on
    ... You want to schedule or simply run/put them on a Q and they run? ... Again I would still connect to SQL Server however it is that you want to do it, get all the possible procs from your Control table. ... I want to write a stored procedure that will ... You also do not need to use a Script task to do ...
    (microsoft.public.sqlserver.dts)
  • Re: Limitations of Scheduled jobs
    ... > Actually we can schedule the jobs with accuracy less than ... where executing the stored procedure ... >>on what the stored procedure does exactly. ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Limitations of Scheduled jobs
    ... Actually we can schedule the jobs with accuracy less than ... >on what the stored procedure does exactly. ... >SQL Server MVP ... >> I'm using SQL Server 2000 as the DB for my web ...
    (microsoft.public.sqlserver.programming)
  • Re: scheduling a t-sql stored procedures name in table column without creating a job for each on
    ... I want to write a stored procedure that will ... And by schedule I mean run as a job now. ... You also do not need to use a Script task to do ... loop over them and execute them using a combination of the ForEachLoop ...
    (microsoft.public.sqlserver.dts)
  • Re: view vs. function vs. procedure - really basic question
    ... > The table I need to output is built inside a stored procedure. ... > Crystal reports seems to only know about tables and views. ... Our Crystal does not even now that there is an SQL Server database at ... web forums on their web site. ...
    (comp.databases.ms-sqlserver)