troubleshooting Question

Data Binding Heading Data

Avatar of EdwardAF
EdwardAFFlag for United States of America asked on
SSRS
4 Comments1 Solution619 ViewsLast Modified:
I recently inherited a work in progress, which included reports written in Reporting Services.  They were originally written in RS 2008, and I updated them to 2010, including updating the references to Microsoft.ReportViewer.*.

The report shows data using this format:

Employee#
Trip (column)   Status (col)   Zone (col)   Etc.... (cols)

So there is a heading level for the employee (note - not a header or footer) and columns that apply to that heading.  This structure works as deployed under the old version; however, after being upgraded to 2010, The employee field shows "#ERROR", and when I right-click on the field, select "Expression.." and look at the "Fields" list, no fields are available, and a message appears "Report item not linked to a dataset."  I can not find any place to link it to a dataset.  The columns below this field are linked and show the data you would expect from the underlying table.

How do I link the heading field up to a dataset? EdwardAF-459793.flv
ASKER CERTIFIED SOLUTION
Nico Bontenbal

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros