Solved

SQL Server Reporting Service Input Structure

Posted on 2015-01-26
2
81 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
2 Comments
 
LVL 65

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

863 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

20 Experts available now in Live!

Get 1:1 Help Now