Recent content by delu0007

I am trying to create CR8 reports that run off of SQL Server 2000 databases using an ODBC DSN. The reports are to be viewed through both a VB Application and an ASP Project. It works in the Crystal Reports Environment, and can be displayed in the VB Application (I haven't tried in the ASP...

How do I view reports based on the Active Data Driver through an ASP Project? I have reports that are based on the Active Data Driver to connect to either MS Access 2000 or MS SQL Server 2000 databases. I have a VB Application and an ASP Project designed to view these reports. The VB...

I am trying to create reports to run off of SQL Server databases. It is to be used through both a Visual Basic application and an ASP project. The reports will be based of off as many as 5 tables, most linked together with one non-linked table's information in the Page Header area. Which...

I have a report based on a SQL Server database. All of the datetime fields display as 'Jan 01, 4294962583 12:00:00 AM'. If I choose the "Browse Field Data" option, all the datetime values appear correctly in the list. I have checked in File-Report Options and the 'Convert Date-Time...

Thank you. It worked perfectly.

Thanks for the response. I tried the first method, and it seemed to work great for changing the number format of the group tree. The only problem is that it is only effective on the development machine. Once the report is distributed through VB and ASP projects, the number is displayed...

I have a report based on an Access 2000 database. I have a grouping based on a field of type Long Integer. When the Group Tree View pane is visible, the numbers greater than 1000 have a comma in them (1,000). The field (that is being grouped on) in the report is formatted to not display a...

"Control source"? What exactly is the control source? The original report was created off of Access tables using the "Find database file" method of accessing the data. The dll it uses is PDBDAO.dll (MS DAO). The report I am trying to create is Active Data on a SQL Server...

I am trying to create a report that combines 4 tables from a single database. This database can be either MS Access or MS SQL Server. I chose the Active Data Driver in an attempt to have only one version of the report that I can use against either type of database. The report will be viewed...

I recreated a report using one recordset that joins the two data tables and a subreport containing the other recordset. It works in both the CR8 environment as well as in my VB application -- based on either SQL Server or Access. Thank you for your help.

I have a CR8 report created that uses the Active Data Driver to connect to an Access 2000 database or SQL Server 2000 database. The report contains three recordsets, two of which are linked and placed in the details section. The third recordset is in the page header section and is not linked...

Did you ever receive an answer to this question? I am experiencing a similar problem. I loop through all the tables, and SetDataSource to the appropriate recordset. When the report previews, the fields in the page header are blank. Opening the same report and database within CR 8 works fine...

I don't beleive I installed anything else. I did a find for all files modified or created since last monday, and nothing unusual popped up. The Seagate Software folder (from reinstalling) and a Wise Installation Wizard folder (from the Distribution Expert) were the only new folders created...

Did you install anything else that day to the PC that might have changed something? Now that I think about it, I installed the scr8_distr_expert.exe which enables the 'Compiled Report' option for Crystal Reports 8(I was not planning on using this option for development use, it was only for a few...

You can create a new report against Xtreme.mdb using DAO, but you can't create a new report against an MS Access 2000 MDB? Yes, this is correct. Do you have a version of MS Access installed on this PC? What version? Yes, MS Access 2000 (9.0.4402 SR-1) You say that these V8 reports were...