Search results for query: *

The error sounds SQL related to me. What permissions does your user "joe.schmo" have on the sql server? Jon Clayton Senior Programmer Analyst Montgomery, AL

Hi there. I have a vb.net function that converts a proprietary field type to a readable array. I am not sure if I should go the UFL route or if I should try to convert it into a crystal function. I am still using crystal 8.5. It seems as though the industry is moving away from UFL...

Have an application which uses the crpeauto object to show reports that pull from a SQL Server 2000 database. The reports are bases upon a stored procedure and the datasource is dynamically set each time the report is generated. The procedure works flawlessly on 99% of the computers that we...

When setting up an Oracle ADO connection you have a choice between Oracle OLE DB and Microsoft for Oracle OLE DB. They differ in the parameters required. Which one do I use? Thanks jpc

We have developed several crystal 7.0 reports on a Win 98 os and have found that some of them act very strange on an Win 2000 system. for example: 4 of our reports the page size has been racked all out of kilter. Two of our other reports cause GPF's on Win 2000 but operate fine on 98. Does...

Like my daughter taught me to say Whooo Hoooo! jpc

Looking at the code, is "Report1" a valid object? Then Set objSubreportObj = objReportObjs.Item(lngCount) strSubreportObjName = objSubreportObj.Name setsubReport = Report1.OpenSubreport(strSubreportObjName) SubReport.Database.Tables(1).SetLogOnInfo jpc

Here's my solution to this problem. You have to query the report and determine if it has any subreports. If it does then you must point each subreport to the correct db and proc then logon. Hope this helps. ps(the rpt reference in a vb class that we use to maintain various and sundry info...