Link Table to Proc

[itsgenekramer]

SQL 2000, CR 8.5, ODBC w/tables, OLE w/proc. Is there anyway to link a table and a proc?

-Gene

 

[lyanch]

You may be able to, but it usually doesn't gain you anything, and can cause some unintended consequences. The first thing is to make sure that the linking fields are the same datatype. Even data defined the same on two different databases doesn't necessarily "link" corrently (ie an int on Sybase <> an int on Oracle). Also you have to consider them to be two distinct datasources, so Crystal will retreive everything on the LHS and then go get the RHS that match, and then delete LHS that doesn't meet RHS criteria or matches (and makes an outter join whether you want or not). I am sure that isn't exactly how it works, but it does something along that line from watching the SQL that gets sent to the DB etc.

I would try to work this with subreports if possible.

Lisa

 

[synapsevampire]

I wasn't even aware that CR 8.5 allowed you to link a table to an SP.

If it's all in SQL Server, why not just modify the SP?

-k

 

[itsgenekramer]

Unfortunately, I don't always have write access to the proc, so I was trying to figure out a way to just add some tables with data that was requested and just link them to the proc.

Thanks anyway.