web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

ActualString not appearing in Reports

(0) ShareShare
ReportReport
Posted on by 245

Hey guys,

I was trying to create a Report using the Report Wizard wherein I was trying to put the Actual field of Goals but it doesn't seem to appear on the choices when I add it to the column. Is there a reason why it doesn't appear on reports. I also noticed that the Target field also don't appear on the Reports. Is this normal or is there any reason why they don't appear on Reports? I'm planning to use a custom field with Business Rules to get what I need.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    21 on at
    RE: ActualString not appearing in Reports

    There are 3 Target fields - Target (Integer), Target (Decimal) and Target (Money) - you need to choose one of these.

    If you want to show a single field then you could output all 3 and then edit the rdl to show the first non-null value using an IIF expression.

    Once you have created the report using the wizard with 3 separate columns you can then download the rdl and edit it in Visual Studio - see blogs.msdn.com/.../how-to-creating-custom-report-with-microsoft-dynamics-crm-2011-bids-fetch-extension.aspx

    Hope this helps,

    Scott

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans