Hello all,

I am trying to use Crystal Reports 8.5 with Powerbuilder 8 but I am
experiencing some problems.
If I try to insert the Crystal Report Designer Control onto a Powerbuilder
form then the form will crash.
Does anyone know if the OCX controls of Crystal Reports work properly under
Powerbuilder? Am I missing sth?
I'm telling that because I used the same controls under Visual Basic and
everything worked properly.

Thanks in advance for your help.

John Kolitsopoulos

Hey John,

Started looking at that but had to go onto something else..The docs on RDC
say you need VB5 or VB6 but say nothing about PB.

Hopefully someone will have better news..


--
Evita R. Chapa
Senior Systems Analyst
Command Technlogies, Inc

"John Kolitsopoulos" <jkol@emphasis-systems.gr> wrote in message
news:axYwnmIDCHA.201@forums.sybase.com...
> Hello all,
>
> I am trying to use Crystal Reports 8.5 with Powerbuilder 8 but I am
> experiencing some problems.
> If I try to insert the Crystal Report Designer Control onto a Powerbuilder
> form then the form will crash.
> Does anyone know if the OCX controls of Crystal Reports work properly
under
> Powerbuilder? Am I missing sth?
> I'm telling that because I used the same controls under Visual Basic and
> everything worked properly.
>
> Thanks in advance for your help.
>
> John Kolitsopoulos
>
>
>

I am also unable to insert the Embeddable Crystal Report Designer Control
onto a window.(because it is VB only ?).
However I managed to access it programmically. To view the report, I used
the Crystal Report Viewer Control. The properties and methods you can access
are described in the Developer Help File (search for Report Designer in
'CrystalDevHelp.chm').
In underneath example I pass parameters and requery the data of a crystal
report by code and than display the result.

n_oo loo_application
oleobject  loo_report

loo_application = create n_oo

TRY
    // Programmically connecting to RDC
    ll_ret =loo_application.connecttoNewobject("CrystalRuntime.Application")

    // open a report
    loo_report = loo_application.OpenReport("c:\temp\city.rpt", 1)
    // connect to DB using ODBC test_dsn
    loo_application.LogOnServer("PDSODBC.DLL","test_dsn","","userid","pwd")
    // discard saved data
    loo_report.DiscardSavedData()
    // Set first parameter
    loo_report.ParameterFields.item[1].AddCurrentValue ("BE")
    ...

    // Retrieve All Data
    loo_report.ReadRecords()

     // display report using the visual crystal report viewer control
    ole_report_viewer.object.ReportSource(loo_report)
    ole_report_viewer.object.ViewReport()

CATCH (runtimeerror er)
    Messagebox ("Error","Error occured in code: " + er.getmessage())
END TRY


* If you omit the ' loo_report.ParameterFields.item[1].AddCurrentValue
("BE")', Crystal report will prompt you for the parameters itself
* The 'loo_report.ReadRecords()' make the loo_report object retrieve the
data, if you omit this one, then the ole_report_viewer will retrieve the
data (because of the 'loo_report.DiscardSavedData()')
* Some more post are available in this newsgroup, you might one search for
them.


Kind regards,

Gert Van der Straeten




"John Kolitsopoulos" <jkol@emphasis-systems.gr> wrote in message
news:axYwnmIDCHA.201@forums.sybase.com...
> Hello all,
>
> I am trying to use Crystal Reports 8.5 with Powerbuilder 8 but I am
> experiencing some problems.
> If I try to insert the Crystal Report Designer Control onto a Powerbuilder
> form then the form will crash.
> Does anyone know if the OCX controls of Crystal Reports work properly
under
> Powerbuilder? Am I missing sth?
> I'm telling that because I used the same controls under Visual Basic and
> everything worked properly.
>
> Thanks in advance for your help.
>
> John Kolitsopoulos
>
>
>

Thanks for your help.



"Van der Straeten Gert" <no_spam_gert.vanderstraeten@ipc.be> wrote in
message news:W8Jug7SDCHA.81@forums.sybase.com...
> I am also unable to insert the Embeddable Crystal Report Designer Control
> onto a window.(because it is VB only ?).
> However I managed to access it programmically. To view the report, I used
> the Crystal Report Viewer Control. The properties and methods you can
access
> are described in the Developer Help File (search for Report Designer in
> 'CrystalDevHelp.chm').
> In underneath example I pass parameters and requery the data of a crystal
> report by code and than display the result.
>
> n_oo loo_application
> oleobject  loo_report
>
> loo_application = create n_oo
>
> TRY
>     // Programmically connecting to RDC
>     ll_ret
=loo_application.connecttoNewobject("CrystalRuntime.Application")
>
>     // open a report
>     loo_report = loo_application.OpenReport("c:\temp\city.rpt", 1)
>     // connect to DB using ODBC test_dsn
>
loo_application.LogOnServer("PDSODBC.DLL","test_dsn","","userid","pwd")
>     // discard saved data
>     loo_report.DiscardSavedData()
>     // Set first parameter
>     loo_report.ParameterFields.item[1].AddCurrentValue ("BE")
>     ...
>
>     // Retrieve All Data
>     loo_report.ReadRecords()
>
>      // display report using the visual crystal report viewer control
>     ole_report_viewer.object.ReportSource(loo_report)
>     ole_report_viewer.object.ViewReport()
>
> CATCH (runtimeerror er)
>     Messagebox ("Error","Error occured in code: " + er.getmessage())
> END TRY
>
>
> * If you omit the ' loo_report.ParameterFields.item[1].AddCurrentValue
> ("BE")', Crystal report will prompt you for the parameters itself
> * The 'loo_report.ReadRecords()' make the loo_report object retrieve the
> data, if you omit this one, then the ole_report_viewer will retrieve the
> data (because of the 'loo_report.DiscardSavedData()')
> * Some more post are available in this newsgroup, you might one search for
> them.
>
>
> Kind regards,
>
> Gert Van der Straeten
>
>
>
>
> "John Kolitsopoulos" <jkol@emphasis-systems.gr> wrote in message
> news:axYwnmIDCHA.201@forums.sybase.com...
> > Hello all,
> >
> > I am trying to use Crystal Reports 8.5 with Powerbuilder 8 but I am
> > experiencing some problems.
> > If I try to insert the Crystal Report Designer Control onto a
Powerbuilder
> > form then the form will crash.
> > Does anyone know if the OCX controls of Crystal Reports work properly
> under
> > Powerbuilder? Am I missing sth?
> > I'm telling that because I used the same controls under Visual Basic and
> > everything worked properly.
> >
> > Thanks in advance for your help.
> >
> > John Kolitsopoulos
> >
> >
> >
>
>

Yes, someone else told me that..For whatever reason, you can't access any of
the methods or properties unless you go into VB and then once you know the
names, then you can use then in PB(how weird is that..)...


--
Evita R. Chapa
Senior Systems Analyst
Command Technlogies, Inc

"Van der Straeten Gert" <no_spam_gert.vanderstraeten@ipc.be> wrote in
message news:W8Jug7SDCHA.81@forums.sybase.com...
> I am also unable to insert the Embeddable Crystal Report Designer Control
> onto a window.(because it is VB only ?).
> However I managed to access it programmically. To view the report, I used
> the Crystal Report Viewer Control. The properties and methods you can
access
> are described in the Developer Help File (search for Report Designer in
> 'CrystalDevHelp.chm').
> In underneath example I pass parameters and requery the data of a crystal
> report by code and than display the result.
>
> n_oo loo_application
> oleobject  loo_report
>
> loo_application = create n_oo
>
> TRY
>     // Programmically connecting to RDC
>     ll_ret
=loo_application.connecttoNewobject("CrystalRuntime.Application")
>
>     // open a report
>     loo_report = loo_application.OpenReport("c:\temp\city.rpt", 1)
>     // connect to DB using ODBC test_dsn
>
loo_application.LogOnServer("PDSODBC.DLL","test_dsn","","userid","pwd")
>     // discard saved data
>     loo_report.DiscardSavedData()
>     // Set first parameter
>     loo_report.ParameterFields.item[1].AddCurrentValue ("BE")
>     ...
>
>     // Retrieve All Data
>     loo_report.ReadRecords()
>
>      // display report using the visual crystal report viewer control
>     ole_report_viewer.object.ReportSource(loo_report)
>     ole_report_viewer.object.ViewReport()
>
> CATCH (runtimeerror er)
>     Messagebox ("Error","Error occured in code: " + er.getmessage())
> END TRY
>
>
> * If you omit the ' loo_report.ParameterFields.item[1].AddCurrentValue
> ("BE")', Crystal report will prompt you for the parameters itself
> * The 'loo_report.ReadRecords()' make the loo_report object retrieve the
> data, if you omit this one, then the ole_report_viewer will retrieve the
> data (because of the 'loo_report.DiscardSavedData()')
> * Some more post are available in this newsgroup, you might one search for
> them.
>
>
> Kind regards,
>
> Gert Van der Straeten
>
>
>
>
> "John Kolitsopoulos" <jkol@emphasis-systems.gr> wrote in message
> news:axYwnmIDCHA.201@forums.sybase.com...
> > Hello all,
> >
> > I am trying to use Crystal Reports 8.5 with Powerbuilder 8 but I am
> > experiencing some problems.
> > If I try to insert the Crystal Report Designer Control onto a
Powerbuilder
> > form then the form will crash.
> > Does anyone know if the OCX controls of Crystal Reports work properly
> under
> > Powerbuilder? Am I missing sth?
> > I'm telling that because I used the same controls under Visual Basic and
> > everything worked properly.
> >
> > Thanks in advance for your help.
> >
> > John Kolitsopoulos
> >
> >
> >
>
>

It seems that the Crystal Report Designer Control works under VB as you told
me.
However, I am thinking of creating an OCX control containing the Crystal
Report Designer Control.
Then, I will try to use the OCX control under PB. I want to use the
designing features of the control without making a new one by myself.



"E Chapa" <echapa@commtechinc.com> wrote in message
news:xglnqPVDCHA.277@forums.sybase.com...
> Yes, someone else told me that..For whatever reason, you can't access any
of
> the methods or properties unless you go into VB and then once you know the
> names, then you can use then in PB(how weird is that..)...
>
>
> --
> Evita R. Chapa
> Senior Systems Analyst
> Command Technlogies, Inc
>
> "Van der Straeten Gert" <no_spam_gert.vanderstraeten@ipc.be> wrote in
> message news:W8Jug7SDCHA.81@forums.sybase.com...
> > I am also unable to insert the Embeddable Crystal Report Designer
Control
> > onto a window.(because it is VB only ?).
> > However I managed to access it programmically. To view the report, I
used
> > the Crystal Report Viewer Control. The properties and methods you can
> access
> > are described in the Developer Help File (search for Report Designer in
> > 'CrystalDevHelp.chm').
> > In underneath example I pass parameters and requery the data of a
crystal
> > report by code and than display the result.
> >
> > n_oo loo_application
> > oleobject  loo_report
> >
> > loo_application = create n_oo
> >
> > TRY
> >     // Programmically connecting to RDC
> >     ll_ret
> =loo_application.connecttoNewobject("CrystalRuntime.Application")
> >
> >     // open a report
> >     loo_report = loo_application.OpenReport("c:\temp\city.rpt", 1)
> >     // connect to DB using ODBC test_dsn
> >
> loo_application.LogOnServer("PDSODBC.DLL","test_dsn","","userid","pwd")
> >     // discard saved data
> >     loo_report.DiscardSavedData()
> >     // Set first parameter
> >     loo_report.ParameterFields.item[1].AddCurrentValue ("BE")
> >     ...
> >
> >     // Retrieve All Data
> >     loo_report.ReadRecords()
> >
> >      // display report using the visual crystal report viewer control
> >     ole_report_viewer.object.ReportSource(loo_report)
> >     ole_report_viewer.object.ViewReport()
> >
> > CATCH (runtimeerror er)
> >     Messagebox ("Error","Error occured in code: " + er.getmessage())
> > END TRY
> >
> >
> > * If you omit the ' loo_report.ParameterFields.item[1].AddCurrentValue
> > ("BE")', Crystal report will prompt you for the parameters itself
> > * The 'loo_report.ReadRecords()' make the loo_report object retrieve the
> > data, if you omit this one, then the ole_report_viewer will retrieve the
> > data (because of the 'loo_report.DiscardSavedData()')
> > * Some more post are available in this newsgroup, you might one search
for
> > them.
> >
> >
> > Kind regards,
> >
> > Gert Van der Straeten
> >
> >
> >
> >
> > "John Kolitsopoulos" <jkol@emphasis-systems.gr> wrote in message
> > news:axYwnmIDCHA.201@forums.sybase.com...
> > > Hello all,
> > >
> > > I am trying to use Crystal Reports 8.5 with Powerbuilder 8 but I am
> > > experiencing some problems.
> > > If I try to insert the Crystal Report Designer Control onto a
> Powerbuilder
> > > form then the form will crash.
> > > Does anyone know if the OCX controls of Crystal Reports work properly
> > under
> > > Powerbuilder? Am I missing sth?
> > > I'm telling that because I used the same controls under Visual Basic
and
> > > everything worked properly.
> > >
> > > Thanks in advance for your help.
> > >
> > > John Kolitsopoulos
> > >
> > >
> > >
> >
> >
>
>