5 Parameters 4 using ranges to create a report

[HyperHeidi]

Hi All,

I am "BRAND NEW" to Crystal repots and am very lost in what is probably a very simple line of code. I am taking an existing report and changing it.

I have a report that has 4 parameters that require ranges and 1 parameter that requires a discrete value.
Ranges are: Discrete Value:
Fiscal Year General Ledger Account
Fiscal period
Name
Program

I have the parameter values all setup in the report I just don't know how to change my code from being:
{APIBD.IDGLACCT} = {?GLACCT} and {APOBL.FISCYR}={?Year} and {APOBL.FISCPER}={?Period}
When I was dealing with all discrete values to changing them to ranges and adding more variables.

If you can tell me what I need to do I would really appreciate it.

Also, is there any online free crystal report books or notes just on how to code. I can't find our copy of CR to install help and IT decided it was too big.

Thank you
Heidi

 

[synapsevampire]

Your record selection criteria should be fine still, Crystal will resolve whether it's a multi or not.

Check the Database->Show Sql to confirm that it's being passed to the database.

The name and program parms don't seem to be referenced here, is that your question, or???

I'll assume that you're using the term variables when you meant the term parameters.

To create parameters, use the field explorer and right click the parameters section and select New.

Add to the record selection criteria something like:

{MyTable.Name} = {?Name}
and
{MyTable.Program} = {?Program}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com