Re: Why Access 97 Reports are dozen times faster than Delphi Reports?

Manolis,

As far as reporting is concerned I tend to use Report Manager as it is free ware Open Source and built entirely in Delphi. Also has reporting server I have still to see any commercial and very costly Reporting tools in Delphi to have implemented a Reporting Server....

I also must say you should have consulted someone in this NG before going for all these commercial components (an waisting your hard earned money).

For accessing MSSQL you should have tried SDAC from Core Labs as it bypasses all the layers for data access like ADO and directly communicates with MSSQL through OLEDB like Access. But as far as my knowledge goes MS Access 97 is using DAO for all kinds of data access as my tests in VB has revealed that DAO is any time faster than ADO. Though ADO does use a bit more memory than ADO but that is negligible.

Have you tries kaDAO freeware components from Delphi Warrior?

http://www.kadao.dir.bg/products.htm

Regards,

Yogi Yang
.

Relevant Pages

  • Re: GetComputerName
    ... The use of a String as a buffer simplifies things substantially ... Delphi allows us to send it to APIs as a PChar ... Some APIs perform differently between versions of Windows ... Reporting the result of GetLastError is a pretty generic task ...
    (alt.comp.lang.borland-delphi)
  • Re: Stop worrying about technology. Start worrying about who trusts you.
    ... I have a framework I wrote in Delphi before I ... and Exception Reporting, ... includes, Credit Reporting, Inventory management, Deal Management, ...
    (borland.public.delphi.non-technical)
  • Re: Next vresion reporting
    ... >In the next version of Delphi, by that I mean the one after Delphi ... >discussion, scuttlebutt, or other information as to what reporting ... I suspect the .NET version of the product will include Crystal Reports ...
    (borland.public.delphi.non-technical)
  • Re: Next vresion reporting
    ... I need quite nicely and I haven't made the switch to Rave yet. ... > In the next version of Delphi, by that I mean the one after Delphi ... > discussion, scuttlebutt, or other information as to what reporting ...
    (borland.public.delphi.non-technical)
  • Allow users to input in a data access pages form?
    ... I am setting up data access pages. ... Everything is working as far as reporting ... and queries. ... regards to permissions that would stop the users from being able to perform ...
    (microsoft.public.access.forms)