how do I create multiple parameters?? 3

[maggielady]

I finally got my daterange parameter to work!! But I just found out that I need to be able to access the report by daterange and by lastname+firstname. How do I get another parameter in the report so when they run the report it will ask what daterange do you want and whose info do you want to see? Thanks again in advance!!

 

[Reebo99]

edit the date parameter and select Range Value, rather than discrete value.

For the Lastname firstname, just add more parameters.

Reebo
Scotland (Sunny with a Smile)

 

[Reebo99]

Which version of CR are you using?

Reebo
Scotland (Sunny with a Smile)

 

[synapsevampire]

You don't need additional parmeters, just reference them in the record selection formula, as in:

(
{table.date} = {?MyDateParm}
)
and
(
{table.last} = {?MylastParm}
)
and
(
{table.first} = {?MyFirstParm}
)

Check the Database->Show SQL Query to assure that the SQL is being passed to the database (providing you're using a database that supports SQL).

-k

 

[maggielady]

I already have the daterange parameter as a Range Value, and I have that parameter in the report header, supressed. where would I put another parameter to ask the second ? of who do you want the info for?

 

[maggielady]

version 9

 

[Reebo99]

If you put in the record selection formula that SV provided you with, it should ask you for the first and last parameters.

ps. SV congrats on being Top Tipmeister, I said you weren't past it!

Reebo
Scotland (Sunny with a Smile)

 

[dgillz]

Creat a new paramter field, the same way you created the date range parameter, just make it a discreet value and a string data type.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[maggielady]

In the record selection I have the numbertodate formula from yesterday. I just add this other formula to this? So the formula would be:
numbertodate(todate(table.date)) in {?daterange};
({table.date}={?daterange})
and
({table.last}={?mylastparm})
and
({table.first}={?myfirstparm})

 

[Reebo99]

numbertodate(todate(table.date)) in {?daterange}
and
({table.last}={?mylastparm})
and
({table.first}={?myfirstparm})

Reebo
Scotland (Sunny with a Smile)

 

[dgillz]

I think this:
NumberToDate(ToDate(table.date))

Should read:
NumberToDate(ToNumber(table.date))

I seem to remember that your date is a string in a YYYYMMDD format.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[maggielady]

Yes, I did post that incorrectly. I do have it the correct way on the report. Thanks!!

 

[maggielady]

One more problem, I need to be able to ask by date range and/or by person. The way it is now, I have to answer each parameter ?. If I try to run the report just by a date range and not put in a person's last and first name, I get nothing? Thanks again and hopefully I won't bother you guys again today!!

 

[Reebo99]

(if {?mylastparm} <> &quot;&quot; then {table.last}={?mylastparm} else true)
and
(if {?mylastparm} <> &quot;&quot; then {table.first}={?myfirstparm} else true)

Reebo
Scotland (Sunny with a Smile)

 

[Reebo99]

Sorry,

(if {?mylastparm} <> &quot;&quot; then {table.last}={?mylastparm} else true)
and
(if {?myfirstparm} <> &quot;&quot; then {table.first}={?myfirstparm} else true)


Reebo
Scotland (Sunny with a Smile)

 

[maggielady]

one last thing, if I run the report for a date range i need the date range printed below the report title like so:

Report Title
Date range report was run for

 

[dgillz]

You need ot create a formula for the date range, and place it in the page header:

&quot;Report for &quot;&minumim({?DateRangeParm})&&quot; to &quot;&maximum({?DateRangeParm})

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com