Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TJ
Posting Yak Master
201 Posts |
 Posted - 2001-12-28 : 09:24:24
|
| Scenario:I need to pull applicable recs from a database, print a welcome letter for each record, and then mark the record as printed. Is there a way to write a proc for this?I am able to pull the recs, but do not know how to print them?Any help would be appreciated.Thanks!Teresa |
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2001-12-28 : 10:05:29
|
| I've never tried to run a Crystal Report from a stored proc, but I know you can run a stored proc from a Crystal Report.Not sure if that is helpful,Scooter |
 |
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2001-12-28 : 10:35:17
|
| how do you code in Crystal Reports to call an sproc? |
|
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-28 : 11:45:47
|
| You set up the data connection to be a stored procedure. To do this, link to SQL via the OLEDB connector. Under properties, make sure stored procedures are visible. You should now see the list of stored procedures available to your login.I don't have it in front of me, but something like this works.Not sure how to automatically print them from SQL. I think using CR with their scheduler product (name????) will allow you to do it. |
|
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2001-12-28 : 11:56:48
|
| Thanks for your help. Is there a way to pass a parameter in the sproc? I only want certain recs to print for certain people.Thanks again!Teresa |
|
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2001-12-28 : 16:48:40
|
| Yeah, you should be able to pass any parameter to the stored proc just like you would if you are passing it in T-SQL.Scooter McFly |
|
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2001-12-28 : 20:12:38
|
quote:
Scooter McFly
I found an example of an sproc that passed a param. Once I got the syntax, it was pretty darned simple. Funny how that works. shockedThanks for your help!Teresa |
|
|
|
|
|
|
Can I write a proc that will fire up a Crystal Rp?