[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 124
  • Last Modified:

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!
0
VBBRett
Asked:
VBBRett
1 Solution
 
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
 
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

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now