Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Sequence contains no m...
Finance forum
Suggested answer

Sequence contains no matching element

Posted on by 6,386

Hello,

I have removed some newly added parameter from report and when I compile the solution, I'm getting error "Sequence contains no matching element".

How can I resolve it?

  • Suggested answer
    Reliable Profile Picture
    Reliable 2,015 on at
    RE: Sequence contains no matching element

    I was facing same issue while customizing PO confirmation report.

    Solutions tried and worked as below-

    1) Don't delete a newly created parameter after refreshing a data source, instead set AllowBlank, Nullable etc. properties to True

    2) Deploy report, you may get error 'The number of defined parameters is not equal to the number of cell definitions in the parameter panel'

    3) Create new report design, copy and paste textboxes and other details to new design.

    4) Delete current design and deploy report with new design.

    5) This should resolve your issue now and then rename your design to original design name.

    Thanks.

  • Suggested answer
    Petra Wiedner Profile Picture
    Petra Wiedner 35 on at
    RE: Sequence contains no matching element

    Hi Johnny,

    we had recently the same error:

    "An unhandled exception was thrown while validating *SSRSReport* with callstack System.InvalidOperationException: Sequence contains no matching element"

    It turned out that during the dataset restore a parameter was added. It was added at the Parameters (sub node Datasets) and the node Parameters.

    When you delete it only in the node Parameters the Error occurs.

    We solved the error with mapping the parameter (at sub node Datasets) to an existing parameter. If that is not possible you can try to set the properties "AllowBlank" to True, "Nullable" to True and "Visibility" to False.

    Best regards,

    Petra

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Sequence contains no matching element

    Hi Johnny,

     

    Does the parameter being invoked have a fixed value, or a default value, or a space?

    Is there a non-existent path in the Config file?

    I suggest you have a check first.

     

    After that, You can open the report server --> enter the report directory --> open the report--> enter the management interface of this report

    -->switch to the parameter label. "prompt user" option on √, the "Hide the option √ --> enter the text--> click“Apply"

     

    https://stackoverflow.com/questions/8119680/parameter-validation-failed-it-is-not-possible-to-provide-valid-values-for-all

     

     

    Best Regards ,

    Blue Wang

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,263 Super User 2024 Season 2 on at
    RE: Sequence contains no matching element

    I have no experience with developing SSRS reports. I can't help you with the last issue. Probably another volunteer?

  • Johnny Profile Picture
    Johnny 6,386 on at
    RE: Sequence contains no matching element

    Hi Andre,

    We have yet only 1 version for this report and it contains this parameter.

    When we run with it it says "A valid value for parameter "parameterName" does not exist."

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,263 Super User 2024 Season 2 on at
    RE: Sequence contains no matching element

    Hi Johnny,

    Probably, you can try to get a specific version back from your Visual Studio repository?

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans