Solved

SQL Server Reporting Service Input Structure

Posted on 2015-01-26
2
90 Views
Last Modified: 2015-02-22
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
Comment
Question by:VBBRett
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 40571142
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
 

Accepted Solution

by:
VBBRett earned 0 total points
ID: 40622709
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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

696 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