reporting services - CRM 2011 Activities -
i building ssrs report crm 2011 using fetchxml.
i have table show open activities user. want able show account activity related to.
i able if regarding field set account if set contact, opportunity, email... unable find account associated to.
is there way relations fetch more 1 level deep?
any suggestions on how handle this?
when go generate fetchxml, via advanced find, scroll down "related" section; it's in same place picking fields.
so example, select contacts under "look for:" drop-down, under drop-down, select , scroll-down related section , pick accounts.
if there entity not in related list need create relationship. shouldn't done on-the-fly; requires thought since you'll messing database schema.
cheers
Comments
Post a Comment