Max of a table

[khan82]

Hello,

I have 2 tables that are linked to each other.

Table a = PMN_TENANT__TENANT
Table b = PMN_TENANT__TENANT__LEASE

The first table stores the name of all the tenants in the database. Second database stores the info regarding which tenant is associate with which lease.

When a lease has multiple tenants then crystal displays all of them, how can i chose which one to display? if there are two how do i choose to display only 1? can i group by table a and then do a group select formula to select the last or first one in the range?

Cheers

 

[khan82]

anyone?

 

[pmax9999]

Your request is not clear. Please explain further, using sample data and an example of what you are actually trying to achieve.

Cheers
Pete

 

[IdoMillet]

If you group on lease, and show information only in Group Footer or Group Header (in other words, suppress the detail section) the Group Header would show information for the first tenant in the lease, and the group footer would show info for the last tenant in that lease. Now, just decide how you with to sort them, and which one you wish to show.

Cheers,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[khan82]

well i tried this formula and it worked...it only prints if the certain record # is greater than 0.

if Recordnumber = 2 then Split({PMN_TENANT__TENANT.Name},';')[2] + ' ' + Split ({PMN_TENANT__TENANT.Name}, ';') [1]