Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Is there any limit on parameter values for custom report? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Am developing crm 2011 SSRS report, here i do have 10 parameters. In that every parameter will have n no of values.

    All the parameters are having n no of values. So, when i ran the report with more values it saying as "no arguments found" error occurred. For few values working fine.

    Is there any limit to specify values and no of parameters to pass?

    Thanks in advance....

    Monday, November 4, 2013 5:46 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

         From MSDN article below:

    The maximum length of the parameter values that is passed in from Microsoft Dynamics CRM is 2,000 characters. For example, if you run a report and create a data filter through the Advanced Find user interface, the resulting filter expression that is passed to a filter parameter cannot exceed 2,000 characters. There is no maximum limit on the number of parameters that you can specify. However, you might have to limit the length of the string on the URL line and number of parameters to meet the requirements of a particular browser.

    http://msdn.microsoft.com/en-us/library/gg309583.aspx


    Hope this helps.
     
    -----------------------------------------------------------------------
     Minal Dahiya
    blog : http://minaldahiya.blogspot.com.au/

     
    If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"

    • Proposed as answer by Minal Dahiya Monday, November 4, 2013 6:50 AM
    Monday, November 4, 2013 6:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Would you please confirm the total no of parameter values? Would you please check the reporting service log for error at path  installed drive/Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles?

    It is related to total length of no of parameters selected. I think maximum length is 7062 characters.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/cb6ede72-6ed1-4379-9d3c-847c11b75b32/report-manager-operation-cannot-run-due-to-current-state-of-the-object?forum=sqlreportingservices

    hope this helps!

    Monday, November 4, 2013 7:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for quick reply. But my guess is, by sql query we can pass more than 2000 characters as values. 

    I want to know possible characters length of values for Filtered View's?

    Monday, November 4, 2013 7:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

         I think it is 7062 characters but if the report is going to need so many parameters, I would be worried about the performance of CRM system more than the maximum limit. I would not recommend running report with so many parameters in CRM database. There are various BI solutions available for larger reports.


    Hope this helps.
     
    -----------------------------------------------------------------------
     Minal Dahiya
    blog : http://minaldahiya.blogspot.com.au/

     
    If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"

    Monday, November 4, 2013 10:19 AM