how to select data from date range?

[khan82]

I have a report that shows the rent that is effective as of a given date. Now i want to show the charges that will be effective in a give range by the operator.

My current record selection formula is:

{PMN_TENANT__TENANT_ADDRESS.Tenant_Address_Type} = "Mailing" and
{PML_LEASE__LEASE_RECURRING_CHG_LOG.Effective_Date} <= {?Effective Date} and
{PMP_PROPERTY__PROPERTY_ADDRESS.Prop_Addr_Type} = "Street" and
{PML_LEASE__LEASE.Status} = "Current" and
if {?Lease ID} <> "" then {PML_LEASE__LEASE.Lease}={?Lease ID}
else True

Group selection formula is:

{PML_LEASE__LEASE_RECURRING_CHG_LOG.Effective_Date}=maximum({PML_LEASE__LEASE_RECURRING_CHG_LOG.Effective_Date},{PML_LEASE__LEASE_RECURRING_CHG_LOG.Charge_Type})

does any one know the name of the function i might have to use instead of maximum?

Additionally i want to be able to reprint the charges in multiple section for a given date. i.e lets say the rent period is Aug-Dec, so one section will show all charges that fall in that period but if there is an increase in October then it will show the increase amount in the section below along with the other charges for that period as well. Can this be done?

Thanks

 

[khan82]

any one?

 

[pmax9999]

Maybe some sample data and the required result would assist. At this stage the problem is not clear (at least, not to me).

Cheers
Pete.

 

[khan82]

well i have figured out a way of doing it. I have created two sub-reports one for max values and one for min values but now i can't seem to find out how to suppress one if they are both identical.

 

[pmax9999]

That's what I explained in the other thread.

But the sub report may not be necessary - just can't be sure based on the original post.

Cheers
Pete