Hello. Maybe someone can help me achieve what I am trying to do? I have searched but failed to find an answer anywhere.

I have a report that has two datasources linked via Timestamp (Date field={TimeStamp}). The timestamp refers to sms messages i.e. when they were sent. I have many occurences of sms messages sent by different customers (mobile numbers). But the problem is, one mobile has many sms messages, sent at different dates.

What I would like to do is to have a formula that selects only the first record, ie the earliest date when an sms message was sent for any particualr mobile number. So the total count for one mobile is 1, rather than twenty.

I truly appreciate any help. Thanks.

try with making sql view or sp wich will give u data in just the way u want. like -- select max(timestamp), phonenumber from messages group by phonenumber