Solved

SQL Server Reporting Service Input Structure

Posted on 2015-01-26
2
83 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

806 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