dBASE Reports - dBase Plus 2.6 and CR 9

Author

dBase Plus 2.6 and CR 9

albwillin

2005-10-27, 8:02 am

I found dBase Plus doesn't have Crystal Reports as part of its integrated reporting mechanisms two years ago, I tried the following:

1. To allow Windows XP security to allow for Active X installation for downloads and installs.

2. I did install the Crystal Reports 9.0 Professional

3. I tried to use the whitepaper from http://www.maplesoft.net/crystal.htm
but I could never get the Active X component "Crystal Reports Control" when I try to Setup the Active X control-it doesn't appear in the Available Components.

Is there any newer whitepapers utilizing dBase 2.6 and CR9?

*Lysander*

2005-10-27, 8:02 am

In article <Rz3vrBKyFHA.1132@news-server>, albwillin@yahoo.com says...

> but I could never get the Active X component "Crystal Reports=20
Control" when I try to Setup the Active X control-it doesn't appear in=20
the Available Components.

Just to make sure that I understood correctly:
it did not appear on the tab "active x",
or,
it did also not appear in the list that opens if you are searching for a=20
new control?

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de

Richard Perryman

2005-10-27, 8:02 am

albwillin wrote:
> I found dBase Plus doesn't have Crystal Reports as part of its integrated reporting mechanisms two years ago, I tried the following:
>
> 1. To allow Windows XP security to allow for Active X installation for downloads and installs.
>
> 2. I did install the Crystal Reports 9.0 Professional
>
> 3. I tried to use the whitepaper from http://www.maplesoft.net/crystal.htm
> but I could never get the Active X component "Crystal Reports Control" when I try to Setup the Active X control-it doesn't appear in the Available Components.
>
Your right - they discontinued that method of activex for ver 8 at my
website

> Is there any newer whitepapers utilizing dBase 2.6 and CR9?
>

I know for sure there are people here using ver 9 & 10 of Crystal. Just
do a search of the dbase newsgroups and you'll see examples of how to
use it.

*Lysander*

2005-10-27, 8:02 am

In article <E1bTGUOyFHA.532@news-server>, richard@vipindustrie
s.com=20
says...

> Your right - they discontinued that method of activex for ver 8 at my=20
> website

ah! Then it is clear.
I must admit that I do not know the article on maplesoft, so I did not=20
know it was for the CR 8 method.

Look at my answer to Charles L. on his post from 24th september.

exchange the following:
CrxApp =3D new OLEAutoClient("CrystalRuntime.Application.10")
into
CrxApp =3D new OLEAutoClient("CrystalRuntime.Application.9")

pay attention also to another sequence (ID) for the active-x control.

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de

albwillin

2005-10-27, 8:02 am

*Lysander* Wrote:

> In article <Rz3vrBKyFHA.1132@news-server>, albwillin@yahoo.com says...
>
>
> Control\" when I try to Setup the Active X control-it doesn't appear in
> the Available Components.
>
> Just to make sure that I understood correctly:
> it did not appear on the tab \"active x\",
> or,
> it did also not appear in the list that opens if you are searching for a
> new control?
>
>
> --
> ciao,
> André
> ~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
> Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
> Deutschsprachige Konferenz zu dBase und anderen Datenbanken
> Info: www.dbase-konferenz.de

I did not see it in the active x components, but I was on a computer with
this STIG and that does foul a lot of things up when using dBase. I installed CR9 on a computer that is STIG-free and the Crystal Report Viewer component did appear. I used the following code from a posting in this forum and everything went superbly:

function form_onOpen
form.text=\"View Report: My Test Report\"
Form.crxApp = new OLEAutoClient(\"CrystalRuntime.Application.9\")
Form.crxRep = Form.CrxApp.OpenReport(\"Report1.rpt\")
Form.ActiveX1.NativeObject.ReportSource = Form.crxRep
Form.ActiveX1.NativeObject.ViewReport()
return

function nativeObject_PrintBu
ttonClicked(UseDefau
lt)
chooseprinter()
return

But I come into a minor problem-how to refresh the changes made in the
Database.

Scenario #1
I used an existing .rpt file and I click the refresh button and I get a Crystal Report Viewer prompt stating the crdb_p2bbde.dll could not be loaded. Any solutions to this? (see attachment)

Scenario #2
I created a new table and I click the refresh button and I get a Crystal Report Viewer prompt stating it is not supported. No clue on this either.
(see attachment)

I know there is a onClickRefreshButton
in the NativeObject, but Refresh("database.bdf") didn'tl work .....I am almost there!

*Lysander*

2005-10-27, 8:02 am

In article <nDWrylTyFHA.1412@news-server>, albwillin@yahoo.com says...

1.) Sir, please do NEVER again post such big attachments in this=20
newsgroup. Use the group "binaries" instead, which is especially for big=20
attachments.
It took about 2 minutes for my connection to load the picture, and this=20
is very disturbing.

2.) what is STIG?? I never heard about this.

> But I come into a minor problem-how to refresh the changes made in the=20
> Database.

> Scenario #1
> I used an existing .rpt file and I click the refresh button and I get=20
a Crystal Report Viewer prompt stating the crdb_p2bbde.dll could not be=20
loaded. Any solutions to this? (see attachment)

if you want to load older versions of crystal reports *.rpt, it is=20
possible that you will have to "convert the database driver". This is=20
usually the case if your reports are still originally created in CR 3=20
(the version that came with dBase 5.x)

I am clueless, though, how to convert the database driver in CR 9 and CR=20
10. It was quite easy in CR 7, but in 9 and 10 it must be hidden in a=20
submenu of the "change database source" menu.
Read your helpfiles to find exactly what to do.

> Scenario #2
> I created a new table and I click the refresh button and I get a=20
Crystal Report Viewer prompt stating it is not supported. No clue on=20
this either.

What do you mean "I created a new table"?
You created a new table using dBase-Plus and gave to this table the same=20
name like an old table which was used by CR and wanted CR to read the=20
new table instead of the old???
Please describe - in text, not in pictures :) - which steps you are=20
doing.

> I know there is a onClickRefreshButton
in the NativeObject, but=20
Refresh("database.bdf") didn'tl work .....I am almost there!

I suppose the solution is somewhere else...

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de

albwillin

2005-10-27, 8:02 am

*Lysander* Wrote:

> In article <nDWrylTyFHA.1412@news-server>, albwillin@yahoo.com says...
>
>
> 1.) Sir, please do NEVER again post such big attachments in this
> newsgroup. Use the group "binaries" instead, which is especially for big
> attachments.
> It took about 2 minutes for my connection to load the picture, and this
> is very disturbing.
>
> 2.) what is STIG?? I never heard about this.
>
>
> a Crystal Report Viewer prompt stating the crdb_p2bbde.dll could not be
> loaded. Any solutions to this? (see attachment)
>
> if you want to load older versions of crystal reports *.rpt, it is
> possible that you will have to "convert the database driver". This is
> usually the case if your reports are still originally created in CR 3
> (the version that came with dBase 5.x)
>
> I am clueless, though, how to convert the database driver in CR 9 and CR
> 10. It was quite easy in CR 7, but in 9 and 10 it must be hidden in a
> submenu of the "change database source" menu.
> Read your helpfiles to find exactly what to do.
>
> Crystal Report Viewer prompt stating it is not supported. No clue on
> this either.
>
> What do you mean "I created a new table"?
> You created a new table using dBase-Plus and gave to this table the same
> name like an old table which was used by CR and wanted CR to read the
> new table instead of the old???
> Please describe - in text, not in pictures :) - which steps you are
> doing.
>
> Refresh("database.bdf") didn'tl work .....I am almost there!
>
> I suppose the solution is somewhere else...
>
>
>
> --
> ciao,
> André
> ~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
> Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
> Deutschsprachige Konferenz zu dBase und anderen Datenbanken
> Info: www.dbase-konferenz.de

My apologies for the attachment, Stigs are security scripts my organization created two years ago and wreaks havoc on user computers, they didn't do a thorough job on testing the security with user's software.

Wrong phrasing-I meant that I created a new report from the same table.

I was trying to see if the refresh("database.dbf") was placed at the beginning of the form_onOpen, so the report would automatically
refresh the data that was changed in the buffer--still looking out there.

*Lysander*

2005-10-27, 8:02 am

In article <b2Ni6ghyFHA.1044@news-server>, albwillin@yahoo.com says...

> My apologies for the attachment,=20
taken, it was not a big offense to me, but I know that there are people=20
with even less fast connections.

> Wrong phrasing-I meant that I created a new report from the same=20
table.
That makes the scenario a bit more clear.
Which table format are you using for this? CR should automatically take=20
the correct database-driver if you have level-7 tables.

if you are using the active-x/RDC-method for viewing your reports, there=20
should be a refresh()-method of the report-object.
You should be able to call this method and refresh the complete report=20
at any time you wish.

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
Deutsche dBase-Konferenz dBKon 2005 ::: 11. bis 13. November 2005
Deutschsprachige Konferenz zu dBase und anderen Datenbanken
Info: www.dbase-konferenz.de

Sponsored Links