Account Related Activities from subgrid to SSRS Report

Hi All,

Many of us know that the activities are stored activity pointer entity  but the actual mapping of an activity and the related entity is stored in activitypointer.

The activities like : Task,Phonecalls , fax. appointmets ... etc are stored as an different entities where the mapping to these activities  with it's recipients and regardingobjetcs are stored in the activityparty tables.

Here my requirement is to get all the activities, which shown in the  left navigation of account related activities.

The Query will be as below :

select 
a.subject, a.activitytypecodename,a.owneridname,a.statecodename, a.prioritycodename, a.actualdurationminutes, a.regardingobjectidname 
from FilteredActivityParty ActivityParty 
inner join 
FilteredActivityPointer A on a.activityid = ActivityParty.activityid 
left join 
FilteredContact C on ActivityParty.partyid= C.ContactId 




by using the above query In BIDS in dataset, apply required parameters for filtering



Thanks
Naveen Dasari