Avatar of ACUIWebDeveloper
ACUIWebDeveloper
 asked on

Dynamics CRM FetchXML Report - Stored Procedure

I am converting an SRSS report over to FetchXML and I have hit a snag.  One of my datasets is as follows

          SELECT     DateFormat, TimeFormat, NumberLanguageCode, CalendarType, NumberFormat_0_Precision, NumberFormat_1_Precision, NumberFormat_2_Precision,
          NumberFormat_3_Precision, NumberFormat_4_Precision, NumberFormat_5_Precision, CurrencyFormat_0_Precision, CurrencyFormat_1_Precision,
          CurrencyFormat_2_Precision, CurrencyFormat_3_Precision, CurrencyFormat_4_Precision, CurrencyFormat_5_Precision
          FROM         dbo.fn_GetFormatStrings() AS fn_GetFormatStrings_1

Open in new window


So my question is: Is there a way to call a SQL function via FetchXML?

Thanks,
Microsoft DynamicsMicrosoft SQL Server 2008SSRS

Avatar of undefined
Last Comment
Rikin Shah

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rikin Shah

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61