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)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