September 1, 2010 at 5:02 pm
We create work orders. For production to do their work, they have to open up 3 or 4 crystal reports and enter in a work order number as a parameter of an sp. the report refreshes and they print the report. I would like to make their life easier.
I would like to give them something to kick off an sp or local package to open a window or a webpage enter a work order number, refresh the needed crystal reports and print to the reports default printer. This would save them soooo much time.
The current sp's used by the reports use the Work Order Number, an INT, as a parameter. I could kick off an sp to populate a table prior to refreshing and printing the crystal report. Then point the Crystal Report at the table instead. This way the report only has to refresh instead of needing the parameter.
The environment consists of SQL 2000 @ SP4, Crystal Reports XI @ SP6. Everything is run locally and I can use visual web dev to create a web page to kick off the job. The reports are currently located on a file server, but I can easily move them elsewhere if SQL needs them on a local drive or something.
Thanks for taking the time to read and giving me your thoughts and suggestions. I really do appreciate it.
September 1, 2010 at 10:05 pm
Once you enter the order number, then you can create a hash table within the sp. And use the same database connection to open crystal reports.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply