Solved

SSRS PARAMETER ERROR

Posted on 2015-01-27
3
1,341 Views
Last Modified: 2015-01-27
When  develop a report in VS, and execute it..it runs perfectly as expected. However, when I deploy the report to execute on the portal, the following error appears:

An error has occurred during report processing. (rsProcessingAborted)
An attempt was made to set a data set parameter '@' that is not defined in this data set. (rsUnknownDataSetParameter)

Please is there anything I may have missed out?
0
Comment
Question by:barkome
3 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40572678
Insufficient information.
0
 

Author Comment

by:barkome
ID: 40572701
I have a report developed with MS Visual Studio, when I preview it, it works fine.

When I deploy it on to the live SSRS web portal, the following error appears.

An error has occurred during report processing. (rsProcessingAborted)
An attempt was made to set a data set parameter '@' that is not defined in this data set. (rsUnknownDataSetParameter)
0
 
LVL 14

Accepted Solution

by:
Vikas Garg earned 500 total points
ID: 40574495
Hello,

There may be two reasons the parameter is not correctly bound with dataset or since parameter is case sensitive this can happen.

Hope this below link will let you overcome the error.

http://techequation.com/an-attempt-was-made-to-set-a-data-set-parameter-that-is-not-defined-in-this-data-set/
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now