locked
CRM2013 on Premise Custom Reports Suddenly Stopped Working RRS feed

  • Question

  • I have  problem with Custom Reports suddenly stopped working. I suspect after SP1 was installed but not sure as users cannot remember when they last run reports. Error is

    Report render failure. Error: The Hidden expression for the tablix ‘Table0’ contains an error: Specified argument was out of the range of valid values. (rsRuntimeErrorInExpression)

    If I try to look at the report in ReportServer I get the same error.

    I am the CRM administrator.

    CRM Appool SQL reporter etc all using NETWORK SERVICE

    I hope someone can help

    thanks

    Scott
    • Edited by Rautomead Tuesday, September 30, 2014 3:11 PM
    Tuesday, September 30, 2014 3:11 PM

All replies

  • hi,

    are you able to open the report in reports builder and see what triggered the error?

    looks like an expression inside a tablix is triggering the error.

    some new data might be making your expression invalid. This is the reason it was working for a while and now stopped working.

    regards

    Jithesh

    Tuesday, September 30, 2014 8:56 PM
  • re-reading your error description tells me that your visibility expression in the tablix is throwing error.

    regards

    Jithesh

    Tuesday, September 30, 2014 9:00 PM
  • Thanks for answering.

    If I run the report with a query that returns no data the report works and shows No Data on the form. If a select a query that returns data the report is just blank with the eror above in the event logs.

    It all my custom reports owned by the Network Service that throw up this error. The reports are several years old and been working fine up till now. A few old custom reports owned by the Administrator are ok as are the built in reports which  work ok.

    I suspect it is some permissions issue... i.e. not being able to read the data form the database.

    Scott

    Wednesday, October 1, 2014 9:11 AM
  • Hi Rautomead,

    Please run a trace for this error and share your log here.

    Regards,

    Saad

    Wednesday, October 1, 2014 9:24 AM
  • Hi Scott,

    Can you please try to open the report directly from the SSRS server. there you will get a prompt to enter credentials. Please enter your username and password and see if the reports renders with default filter.

    If it works and if it does not from the CRM UI, then there is some permission error. I strongly suspect the expression used in the tablix. :). Reports are run with currently logged in users credentials.

    Regards,

    Jithesh

    Wednesday, October 1, 2014 11:14 AM
  • Hi Jitash,

    yes logging in reportserver with User and Business GUID results in same error. What could have changed?

    I do have SA with Microsoft but they have screwed up the customersource account and retailer has not given me a support code needed to send a request. SOo trying to fix this whilst waiting for reseller to sort out.

    regards


    Scott

    Wednesday, October 1, 2014 1:40 PM
  • how big is the report? If it is small, please post the xml here. Or please send it to kjithesh @ y7mail.com.

    I am sure it is an expression issue. Or I could ask specific questions 😊

    regards

    Jithesh

    Wednesday, October 1, 2014 7:58 PM
  • It is most of my custom reports, these are years old. A couple which produces bar charts run ok producing the bar chart but return the error when drilling down. I have tried creating new simple reports such as below that will just return all accounts.

    regards

    Scott

     

    <?xml version="1.0" encoding="utf-8"?><Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"><TopMargin>0.5in</TopMargin><BottomMargin>0.5in</BottomMargin><LeftMargin>0.5in</LeftMargin><RightMargin>0.5in</RightMargin><PageHeight>8.25in</PageHeight><PageWidth>11.0in</PageWidth><Width>10.0in</Width><Body><Height>7.25in</Height><Style><TextAlign>Left</TextAlign></Style><ReportItems><Rectangle Name="rectHeader"><Width>10.0in</Width><Height>0.625in</Height><Left>0.0in</Left><Top>0.0in</Top><Style><BackgroundColor>#e3efff</BackgroundColor></Style><ReportItems><Textbox Name="txtHeader"><CanGrow>true</CanGrow><Width>10in</Width><Height>0.375in</Height><Left>0.0in</Left><Top>0.125in</Top><Value>Rautomead - Test 4</Value><Style><FontFamily>Tahoma</FontFamily><FontSize>14pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>11pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Left</TextAlign><VerticalAlign>Middle</VerticalAlign></Style></Textbox></ReportItems></Rectangle><Rectangle Name="rectFilterSummary"><Width>10.0in</Width><Height>0.5in</Height><Left>0.0in</Left><Top>0.625in</Top><Style><BackgroundColor>#e3efff</BackgroundColor></Style><Visibility><Hidden>=IsNothing(Parameters!CRM_FilterText.Value) OrElse (Parameters!CRM_FilterText.Value.Trim().Length = 0)</Hidden></Visibility><ReportItems><Textbox Name="txtFilterSummary"><CanGrow>true</CanGrow><Width>10in</Width><Height>0.25in</Height><Left>0.0in</Left><Top>0.0in</Top><Value>="Filter Summary"</Value><Style><FontFamily>Tahoma</FontFamily><FontSize>12pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>11pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Left</TextAlign></Style></Textbox><Textbox Name="txtFilterSummaryValue"><CanGrow>true</CanGrow><Width>10in</Width><Height>0.25in</Height><Left>0.0in</Left><Top>0.25in</Top><Value>=Parameters!CRM_FilterText.Value</Value><Style><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><Language>=Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureName(Parameters!CRM_UILanguageId.Value)</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>20pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Left</TextAlign></Style><Visibility><Hidden>true</Hidden><ToggleItem>txtFilterSummary</ToggleItem></Visibility></Textbox></ReportItems></Rectangle><Table Name="Table0"><DataSetName>DSMain</DataSetName><DataElementOutput>Output</DataElementOutput><NoRows>="No Data"</NoRows><Left>3.958in</Left><Top>1.25in</Top><Style><TextAlign>Left</TextAlign></Style><TableColumns><TableColumn><Width>1.042in</Width></TableColumn><TableColumn><Width>1.042in</Width><Visibility><Hidden>=(Globals!RenderFormat.Name = "EXCEL" or Globals!RenderFormat.Name = "EXCELOPENXML")</Hidden></Visibility></TableColumn><TableColumn><Width>1.042in</Width><Visibility><Hidden>=(Globals!RenderFormat.Name = "PDF" or Globals!RenderFormat.Name = "IMAGE" or Globals!RenderFormat.Name = "WORD" or Globals!RenderFormat.Name = "WORDOPENXML" or Globals!RenderFormat.IsInteractive)</Hidden></Visibility></TableColumn></TableColumns><Header><RepeatOnNewPage>true</RepeatOnNewPage><TableRows><TableRow><Height>.25in</Height><TableCells><TableCell><ReportItems><Textbox Name="Table0_Header0"><CanGrow>true</CanGrow><Value>="Account Name"</Value><Style><BackgroundColor>#4f81bd</BackgroundColor><Color>#ffffff</Color><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Center</TextAlign></Style><UserSort><SortExpression>=Fields!name.Value</SortExpression></UserSort></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Table0_Header1"><CanGrow>true</CanGrow><Value>="Created On"</Value><Style><BackgroundColor>#4f81bd</BackgroundColor><Color>#ffffff</Color><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Center</TextAlign></Style><DataElementOutput>NoOutput</DataElementOutput><UserSort><SortExpression>=Microsoft.Crm.Reporting.RdlHelper.DateTimeUtility.ConvertUtcToLocalTime(Fields!createdonValue.Value, Parameters!CRM_UserTimeZoneName.Value)</SortExpression></UserSort></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Table0_Header2"><CanGrow>true</CanGrow><Value>="Created On"</Value><Style><BackgroundColor>#4f81bd</BackgroundColor><Color>#ffffff</Color><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Center</TextAlign></Style><UserSort><SortExpression>=Microsoft.Crm.Reporting.RdlHelper.DateTimeUtility.ConvertUtcToLocalTime(Fields!createdonValue.Value, Parameters!CRM_UserTimeZoneName.Value)</SortExpression></UserSort></Textbox></ReportItems></TableCell></TableCells></TableRow></TableRows></Header><Details><TableRows><TableRow><Height>.25in</Height><TableCells><TableCell><ReportItems><Textbox Name="Table0_Details0"><CanGrow>true</CanGrow><Value>=Fields!name.Value</Value><Action><Hyperlink>=IIf(IsNothing(Fields!accountid.Value), Nothing, String.Format(System.Globalization.CultureInfo.InvariantCulture, "{0}?ID={1}&amp;LogicalName={2}", Parameters!CRM_URL.Value, Fields!accountid.Value, "account"))</Hyperlink></Action><Style><Language>=Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureName(Parameters!CRM_UILanguageId.Value)</Language><TextAlign>Left</TextAlign><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop></Style></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Table0_Details1"><CanGrow>true</CanGrow><Value>=Fields!createdon.Value</Value><Action><Hyperlink>=Nothing</Hyperlink></Action><Style><Calendar>=Parameters!CRM_CalendarTypeCode.Value</Calendar><Language>=Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureName(Parameters!CRM_UILanguageId.Value)</Language><TextAlign>Right</TextAlign><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop></Style><DataElementOutput>NoOutput</DataElementOutput></Textbox></ReportItems></TableCell><TableCell><ReportItems><Textbox Name="Table0_Details2"><CanGrow>true</CanGrow><Value>=IIf(IsNothing(Fields!createdon.Value), Nothing, CDate(Microsoft.Crm.Reporting.RdlHelper.DateTimeUtility.ConvertUtcToLocalTime(Fields!createdonValue.Value, Parameters!CRM_UserTimeZoneName.Value)))</Value><Action><Hyperlink>=Nothing</Hyperlink></Action><Style><Calendar>=Parameters!CRM_CalendarTypeCode.Value</Calendar><Language>=Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureName(Parameters!CRM_UILanguageId.Value)</Language><Format>=Parameters!CRM_ShortDatePattern.Value + " " + Parameters!CRM_ShortTimePattern.Value</Format><TextAlign>Right</TextAlign><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop></Style></Textbox></ReportItems></TableCell></TableCells></TableRow></TableRows></Details></Table></ReportItems></Body><PageFooter><ReportItems><Textbox Name="txtExecutionDateTimeLabel"><CanGrow>true</CanGrow><Width>3.125in</Width><Height>0.225in</Height><Left>0.125in</Left><Top>0.075in</Top><Style><Color>#666666</Color><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Left</TextAlign></Style><Value>=CDate(Microsoft.Crm.Reporting.RdlHelper.DateTimeUtility.ConvertUtcToLocalTime(DateTime.UtcNow, Parameters!CRM_UserTimeZoneName.Value)).ToString("g", Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureInfo(Parameters))</Value></Textbox><Textbox Name="txtUserIDLabel"><CanGrow>true</CanGrow><Height>0.225in</Height><Width>3.25in</Width><Left>3.375in</Left><Top>0.075in</Top><Style><Color>#666666</Color><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Center</TextAlign><VerticalAlign>Middle</VerticalAlign></Style><Value>=String.Format(New System.Globalization.CultureInfo(1033), "Prepared by "&amp;chrw(123)&amp;"0"&amp;chrw(125), Parameters!CRM_FullName.Value)</Value></Textbox><Textbox Name="txtPageCount"><CanGrow>true</CanGrow><Width>3.125in</Width><Height>0.225in</Height><Left>6.75in</Left><Top>0.075in</Top><Style><Color>#666666</Color><FontFamily>Tahoma</FontFamily><FontSize>8pt</FontSize><FontWeight>700</FontWeight><Language>en-US</Language><PaddingBottom>2pt</PaddingBottom><PaddingLeft>2pt</PaddingLeft><PaddingRight>2pt</PaddingRight><PaddingTop>2pt</PaddingTop><TextAlign>Right</TextAlign><VerticalAlign>Middle</VerticalAlign></Style><Value>=String.Format(New System.Globalization.CultureInfo(1033), "Page "&amp;chrw(123)&amp;"0"&amp;chrw(125)&amp;" of "&amp;chrw(123)&amp;"1"&amp;chrw(125), Format(Globals!PageNumber, "#,##0"), Format(Globals!TotalPages, "#,##0"))</Value></Textbox></ReportItems><PrintOnLastPage>true</PrintOnLastPage><PrintOnFirstPage>true</PrintOnFirstPage><Style><BackgroundColor>#e3efff</BackgroundColor></Style><Height>0.375in</Height></PageFooter><ReportParameters><ReportParameter Name="CRM_FullName"><DataType>String</DataType><Nullable>true</Nullable><AllowBlank>true</AllowBlank><Prompt>CRM_FullName</Prompt><Hidden>true</Hidden><DefaultValue><Values><Value>Tocher, Scott</Value></Values></DefaultValue></ReportParameter><ReportParameter Name="CRM_UserTimeZoneName"><DataType>String</DataType><DefaultValue><Values><Value>GMT Standard Time</Value></Values></DefaultValue><AllowBlank>true</AllowBlank><Prompt>CRM_UserTimeZoneName</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_UILanguageId"><DataType>Integer</DataType><DefaultValue><Values><Value>2057</Value></Values></DefaultValue><Prompt>CRM_UILanguageId</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_CurrencyDecimalPrecision"><DataType>Integer</DataType><DefaultValue><Values><Value>2</Value></Values></DefaultValue><Prompt>CRM_CurrencyDecimalPrecision</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_CurrencySymbol"><DataType>String</DataType><DefaultValue><Values><Value></Value></Values></DefaultValue><AllowBlank>true</AllowBlank><Prompt>CRM_CurrencySymbol</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_CurrencyPositivePattern"><DataType>Integer</DataType><DefaultValue><Values><Value>0</Value></Values></DefaultValue><Prompt>CRM_CurrencyPositivePattern</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_CurrencyNegativePattern"><DataType>Integer</DataType><DefaultValue><Values><Value>1</Value></Values></DefaultValue><Prompt>CRM_CurrencyNegativePattern</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_NumberDecimalDigits"><DataType>Integer</DataType><DefaultValue><Values><Value>2</Value></Values></DefaultValue><Prompt>CRM_NumberDecimalDigits</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_NumberDecimalSeparator"><DataType>String</DataType><DefaultValue><Values><Value>.</Value></Values></DefaultValue><Prompt>CRM_NumberDecimalSeparator</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_NumberNegativePattern"><DataType>Integer</DataType><DefaultValue><Values><Value>1</Value></Values></DefaultValue><Prompt>CRM_NumberNegativePattern</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_NumberGroupSizes"><DataType>String</DataType><DefaultValue><Values><Value>3</Value></Values></DefaultValue><Prompt>CRM_NumberGroupSizes</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_NumberGroupSeparator"><DataType>String</DataType><DefaultValue><Values><Value>,</Value></Values></DefaultValue><Prompt>CRM_NumberGroupSeparator</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_CalendarTypeCode"><DataType>Integer</DataType><DefaultValue><Values><Value>0</Value></Values></DefaultValue><Prompt>CRM_CalendarTypeCode</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_DateSeparator"><DataType>String</DataType><DefaultValue><Values><Value>/</Value></Values></DefaultValue><Prompt>CRM_DateSeparator</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_TimeSeparator"><DataType>String</DataType><DefaultValue><Values><Value>:</Value></Values></DefaultValue><Prompt>CRM_TimeSeparator</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_AMDesignator"><DataType>String</DataType><Nullable>true</Nullable><AllowBlank>true</AllowBlank><DefaultValue><Values><Value>AM</Value></Values></DefaultValue><Prompt>CRM_AMDesignator</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_PMDesignator"><DataType>String</DataType><Nullable>true</Nullable><AllowBlank>true</AllowBlank><DefaultValue><Values><Value>PM</Value></Values></DefaultValue><Prompt>CRM_PMDesignator</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_ShortDatePattern"><DataType>String</DataType><DefaultValue><Values><Value>dd/MM/yyyy</Value></Values></DefaultValue><Prompt>CRM_ShortDatePattern</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_LongDatePattern"><DataType>String</DataType><DefaultValue><Values><Value>dd MMMM yyyy</Value></Values></DefaultValue><Prompt>CRM_LongDatePattern</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_ShortTimePattern"><DataType>String</DataType><DefaultValue><Values><Value>HH:mm</Value></Values></DefaultValue><Prompt>CRM_ShortTimePattern</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_MonthDayPattern"><DataType>String</DataType><DefaultValue><Values><Value>dd MMMM</Value></Values></DefaultValue><Prompt>CRM_MonthDayPattern</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_YearStartWeekCode"><DataType>Integer</DataType><DefaultValue><Values><Value>0</Value></Values></DefaultValue><Prompt>CRM_YearStartWeekCode</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_WeekStartDayCode"><DataType>Integer</DataType><DefaultValue><Values><Value>0</Value></Values></DefaultValue><Prompt>CRM_WeekStartDayCode</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_FilterText"><DataType>String</DataType><Nullable>true</Nullable><AllowBlank>true</AllowBlank><Prompt>CRM_FilterText</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_FilteredAccount"><DataType>String</DataType><DefaultValue><Values><Value>&lt;fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"&gt;&lt;entity name="account"&gt;&lt;all-attributes /&gt;&lt;filter type="and"&gt;&lt;condition attribute="createdon" operator="not-null" /&gt;&lt;/filter&gt;&lt;/entity&gt;&lt;/fetch&gt;</Value></Values></DefaultValue><Prompt>CRM_FilteredAccount</Prompt><Hidden>true</Hidden></ReportParameter><ReportParameter Name="CRM_URL"><DataType>String</DataType><Nullable>true</Nullable><AllowBlank>true</AllowBlank><Prompt>CRM_URL</Prompt><Hidden>true</Hidden></ReportParameter></ReportParameters><DataSources><DataSource Name="CRM"><ConnectionProperties><DataProvider>MSCRMFETCH</DataProvider><ConnectString>http://hpcrm:5555/;RautomeadLimited</ConnectString><IntegratedSecurity>true</IntegratedSecurity></ConnectionProperties></DataSource></DataSources><DataSets><DataSet Name="DSMain"><Query><CommandText>&lt;fetch distinct="false" no-lock="false" mapping="logical"&gt;&lt;entity name="account" enableprefiltering="1" prefilterparametername="CRM_FilteredAccount"&gt;&lt;attribute name="name" alias="name" /&gt;&lt;attribute name="createdon" alias="createdon" /&gt;&lt;attribute name="accountid" /&gt;&lt;/entity&gt;&lt;/fetch&gt;</CommandText><DataSourceName>CRM</DataSourceName><QueryParameters><QueryParameter Name="CRM_FilteredAccount"><Value>=Parameters!CRM_FilteredAccount.Value</Value></QueryParameter></QueryParameters></Query><Fields><Field Name="name"><DataField>name</DataField></Field><Field Name="createdon"><DataField>createdon</DataField></Field><Field Name="createdonValue"><DataField>createdonValue</DataField></Field><Field Name="accountid"><DataField>accountid</DataField></Field></Fields></DataSet></DataSets><CodeModules><CodeModule>Microsoft.Crm.Reporting.RdlHelper, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</CodeModule></CodeModules><CustomProperties><CustomProperty><Name>Custom</Name><Value>&lt;MSCRM xmlns="mscrm"&gt;&amp;lt;ReportFilter&amp;gt;&amp;lt;ReportEntity paramname="CRM_FilteredAccount" donotconvert="1"&amp;gt;&amp;lt;fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"&amp;gt;&amp;lt;entity name="account"&amp;gt;&amp;lt;all-attributes /&amp;gt;&amp;lt;filter type="and"&amp;gt;&amp;lt;condition attribute="createdon" operator="not-null" /&amp;gt;&amp;lt;/filter&amp;gt;&amp;lt;/entity&amp;gt;&amp;lt;/fetch&amp;gt;&amp;lt;/ReportEntity&amp;gt;&amp;lt;/ReportFilter&amp;gt;&lt;/MSCRM&gt;</Value></CustomProperty></CustomProperties></Report>

    Thursday, October 2, 2014 11:11 AM
  • Hi Scott,

     What is the SQL Server/SSRS version?the first link describes about excelopenxml when the version (Other Versions Link on top) is changed from SQL Server 2008 R2 to SQL Server 2012/2014. Can you please remove the hidden expression from the tablecolumns of "table0"

    <TableColumns>
    <TableColumn>
    <Width>1.042in</Width>
    </TableColumn>
    <TableColumn>
    <Width>1.042in</Width>
    <Visibility>
    <Hidden>=(Globals!RenderFormat.Name = "EXCEL" or Globals!RenderFormat.Name = "EXCELOPENXML")</Hidden>
    </Visibility>
    </TableColumn>
    <TableColumn>
    <Width>1.042in</Width>
    <Visibility>
    <Hidden>=(Globals!RenderFormat.Name = "PDF" or Globals!RenderFormat.Name = "IMAGE" or Globals!RenderFormat.Name = "WORD" or Globals!RenderFormat.Name = "WORDOPENXML" or Globals!RenderFormat.IsInteractive)</Hidden>
    </Visibility>
    </TableColumn>
    </TableColumns>

    http://msdn.microsoft.com/en-us/library/dd255216%28v=sql.105%29.aspx

    http://stackoverflow.com/questions/20382146/ssrs-2008-r2-globalsrenderformat-name-excelopenxml

    Let me know how it goes.

    Regards,

    Jithesh


    Thursday, October 2, 2014 12:15 PM
  • Hi Jitash,

    I am using SQL2008 version 10.0.4067.0

    I cannot edit these reports they are created by Microsoft CRM. The only way I could get the XML was to export the report and open with Visual Studio but I don't know enough to run it in Visual Studio.

    thanks

    Scott

    Thursday, October 2, 2014 12:45 PM
  • Hi Scott,

    Not a problem.

    1. Download the report.

    2. Edit the report in notepad.

    3. delete the node

    <Visibility>
    <Hidden>=(Globals!RenderFormat.Name = "EXCEL" or Globals!RenderFormat.Name = "EXCELOPENXML")</Hidden>
    </Visibility>

    4. And delete the node

    <Visibility>
    <Hidden>=(Globals!RenderFormat.Name = "PDF" or Globals!RenderFormat.Name = "IMAGE" or Globals!RenderFormat.Name = "WORD" or Globals!RenderFormat.Name = "WORDOPENXML" or Globals!RenderFormat.IsInteractive)</Hidden>
    </Visibility>

    5. Save your rdl file. Now Open your CRM, go to reports link.

    6. Click on Create New report link.

    7. Change the option to upload an existing file.

    8. upload the Saved RDL file from step 5.

    9. run the report and see if the error is still there? If this fixes your issue, please let me know.

    Cheers,

    Jithesh.K

    Thursday, October 2, 2014 1:08 PM
  • Hi Jitash,

    Been doing more tests. If I take the created on date firld out of the rprot it runs on. Adding any other typoe of field is ok. As soon as I add a date field the error occurs.

    Scott

    Thursday, October 2, 2014 1:09 PM
  • Hi Scott,

    Thank you for looking up Claudio's post. I will give this issue a rest now. Please do not forget to post back the finding, it may help some other person down the line.

    Good Luck,

    Jithesh

    Thursday, October 2, 2014 1:17 PM
  • The error is

    Report render failure. Error: The Hidden expression for the tablix ‘Table0’ contains an error: Specified argument was out of the range of valid values. (rsRuntimeErrorInExpression)

    so does this mean the date field is out of range of valid values?

    Thursday, October 2, 2014 2:16 PM
  • Hi Scott,

     Please see that SQL Server 2008 SP2 is not compatible with CRM 2013. You have to either install SP3 or upgrade to SQL server 2008 R2 with correct SP.

    http://support2.microsoft.com/kb/3005167

    Unfortunatly, I will not be able to replicate this situation since we upgraded all our SQL Server to 2008 R2 or 2012.

    Since your Sql Server version is listed Not compatible, Raising a call with MS does not help your case.

    It is worth trying to remove the following two conditions from the report and see if helps.

    or Globals!RenderFormat.Name = "EXCELOPENXML"
    or Globals!RenderFormat.Name = "WORDOPENXML"

    I still do not think date condition is the real issue. if the above does not work, you could advise your users that there is a know issue with the date condition and advise them not to use it until the SQL Server is patched?

    Regards,

    Jithesh

    Thursday, October 2, 2014 11:44 PM
  • Hi Jitash,

    I too had checked the CRM requirements and noted the requirement for SP3 so I downloaded and installed it and  now no reports run. The reportserver is running but report manager will not start with the error

    Failed to initialize the AppDomain:ReportManager_MSSQLSERVER_0

    Exception: System.Configuration.ConfigurationErrorsException

    Message: '”' is an unexpected token. The expected token is '"' or '''. Line 19, position 34. (D:\SQL Databases\MSRS10.MSSQLSERVER\Reporting Services\ReportManager\web.config line 19)

    StackTrace:    at System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags)
       at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
       at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
       at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)
       at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironmentAndReportErrors(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)

    InnerException: System.Xml.XmlException

    Message: '”' is an unexpected token. The expected token is '"' or '''. Line 19, position 34.

    StackTrace:    at System.Xml.XmlTextReaderImpl.Throw(Exception e)
       at System.Xml.XmlTextReaderImpl.ParseAttributes()
       at System.Xml.XmlTextReaderImpl.ParseElement()
       at System.Xml.XmlTextReaderImpl.ParseElementContent()
       at System.Configuration.XmlUtil.CopySection()
       at System.Configuration.BaseConfigurationRecord.ScanSectionsRecursive(XmlUtil xmlUtil, String parentConfigKey, Boolean inLocation, String locationSubPath, OverrideModeSetting overrideMode, Boolean skipInChildApps)
       at System.Configuration.BaseConfigurationRecord.ScanSectionsRecursive(XmlUtil xmlUtil, String parentConfigKey, Boolean inLocation, String locationSubPath, OverrideModeSetting overrideMode, Boolean skipInChildApps)
       at System.Configuration.BaseConfigurationRecord.ScanSections(XmlUtil xmlUtil)
       at System.Configuration.BaseConfigurationRecord.InitConfigFromFile()

    my web.config is

    <?xml version="1.0" encoding="utf-8"?>
    <configuration>
      <system.web>
        <pages validateRequest="false" />
        <authentication mode="Windows" />
        <identity impersonate="true" />
        <compilation defaultLanguage="c#" debug="false" tempDirectory="D:\SQL Databases\MSRS10.MSSQLSERVER\Reporting Services\RSTempFiles\">
          <assemblies>
            <clear />
            <add assembly="ReportingServicesWebServer" />
          </assemblies>
        </compilation>
        <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
        <sessionState mode="Off" />
        <httpHandlers>
          <add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
          <add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
        </httpHandlers>
        <httpModules>
          <clear />
          <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />
          <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
          <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />
          <add name="PassportAuthentication" type="System.Web.Security.PassportAuthenticationModule" />
          <add name="RoleManager" type="System.Web.Security.RoleManagerModule" />
          <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />
          <add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule" />
          <add name="AnonymousIdentification" type="System.Web.Security.AnonymousIdentificationModule" />
          <add name="Profile" type="System.Web.Profile.ProfileModule" />
          <add name="ErrorHandlerModule" type="System.Web.Mobile.ErrorHandlerModule, System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
        </httpModules>
        <globalization requestEncoding="utf-8" responseEncoding="utf-8" />
        <httpRuntime executionTimeout="9000" />
        <securityPolicy>
          <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
        </securityPolicy>
        <trust level="RosettaSrv" originUrl="" />
      </system.web>
      <runtime>
        <alwaysFlowImpersonationPolicy enabled="true" />
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
          <dependentAssembly>
            <assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral" />
            <bindingRedirect oldVersion="8.0.242.0" newVersion="10.0.0.0" />
            <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
          </dependentAssembly>
          <dependentAssembly>
            <assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" publicKeyToken="89845dcd8080cc91" culture="neutral" />
            <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
          </dependentAssembly>
          <dependentAssembly>
            <assemblyIdentity name="Microsoft.Crm.Reporting.RdlHelper" publicKeyToken="31bf3856ad364e35" culture="neutral" />
            <bindingRedirect oldVersion="5.0.0.0" newVersion="6.0.0.0" />
          </dependentAssembly>
        </assemblyBinding>
      </runtime>
    </configuration>

    Friday, October 3, 2014 9:20 AM
  • Hi Scott,

     I am no longer sure if we are moving in the right direction anymore. Is your SQL Server installation or the OS 32 bit by any chance? My config file on SQL server 2008 R2 looks a bit different.  I am posting my config file below. I hope you are trying this on a test server and not on a live server.

    <?xml version="1.0" encoding="utf-8"?>
    <configuration>
      <system.web>
        <pages validateRequest="false">
          <controls>
            <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
          </controls>
        </pages>
        <authentication mode="Windows" />
        <identity impersonate="true" />
        <compilation defaultLanguage="c#" debug="false" tempDirectory="D:\MSSQL$CRM_DEV_07\MSRS10_50.CRM_DEV_07\Reporting Services\RSTempFiles\">
          <assemblies>
            <clear />
            <add assembly="ReportingServicesWebServer" />
            <add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
            <add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
          </assemblies>
        </compilation>
        <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
        <sessionState mode="Off" />
        <httpHandlers>
          <add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
          <add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
          <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" />
        </httpHandlers>
        <httpModules>
          <clear />
          <add name="OutputCache" type="System.Web.Caching.OutputCacheModule" />
          <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" />
          <add name="FormsAuthentication" type="System.Web.Security.FormsAuthenticationModule" />
          <add name="PassportAuthentication" type="System.Web.Security.PassportAuthenticationModule" />
          <add name="RoleManager" type="System.Web.Security.RoleManagerModule" />
          <add name="UrlAuthorization" type="System.Web.Security.UrlAuthorizationModule" />
          <add name="FileAuthorization" type="System.Web.Security.FileAuthorizationModule" />
          <add name="AnonymousIdentification" type="System.Web.Security.AnonymousIdentificationModule" />
          <add name="Profile" type="System.Web.Profile.ProfileModule" />
          <add name="ErrorHandlerModule" type="System.Web.Mobile.ErrorHandlerModule, System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
        </httpModules>
        <globalization requestEncoding="utf-8" responseEncoding="utf-8" />
        <httpRuntime executionTimeout="9000" />
        <securityPolicy>
          <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
        </securityPolicy>
        <trust level="RosettaSrv" originUrl="" />
        <webServices>
          <soapExtensionTypes>
            <add type="Microsoft.ReportingServices.WebServer.RsSoapExtension, ReportingServicesWebServer" priority="1" group="1" />
          </soapExtensionTypes>
          <soapExtensionReflectorTypes>
            <add type="Microsoft.ReportingServices.WebServer.RsSoapExtensionReflector, ReportingServicesWebServer" />
          </soapExtensionReflectorTypes>
        </webServices>
      </system.web>
      <runtime>
        <alwaysFlowImpersonationPolicy enabled="true" />
        <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
          <dependentAssembly>
            <assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral" />
            <bindingRedirect oldVersion="8.0.242.0" newVersion="10.0.0.0" />
            <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
          </dependentAssembly>
          <dependentAssembly>
            <assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" publicKeyToken="89845dcd8080cc91" culture="neutral" />
            <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0" />
          </dependentAssembly>
          <dependentAssembly>
            <assemblyIdentity name="msmgdsrv" publicKeyToken="89845dcd8080cc91" />
            <codeBase version="9.0.0.0" href="C:\Program Files\Microsoft Analysis Services\AS OLEDB\10\msmgdsrv.dll" />
          </dependentAssembly>
        </assemblyBinding>
      </runtime>
    </configuration>

    Regards,

    Jithesh

    Friday, October 3, 2014 11:23 AM
  • Jithesh,

    Sorry I was look at the reportserver web.config not the report manager web.config. I found the problem and report manager now running.

    CRM reports still have the same error despite upgrading to SQL2008 SP3. I think this is going to have to wait until I have proper access to customersource and pass this to the CRM team.

    thanks

    Scott

    Friday, October 3, 2014 1:14 PM
  • Scott,

    Did you ever find a resolution for this? We are experiencing the same problem. Reports created with custom report wizard work as long as a date field is not included in the report. Once you add in a date field, the report is not rendered. CRM trace file shows:

    The Hidden expression for the tablix ‘Table0’ contains an error: Specified argument was out of the range of valid values. (rsRuntimeErrorInExpression)

    We are running. CRM 2013 SP1 Update Rollup 1 and SQL Server 2008 64bit SP4 (problems occurs with SP3 as well)

    Thanks,
    Brill


    Monday, December 1, 2014 8:08 PM
  • Hi Brill,

    Sorry not yet I still have not been able to contact Microsoft due to some issue with my SA. As usual My MS vendor and Microsoft are taking a long time to resolve it. I am sure this is a MS screw-up in SP1 and others must be affected. I'm waiting for UR2 for SP! to see if this fixes it. If not then probably have to wait for CRM2015.

    Scott

    Tuesday, December 2, 2014 10:05 AM
  • I have updated SL2008 to SP3 and CRM2013 is now at SP3 rollup m3 and the problems persists
    Friday, February 13, 2015 9:05 AM