Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. delu0007

    ODBC and SQL Server 2000

    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...
  2. delu0007

    Active Data Driver - ASP Project

    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...
  3. delu0007

    Driver for SQL Server report

    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...
  4. delu0007

    SQL Server datetime fields not displaying

    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...
  5. delu0007

    Format number in Group Tree View

    Thank you. It worked perfectly.
  6. delu0007

    Format number in Group Tree View

    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...
  7. delu0007

    Format number in Group Tree View

    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...
  8. delu0007

    Active Data & Linking

    "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...
  9. delu0007

    Active Data & Linking

    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...
  10. delu0007

    CR8--VB6/Active Data Driver--Page Header

    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.
  11. delu0007

    CR8--VB6/Active Data Driver--Page Header

    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...
  12. delu0007

    Passing ADO rs to a report which has more than one table...

    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...
  13. delu0007

    CR 8 & Access 2000 - Errors about pdbbtrv.dll & recognizing file

    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...
  14. delu0007

    CR 8 & Access 2000 - Errors about pdbbtrv.dll & recognizing file

    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...
  15. delu0007

    CR 8 & Access 2000 - Errors about pdbbtrv.dll & recognizing file

    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...
  16. delu0007

    CR 8 & Access 2000 - Errors about pdbbtrv.dll & recognizing file

    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...
  17. delu0007

    CR 8 & Access 2000 - Errors about pdbbtrv.dll & recognizing file

    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...
  18. delu0007

    CR 8 & Access 2000 - Errors about pdbbtrv.dll & recognizing file

    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...
  19. delu0007

    CR 8 & Access 2000 - Errors about pdbbtrv.dll & recognizing file

    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...
  20. delu0007

    One Report - both Access and SQL - in VB

    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...

Part and Inventory Search

Back
Top