Recent content by css1015

I was able to use the Oracle Managed Provider for .Net to connect to Oracle using the System.Data.OracleClient and this helped me access the Oracle tables just fine using the ADO.Net objects. With the Oracle Managed Provider, I used an OracleConnection object, and an OracleDataAdapter object to...

Thanks. The reason I am using ODBC is because the Oracle DBA asked me to do so, that is all. I first configured a data source named 'HMC' like this in my tnsnames.ora file on my local development machine before creating my ODBC DSN also named 'HMC' hmc = (DESCRIPTION = (ADDRESS_LIST =...

Hi, I have a custom SQL Server 2000 database that I will be using to drive the interfaces for my ASP.Net application that will be used only on an intranet. My SQL Server 2000 database will be connecting to an Oracle database to synchronize data for a couple of tables so that the master data is...

Hi, Here is the situation: I have to pass a field value from the main report to a sub-report. I do not want to use a parameter in the sub-report to store the value of the main report field. Also, I use a command in the sub-report that has a field that can be equated to the main report field...

That did it!!! I added 'WhilePrintingRecords' at the beginning of each shared variable formula within the subreports. The total came up right and worked perfectly. Thank you so much. Chad

No, I had not placed my shared variable formulas in the report footers of each subreport. But I did now, however the resut was the same, the individual subreport variable formulas turn out to be just fine. The main report still shows a zero value. Chad

Hi lbass, I also have other subreports that are not needed for this total. They are in detail_a, detail_b, detail_e, and detail_f. The subreport totals that I need - those subreports are in detail_c and detail_d. I inserted a section below all the subreports and am placing my main report...

Hi, I have 2 subreports each of which has a Month-to-date (MTD) total stored in a shared variable. The subreports occupy different sections in the detail section of the main report. I need to total the subreport totals in the main report. SUBREPORT I: Formula field name...

Hi, I have a MS DB Grid control in VB 6 that is bound to a recordset with a static cursor and optimistic lock. Step I) I am able to bind it and display the data fine. When I double-click on column 2 (colindex = 1) or column 3 (colindex = 2), I take the focus to a listbox populated in a...

Thanks to you all, since I had the same Invalid TLV record problems, and the same 3 dlls packaged into my VB 6 app (cxlibw-1-6.dll, dbghelp.dll and etc-1-0-12-1.dll) worked wonders!!! My app is now running like it should. css1015

Sh0jin, Add a component/reference to the Crystal Report Control in your VB project. Let us say your Crystal Report Control is named ReportControl, use this code to connect and view a report: With ReportControl 'Set path & report name .ReportFileName = strDataPath & strReportSource...

That did it!!! The connnectionproperties bag worked just right for me, now I can open my report that I have created. Thanks a lot, Dave. If I need to install this VB app, do I just let the Package and Deployment wizard run and let it suggest all the needed files or do I have to keep anything...

Hi Vidru, Thanks for your response. I have the following code written: Public crxApplication As New CRAXDRT.Application Public Report As CRAXDRT.Report Dim crxDBTable As CRAXDRT.DatabaseTable Set Report = crxApplication.OpenReport(strCommonPath, 1) where strCommonPath is the concatenation...

Hi, I am totally new to Crystal Reports 10.0 from the programming point of view. Crystal Reports 8.5 used to provide a Crystal Report control that I could place on my VB 6.0 form and launch the 8.5 report from within VB 6.0. But with Crystal Reports 10.0, that control is not available. I am...

Hi, I am totally new to Crystal Reports 10.0 from the programming point of view. Crystal Reports 8.5 used to provide a Crystal Report control that I could place on my VB 6.0 form and launch the 8.5 report from within VB 6.0. But with Crystal Reports 10.0, that control is not available. I am...