Subscribe | Alerts via Email
View All Quotes
“Those who cannot tell what they desire or expect, still sigh and struggle with indefinite thoughts and vast wishes.”
-Ralph Waldo Emerson
<March 2010>
SunMonTueWedThuFriSat
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

©2010 Cal Zant
Sign In
Total Posts: 103
This Year: 2
This Month: 0
This Week: 0
Comments: 2

I was working on a report in Report Builder 2.0 for SQL Server 2008 Reporting Services, and added a textbox to an existing report.  I wanted to display some summary info related to the data shown in the report.  I added a textbox, then went to edit the “Expression” property of that report item, but wasn't able to select any fields because it said “Report item not linked to a dataset.”

 

Report Item not linked to a dataset

 

So I tried to find a property on the textbox related to a "Dataset" (like the "DataSetName" property on Tablix elements), but the only thing I found was a “DataElementName” property … which I tried, but didn’t work.

SSRS Report Item Textbox and Tablix Report Builder Properties

I then learned you can link to a dataset by defining it’s name directly in the expression, like this:

=Count(Fields!Address.Value,"DatasetName")

Monday, December 28, 2009 11:36:38 AM (Central Standard Time, UTC-06:00)  #