Search results for query: *

Hi Justine, Thanks but it didn't work. I've got a "nasty" solution: Rename working db to the report dev db, do the report then restore the name. Seems to work ok until I can work a better method. Thanks again Ted

We have a vb app which uses 1 Access DB per client. The structure of each db is identical. The client db is selected by the VB app. When reports are run however, ONLY data from the original db on which the CReport was developed is displayed. (Using CRW8). How can I force it to use the same db...

Using Oracle 8.1.5 on windows2000 box and Merant 3.6 Oracle driver. The log tells me that SQL_ATTR_CONNECT_Catalog fails. Have tested all ODBC etc connections. tsping fires all the oracle connections ok. Any Ideas PLEASE? Ted

Try writing a Stored Proceedure to populate a temp table with ALL the fields you need. Just Select from that temp table what you want for each sub report.

Get the download ASPXMPS7.exe from the Seagate Tech Spt site.

Not a problem. It's slow, but can be made to work. You must have a table from each db with an indexed field that will link across the 2 db's. Eg db1.tb1.Name_ID >>>db2.tbx.Name_ID. They must also be the same data types.

Thanks Guys, Ken. CRW7 does not respond AT ALL. tis as if I never made the veryify database request. Malcolm. Thanks. I'll try that. t is truely bizzare. The set location trick won't work, but a new report may. I'll let you know. Once again thanks.

I have SP which works fine. I added 2 more parameters to the Oracle SP and Crystal will not accept them. I do a verify - CRW does not respond. I run the report - the new parameters don't come up= error. Any ideas?

Can anyone show me how to construct an Oracle SP passing up to 9 paramenters and returning multiple lines/columns. What tools do you use? How do you complie the SP?