Recent content by OOBIE

Ken, I should have taken your training course first! I created a Data Definition (TTX) file using the fields from the Stored Proc use the TTX file to create the reports. then 'Call crTable.SetPrivateData(3, recordset)' Thanks for your help OB

I have listed 'pdsodbc.dll'

Yes ,the repor tis external the crpapp.OpenReport get a path pointing to the report. Ob

The CR report was built using the Stored Proc....even though I pass it the recordset CR will still popup the parameter dialog. (silly me! ) . Is there any way of undoing the CR Store Proc dependency without destroying the report? Thanks OB

I am getting a recordset thru a Data Logic Layer and passing that RecordSet to Crystal....The Logic Layer handles the parameters to the StoredProc. Set crReport = crpapp.OpenReport(FrmPrintDialog.sRpt_form) Set crDatabase = crReport.Database Set crTables = crDatabase.Tables //getting...

Do any one have an example on how to pass parameters to Crystal 7 without the prompt box popping up? I am using vb6 and referencing the Crystal 7 object. Thanks OB

You are passing a Function that is not recognize instead of an actual value. Try this : Resolve the function first on the form , capture the output and send it to your SQL as a parameter. Happy Cooding!

Not sure this will help but the following list the attributes in a directory DECLARE @DirCmd VARCHAR(150),@FileName VARCHAR(100) SELECT @DirCmd = 'dir ' + '\\SERVER\DATA\WORKFILES\' CREATE TABLE #DirResults (Diroutput VARCHAR(255) NULL) INSERT #DirResults EXEC master.dbo.xp_cmdshell @DirCmd...