SQL Server Reporting Service Input Structure

I am receiving an error where a field "Name" is missing from the input structure.  How do I handle this problem?  I haven't seen much information about this online and I am looking for help.  Thanks!
VBBRettAsked:
Who is Participating?
 
VBBRettAuthor Commented:
It turns out that the reason why the Input structure was not working is because I had a blank field being passed into the Reporting Server and as I learned and found when I did research, you cannot pass a blank field into the Report Server.  So after I figured out to only pass 6 records of parameters into the Report Server as opposed to 7 which included a blank field, the problem was resolved.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Show us the query that returns this error.

If you have a column named Name, they you may have to use square brackets [Name] surrounding it, as Name is a property of almost everything.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.