Search results for query: *

I use the following command: CrxReport.ParameterFields(ReportParamcount).AddCurrentValue (item1) Of course the trick here is knowing what parameter number (sequentially) your specified parameter is. There are many ways to determine which parameter is in which order. In...

Use a OLE Object to contain the BMP instead of the path name. It will then act as a regular column for your row and you will be able to add the different bitmaps as desired. The path name will not work.

Sounds like your connection string is incorrect. Below is code I use in my own DLL to change location to the proper database location: Private CrystalReport As CRPEAuto.Report Private CrystalDatabase As CRPEAuto.Database Private CrystalTables As CRPEAuto.DatabaseTables Private CrystalTable As...

Some of my clients use a DSN for the web server. When they do, I have an exact DSN name on my computer so that there will be no problems with the dsn information. Are you using Crystal Enterprise on your server or an in house package?

Are you using Crystal Enterprise?

I always turn off the option "Save Data with Report" when creating a report, thus I always get the current data without a problem.

I have my own DLL I have created to connect to a DNS-less database (Not ODBC). Here is some code to help... Public Sub CCADORead(CCDBFile As String, CCSQL As String) Set CCConn = CreateObject("ADODB.Connection") Set CCRSRecordset = CreateObject("ADODB.Recordset")...

I have a DLL I created using these functions automatically, so I don't have to write this in every program. Here is the syntax I use: Private CrystalDatabase As CRPEAuto.Database Private CrystalTables As CRPEAuto.DatabaseTables Private CrystalTable As CRPEAuto.DatabaseTable Set...

A Stored Procedure functions just like any table when using it within Crystal Reports. Use the Stored Procedure as a table. Use Prompts for the data and then Record Selection for attaching the information to the stored procedure. Let me give you an example. I had a stored procedure called...

I have a DLL I created using these functions automatically, so I don't have to write this in every program. Here is the syntax I use: Private CrystalDatabase As CRPEAuto.Database Private CrystalTables As CRPEAuto.DatabaseTables Private CrystalTable As CRPEAuto.DatabaseTable Set...

By your post, am I correct to assume that you are using the ActiveX control?

This problem occurs more than people would like to think. One of the problems is if you use an If Then statement in the record selection, the SQL is not altered on anything you use in your record selection criteria. The sql will return all records and then parse them out on the 2nd pass based...

I know for me, I prompt for the parameters in VB the way I want it then pass it to Crystal.

You can display pictures without overlaying items as mentioned above IF you create a BLOB field or if you use Access an OLE object field to associate with your different rows. The Bitmap/JPG or other recognizable format for CR has to be stored in the database. Otherwise, you will have to...