No announcements
Found 91721 threads
-
0 VotesPrefiltering in Fetch XML SSRS Report
About pre-filtering it should be in your Fetch XML for specific conditions.Answered | 5 Replies | 23303 Views | Created by Anthonie de Klerk - Wednesday, April 17, 2013 7:31 AM | Last reply by Anthonie de Klerk - Wednesday, April 17, 2013 7:58 AM
-
0 Votes
Help getting Fetch XML for report
With that said, you would be better off handling the conditions in the application or report that the data is going to.Answered | 2 Replies | 1410 Views | Created by Pete Newman - Thursday, May 30, 2013 12:27 PM | Last reply by Pete Newman - Thursday, May 30, 2013 4:17 PM -
2 Votes
FETCH XML Condition for linked entity
To have it return the same results as the SQL query, include the % wild card in the same places as the SQL query, like this: <fetch mapping='logical'> ...Answered | 6 Replies | 5802 Views | Created by Ramu Devarasetty - Thursday, February 9, 2012 10:36 PM | Last reply by Ramu Devarasetty - Friday, February 10, 2012 2:43 PM -
0 Votes
Date value condition in the fetch expression.
One need to build two datasets each with a different query and the columns needs to be merged in the report.Answered | 4 Replies | 4065 Views | Created by jaipal vallabhaneni - Tuesday, December 20, 2011 10:53 AM | Last reply by jaipal vallabhaneni - Tuesday, December 27, 2011 4:50 AM -
0 Votes
CRM 2011 Fetch-Xml based Reports
I was able to use the link-entity in the fetchxml expression to pull related contacts onto the account report.Answered | 6 Replies | 4749 Views | Created by Mitchell2012 - Tuesday, August 21, 2012 1:50 PM | Last reply by itara - Thursday, September 20, 2012 11:19 AM -
0 Votes
fetch XML
Are you creating an SSRS report or using the FetchXML query for some other custom application?Answered | 5 Replies | 2739 Views | Created by Pete Newman - Friday, September 6, 2013 11:02 AM | Last reply by Roshan Mehta - Monday, September 9, 2013 10:18 AM -
0 Votes
Fetch XML : Appointment count against individual opportunity
Can you please also provide me the FetchXml to get the appointments count against distinct Opportunity Product...Answered | 3 Replies | 3316 Views | Created by Ravishankar Polepalli - Monday, November 28, 2011 5:42 PM | Last reply by Ravishankar Polepalli - Tuesday, November 29, 2011 7:42 AM -
0 Votes
expression with if and count condition in fetch xml ssrs reports
http://crmdm.blogspot.co.uk/2013/09/custom-fetchxml-based-report-in-crm.html Hope this helps..Unanswered | 3 Replies | 3296 Views | Created by sarita shaw - Sunday, April 6, 2014 11:27 AM | Last reply by Mayank Pujara - Sunday, April 13, 2014 1:59 PM -
2 Votes
SSRS reporting in CRM 2011
CRM 2011 reporting uses FetchXml (in case of on-premise and online) or Filtered Views (in case of on-premise oinly) and you can join in fetchxml and as well as FIltered Views, Fetch ...Answered | 3 Replies | 6603 Views | Created by SSQLL - Sunday, July 3, 2011 1:21 PM | Last reply by Jehanzeb.Javeed - Sunday, July 3, 2011 6:03 PM -
3 Votes
CRM 2011 Fetch XML Reports - UK Format
You may use this approach by converting the date time into UTC and then getting a string representation of it that you can pass in the fetch xml.Answered | 17 Replies | 16914 Views | Created by Pete.CRM - Tuesday, February 22, 2011 10:31 AM | Last reply by kc_narra - Thursday, October 17, 2013 11:06 AM -
0 Votes
How to create a calculated column in Fetch XML
In SSRS you can add calculated columns to your fetch xml by rightclick to your dataset, Fields, Add, Calculated Field.Answered | 3 Replies | 11152 Views | Created by Guostong - Monday, October 17, 2011 3:52 AM | Last reply by itara - Friday, October 12, 2012 10:21 AM -
0 Votes
Creating reports same as SSRS
Try these ...Answered | 6 Replies | 2544 Views | Created by JMcCon - Wednesday, February 15, 2012 12:00 PM | Last reply by Faisal Fiaz - Wednesday, February 15, 2012 1:32 PM -
0 Votes
JavaScript Fetch XML to get the number of record count based upon the condition in MS CRM 4.0 ??
xml = "Answered | 4 Replies | 8779 Views | Created by Srikanth_MSCRM - Thursday, March 17, 2011 5:17 PM | Last reply by Jamie Miley - Friday, May 4, 2012 1:50 PM -
1 Votes
Requirements to create Fetch XML report in CRM 2013
report authoring extension to write custom fetch xml report.Answered | 2 Replies | 1487 Views | Created by Simran08 - Friday, May 9, 2014 8:26 AM | Last reply by Simran08 - Friday, May 9, 2014 8:52 AM -
1 Votes
Fetch XML Reports in Visual Studio 2012
Hi, I still don't know about any possibility in Visual Studio 2012, but since March 27th 2013, there is a new download for the Microsoft Dynamics CRM 2011 Report ...Answered | 5 Replies | 9360 Views | Created by itara - Wednesday, March 27, 2013 12:16 PM | Last reply by Jules Davies - Monday, November 18, 2013 11:28 AM -
2 Votes
Crm 2011 online fetch xml
Personally I think the query expression is much easier to read.Answered | 3 Replies | 7354 Views | Created by VarunKumar17 - Tuesday, May 24, 2011 11:23 AM | Last reply by Laughing John - Tuesday, May 24, 2011 4:26 PM -
0 Votes
Fetch Xml query to sql statement
Stop the profiler and look through the entries to find your fetch statement executed as SQL Statement.Answered | 11 Replies | 9999 Views | Created by VarunKumar17 - Thursday, August 19, 2010 12:54 PM | Last reply by Amarsen Vangoor - Sunday, November 15, 2015 9:15 AM -
2 Votes
in operator in fetch xml
Hi, you could try something like this (haven't tested it though): <fetch mapping='logical'> <entity name='serviceappointment'> ...Answered | 3 Replies | 4225 Views | Created by anwar_addi - Tuesday, November 6, 2012 12:57 PM | Last reply by Pavlos Panagiotidis - Tuesday, November 6, 2012 1:06 PM -
0 Votes
Fetching several entities for a report
Fetch based reports even support drill down and sub report functionality as like as existing SQL based reports.Answered | 10 Replies | 6228 Views | Created by Manuel Altermatt - Tuesday, May 10, 2011 6:33 PM | Last reply by Manuel Altermatt - Monday, May 23, 2011 10:07 PM -
1 Votes
Is there any tool to build Fetch XML and Query expression?
Hi, I used Stunware tool to create Fetch XML queries in CRM 4.0?Answered | 4 Replies | 2931 Views | Created by Yogesh Mulay - MCTS - Thursday, January 17, 2013 1:42 PM | Last reply by Yogesh Mulay - MCTS - Thursday, January 17, 2013 2:12 PM - Items 1 to 20 of 91721 Next ›
No announcements
