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...
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...
One more thing:
After trying to "Set Location" once and receiving the two errors I mentioned before, I try again and receive a password prompt for the access database (There is no password protection on the database). After clicking the cancel button, I receive the second error that...
Most of the reports were originally created in CR 6 or 7, but they have all been saved in CR 8. I was working just fine with CR 8 until the middle of last week, when an error began popping up when trying to view the reports through a VB application (I had been viewing reports through the same...
The reports are currently using the dao driver (PDBDAO.DLL). I tried using the "Convert database driver" menu option but it complains that the mdb file that I originally based the report on no longer exists, and I can't "Set Location" to a different file.
I'm not using...
I just reinstalled CR 8 and am trying to open a report that is based on an Access 2000 database. The database that it was based on no longer exists, so I want to "Set Location" to another database. When I choose a database file, I get the following error:
Configuration Error...
I kind of came to the same resolution: either write a duplicate report for each of my existing ones, or change them all to the active data driver. Neither solution is what I really wanted to do -- there are already 200+ reports written, so either solution will be time consuming. Thanks for the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.