November 2, 2006 at 12:45 pm
Need to call report with no parms from SQL. Possible from DTS or sql job.
Just need to find a way to automate/schedule process
Can anyone help with syntax?
Thank you
November 2, 2006 at 2:39 pm
Interesting question! I know how to link Crystal Report to SQL but not vice versus.
I would like share this info.
Anyone would like to help?
November 3, 2006 at 11:48 am
You can make a report manager by creating a set of tables with rows defining available reports, parameters (type, default value, allows null or not), permissions, etc... and another set of tables containing the actual reports on queue (which were defined previously) with the plugged in values to the parameters, export options (print, pdf to folder, or email pdf to target address), scheduled times, queued time, user name, completion time. Then you can make a program that puts new jobs in the queue upon command (which you call from sql with the appropriate settings, or just have a stored procedure insert the appropriate values into the job queue tables) and another program (or a slew of programs on different machines to handle the processing workload in a timely fashion) that waits for new jobs to be ready and be popped off the queue and dealt with.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply