Re: Bind dhRichClient RS to VSView Reporting Edition


Schmidt wrote:
"phil_mac" <phil_mac@xxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:Ocq8N%23MPKHA.220@xxxxxxxxxxxxxxxxxxxxxxx
A project that I am moving from MS Access to SQLite uses VSView from
ComponentOne to produce reports. This was fairly easy to implement.
However I am not having any success with the change to SQLite. I have
used examples from VSView Help along with an example from Olaf of
binding to a vsFlexGrid, to create a class that (should) bind a
dhRichClient recordset to a VSReport.
I am unable to get this to work ...

The most Reporting-Tools "out there" work well with ADO-
Reocrdsets (be it disconnected ones or not).

And you can create a freestanding (disconnected) ADO-Rs
over the wrappers SQLite-Rs-Type using:
Dim AdoRs as AdoDB.Recordset
Set AdoRs = SQLiteRs.GetADORsFromContent

Then try to pass such ADORs' to your VSView-
Reporting-engine.

Alternatively (don't know, how large or complex your
Reports are) - you can try the Report-Classes, which
are available in the RichClient3-toolset too (there
should be some smaller Demos in the Demo-Package
how to use them).

Olaf


Olaf

Thanks for your suggestion. Once I added a reference to ADO, your method worked fine. As I have quite a few report definitions already for VSView I will continue to investigate the possibility of writing a class similar to your cFlexBinding.cls.

Thanks

phil mac
.

Relevant Pages

  • Active statement handles mystery?
    ... I have a script that operates on SQLite and SQLite2 that finished like; ... After running successfully, it reports; ... "closing dbh with active statement handles at dl_update line ....." ... undef $sth_users_dbh; ...
    (perl.dbi.users)
  • Re: [kde-linux] Kmail suggestions
    ... plus the blazing speed of sqlite db. ... then doing complex search strings threw 700,000 messages, would take ... be able to do reports... ... I was thinking of making my own database or index to search externally, ...
    (KDE)
  • Re: Bind dhRichClient RS to VSView Reporting Edition
    ... ComponentOne to produce reports. ... However I am not having any success with the change to SQLite. ... Dim AdoRs as AdoDB.Recordset ...
    (microsoft.public.vb.database)
  • Report Generator Suggestions
    ... I'm writing an MFC application that needs a ton of reports based on data stored in SQLite. ... There's not enough money for me to hand code all these reports in C++. ... The only thing I know about Crystal Reports is that I hated it back many years ago when it was included with VB classic. ...
    (microsoft.public.vc.mfc)
  • Re: Strategy NG dying as well
    ... This reports that NPD shows that in North America, ... As Olaf said, that doesn't take into account MMO subscription fees, ...
    (comp.sys.ibm.pc.games.strategic)
Loading