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 :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM report crash when ...
Microsoft Dynamics CRM (Archived)

CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

(1) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have developed a SSRS report with a multivalued parameter. Then I uploaded that to CRM 2011 and the Report functionality works really well. 

But in IE browser when selecting the multi values from the multivalued parameter if the down arrow button is clicked (down arrow at the left on CertYear Parameter) then the report throws a error.

crash1.PNG

This can happen with my client and I need to fix this error as my client's primary browser is IE.

Any suggestion would be great.

Thanks

Mathee

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    Hi,

    Yes, I updated to Roll-back 18 directly and the problem was fixed there.

    Good to know there are others facing this issue.

    Thanks Bruno for the help.

    Best Regards

  • Dynamics Warrior Profile Picture
    Dynamics Warrior 65 on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    Hi matheesha,

    Were you able to solve this issue by applying Update Rollup 16 ?

    Thanks

  • Community Member Profile Picture
    Community Member on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    This only happens for CRM web client on IE browser. May be I am getting this error as a combination of incompatibility of IE, CRM 2011 and the SSRS. I used IE 11 so far and when I tried this with IE 10 I got the exact script error mentioned in the rollup fix list.

    Thank you very much for your help.

    So with this only option available for me is to update the CRM to rollup 16, is that ?

    Thanks

  • Verified answer
    Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    It doesn't clearly say when this problem was introduced but on the rollup 16 manifest it does mentioned 16 has a fix for it. if you read the other items around the 16 fix list, it mentions many fixes for problem introduced by rollup 12. Another point you can check is running the report from the [host]\reports url. if it works , that will be one more evidence the issue is within the CRM client side passing something wrong to the SSRS. maybe fiddler may be able to capture what is being passed

  • Community Member Profile Picture
    Community Member on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    I don't get this error when I run the report with SQL Server. No matter how any times I click on the multivalued parameter down arrow button I am not getting a error.

    But in CRM when I click on the down arrow of multivalued parameter while it is expanded the reports starts generating and gives the error. Ideally it should not start generating until I click on "View Report" button.  Can you point out this was a known issue for rollup 12.  

    Any suggestion would be great.

    Thanks

  • Verified answer
    Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    it is looking like a problem that get fixed by rollup upgrade. unless you have some conversion on the report code query that could be affecting something. BIDS sometimes get stuck, before going for a rollup you may want to try to remove and re-add that parameter

  • Community Member Profile Picture
    Community Member on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    Hi,

    I am using rollup 12.

    I checked the CRM trace and below is the error message,

    at ErrorInformation.LogError()  ilOffset = 0x17

    at ErrorInformation..ctor(Exception exception, Uri requestUrl, Boolean logError, IOrganizationContext context)  ilOffset = 0x1F5

    at ErrorInformation..ctor(Exception exception, Uri requestUrl, IOrganizationContext context)  ilOffset = 0x0

    at MainApplication.Application_Error(Object sender, EventArgs eventArguments)  ilOffset = 0x81

    at EventHandler.Invoke(Object sender, EventArgs e)  ilOffset = 0xFFFFFFFF

    at HttpApplication.RaiseOnError()  ilOffset = 0x26

    at ApplicationStepManager.ResumeSteps(Exception error)  ilOffset = 0x85

    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)  ilOffset = 0x5C

    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)  ilOffset = 0x16A

    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)  ilOffset = 0x4B

    >MSCRM Error Report:

    --------------------------------------------------------------------------------------------------------

    Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Error Message: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Error Details: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Source File: Not available

    Line Number: Not available

    Request URL: cdhodev01.domainx.local/.../reportviewer.aspx

    Stack Trace Info: [FormatException: Input string was not in a correct format.]

    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

    at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)

    at System.Web.UI.HtmlControls.HtmlInputImage.LoadPostData(String postDataKey, NameValueCollection postCollection)

    at System.Web.UI.Page.ProcessPostData(NameValueCollection postData, Boolean fBeforeLoad)

    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]

    at System.Web.UI.Page.HandleError(Exception e)

    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    at System.Web.UI.Page.ProcessRequest()

    at System.Web.UI.Page.ProcessRequest(HttpContext context)

    at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    it says " Stack Trace Info: [FormatException: Input string was not in a correct format.]"

    I think when click on the arrow button the report get executed in some way.

    Any suggestion.

  • Suggested answer
    Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    Did you follow all of these steps?

    community.dynamics.com/.../ssrs-58-working-with-multi-value-parameters.aspx

    Do you have also everything compatible (CRM server, SQL server and SSRS Adaptor updated with the same rollup?)

    there is a fix for some that sounds like this problem on rollup 16:

    "When you attempt to choose a value from a multi parameter drop down in a SSRS report from within CRM web or Outlook client you receive a script error."

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

    if So, I would start looking on the SSRS report log

    %ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

    also the CRM trace that need to be enabled

    support2.microsoft.com/.../907490

  • Community Member Profile Picture
    Community Member on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    Hi, 

    Thank you for your time.

    Report works  really well if I don't click on the down arrow of multivalued parameter while it is expanded. 

    This report runs and gives correct output. The problem occurs only when I make the cert year parameter as multivalued. 

    This issue is connected to SSRS multivalued parameter functionality with CRM.

  • Suggested answer
    Bruno Lucas Profile Picture
    Bruno Lucas 5,421 on at
    RE: CRM report crash when click on down arrow of Multivalued parameter list added through SSRS

    when you say "Then I uploaded that to CRM 2011 and the Report functionality works really well", how did you test it?

    few places to check:

    when you go to your ssrs\reports and open the report you deployed, how is the connection? is this working fine or pointing to some development environment

    www.databasejournal.com/.../data-driven-subscription-in-ssrs-2008-r2.html

    you can enable crm trace log and check the ssrs trace logs, the error message there will give you a better clue

    is there any other custom reports deployed and working. do you have the crm data connector with the same version\rollup as the crm server?

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans