troubleshooting Question
Data Binding Heading Data
asked on
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
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
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.