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?
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?
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.
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
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"
Best Regards ,
Blue Wang
I have no experience with developing SSRS reports. I can't help you with the last issue. Probably another volunteer?
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."
Hi Johnny,
Probably, you can try to get a specific version back from your Visual Studio repository?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,263 Super User 2024 Season 2
Martin Dráb 228,112 Most Valuable Professional
nmaenpaa 101,148