Why, when I attempt to write an expression in a working report the fields are not listed in Expression window?

Current:
1. I right click on a table cell in designer and slect Expression
2. In the Expression window I go to the category column and select Fields
3. Normally at this point each field is listed that was created in the report query under Values
Problem:
However, In this report ithere are no Fields listed in the Expression area.  So I attempted to manually enter a field and I get a red line under it.  
How do I get the fields to list correctly in the Expression window? Normally, they are just there.
rhservanAsked:
Who is Participating?
 
BostonMAConnect With a Mentor Commented:
So when you right click on the table, what dataset is listed in the dataset name?  See the attached image
table-properties.JPG
0
 
BostonMACommented:
Is the report based on a Stored Procedure?  If so try to refresh the data set.

Is the table set to use the dataset name of the dataset you are trying to use?  

0
 
rhservanAuthor Commented:
Response 1 - No it is not based on a stored procedure
Response 2 - I am not sure of your quesiton but I will attempt to answer this:
I have a query created and is name dataset1 (default) Iin the designer I have created a report that works well. I want to add an expression into one of the table cells.  This expression relies on one of the fileld names created in dataset1. However,  When I go to the Expression window(fx) there is no fields listed.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
rhservanAuthor Commented:
Okay,  This has helped on the table issues.

Question: What if it is just a text box instead of a table.  Is there someplace in the text box I can set the dataset?
0
 
BostonMAConnect With a Mentor Commented:
Datasets dont apply to a textbox.  
In that case you can use
=(Fields!FieldName.Value, "DataSetName")
and explicitly reference the dataset you want to use.
0
 
rhservanAuthor Commented:
Thank you for your expertise.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.