Page 1 of 1

Crystal 11 Report Parameters

Posted: Fri Dec 03, 2010 10:11 am
by Stuart.Fraser
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

Re: Crystal 11 Report Parameters

Posted: Fri Dec 17, 2010 9:16 am
by Stuart.Fraser
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

Re: Crystal 11 Report Parameters

Posted: Mon Oct 07, 2013 12:04 am
by Andy Edward
Hi Stuart,

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

Posted: Sun Oct 13, 2013 6:43 pm
by unixkd
Have you try fastreport for xbase++ ? Awasome !!!

Joe

Re: Crystal 11 Report Parameters

Posted: Sun Oct 13, 2013 6:48 pm
by Cliff Wiernik
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.

Re: Crystal 11 Report Parameters

Posted: Mon Oct 14, 2013 3:36 am
by unixkd
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.