Crystal 11 Report Parameters

This forum is for eXpress++ general support.
Post Reply
Message
Author
Stuart.Fraser
Posts: 17
Joined: Thu Jan 28, 2010 10:07 am
Location: Victoria, BC Canada
Contact:

Crystal 11 Report Parameters

#1 Post 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

Stuart.Fraser
Posts: 17
Joined: Thu Jan 28, 2010 10:07 am
Location: Victoria, BC Canada
Contact:

Re: Crystal 11 Report Parameters

#2 Post 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

Andy Edward
Posts: 103
Joined: Fri Sep 17, 2010 2:58 am

Re: Crystal 11 Report Parameters

#3 Post 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

User avatar
unixkd
Posts: 575
Joined: Thu Feb 11, 2010 1:39 pm

Re: Crystal 11 Report Parameters

#4 Post by unixkd »

Have you try fastreport for xbase++ ? Awasome !!!

Joe

Cliff Wiernik
Posts: 605
Joined: Thu Jan 28, 2010 9:11 pm
Location: Steven Point, Wisconsin USA
Contact:

Re: Crystal 11 Report Parameters

#5 Post 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.

User avatar
unixkd
Posts: 575
Joined: Thu Feb 11, 2010 1:39 pm

Re: Crystal 11 Report Parameters

#6 Post 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.

Post Reply