LastFullMonth function

[lana123]

Hi,people
I have to show in my report(Crystal 9.2)only the records that were created in the last day of the previous month.
I'm using for my parameter
{?OpenDate}=maximum(LastFullMonth) formula
but it doesn't show up in the Database "Show SQL Query" window.
I'll appreciate any suggestions.

Thanks,

Lana

 

[rhinok]

Hi Lana,

Why are you using a parameter if you're going to hard code a value to it in the record selection criteria? The purpose of a parameter is to allow choice. Also, this code assigns a value to the parameter, but it doesn't actually affect record selection criteria. Generally, a parameter would be used as follows:

{table.datefield} = {?DateParameter}

. This allows the user to assign a value to {?DateParameter}, which will then be passed to the database as a filter for the {table.datefield} field.

Is this snippet of code part of a larger statement? If so, would you please post your entire record selection statement? This will help us to better identify and address your issue.


~Kurt

 

[bdreed35]

As Kurt says, if you want to allow the user to pick the day to run the report, use his sample above.

If you want the report to always run on the last day of th previous month, then modify your selection criteria to this:

{table.datefield} = maximum(lastfullmonth)

If you wanted the flexibility of allowing for them to select a particular day, or the last day of the previous month, you could do that as well.
Create a default value for the date parameter, which is well out of the normal date range. Perhaps something like 1/1/1900.
In your selection criteria, add the following lines instead of what you used above:

(
if {?Date_Parm} = CDate(1900,1,1) then
    {table.datefield} = maximum(lastfullmonth)
else if {?Date_Parm} <> CDate(1900,1,1) then
    {table.datefield} = {?Date_Parm} 
)

If the user chooses 1/1/1900 in the parameter, the selection will be based upon the last day of the previous, otherwise it will use the date provided in the parameter.

~Brian