Hi Folks,
I'm working with Crystal 11 running against an Oracle 11g database. Anyone have any ideas on how to pass parameters to the report?
Thanks,
Stu
Crystal 11 Report Parameters
-
- Posts: 17
- Joined: Thu Jan 28, 2010 10:07 am
- Location: Victoria, BC Canada
- Contact:
-
- Posts: 17
- Joined: Thu Jan 28, 2010 10:07 am
- Location: Victoria, BC Canada
- Contact:
Re: Crystal 11 Report Parameters
Just in case you ever have to do this:
Local cReport:="MyReportName.rpt"
oCrystal := ActiveXObject():create( "CrystalRuntime.Application.11" ) // create the Crystal Report Object
oReport:=oCrystal:openreport(cReport) // Configure the report
oReport:ParameterFields:GetItemByName(<Param Name>):ClearCurrentValueAndRange() // clear any saved data
oReport:ParameterFields:GetItemByName(<Param Name>):AddCurrentValue( <value> ) // set the new value
Local cReport:="MyReportName.rpt"
oCrystal := ActiveXObject():create( "CrystalRuntime.Application.11" ) // create the Crystal Report Object
oReport:=oCrystal:openreport(cReport) // Configure the report
oReport:ParameterFields:GetItemByName(<Param Name>):ClearCurrentValueAndRange() // clear any saved data
oReport:ParameterFields:GetItemByName(<Param Name>):AddCurrentValue( <value> ) // set the new value
-
- Posts: 103
- Joined: Fri Sep 17, 2010 2:58 am
Re: Crystal 11 Report Parameters
Hi Stuart,
Is there a site that lists all the CR methods available for us to use in a XBASE application?
Best Regards,
Andy
Is there a site that lists all the CR methods available for us to use in a XBASE application?
Best Regards,
Andy
Re: Crystal 11 Report Parameters
Have you try fastreport for xbase++ ? Awasome !!!
Joe
Joe
-
- Posts: 605
- Joined: Thu Jan 28, 2010 9:11 pm
- Location: Steven Point, Wisconsin USA
- Contact:
Re: Crystal 11 Report Parameters
How are you using it. I had read that the developer of the FRAX component that used fastreport has passed away.
Are you using directly or in some other fashion.
Cliff.
Are you using directly or in some other fashion.
Cliff.
Re: Crystal 11 Report Parameters
Yes you are correct. Sergey passed on some months ago. I purchased FRAX from him before his demis. Using FRAX is extremely easy. All Xbase++ data types are supported. Variables (All types), objects, functions, macros just name it. I have done hundreds of reports with it in the last two years. Awasome !!! If you can conceptualize a report, fastreport can actualise it. The power is unbelievable.
I learnt that the wife is still selling it. But I advice that you download the trial and do some stuffs first to convince yourself.
If you need further assistance do let me know.
Joe.
I learnt that the wife is still selling it. But I advice that you download the trial and do some stuffs first to convince yourself.
If you need further assistance do let me know.
Joe.