Solved

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

Posted on 2010-11-30
6
304 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:rhservan
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:BostonMA
ID: 34239699
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
 

Author Comment

by:rhservan
ID: 34240411
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
 
LVL 4

Accepted Solution

by:
BostonMA earned 500 total points
ID: 34240440
So when you right click on the table, what dataset is listed in the dataset name?  See the attached image
table-properties.JPG
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:rhservan
ID: 34240864
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
 
LVL 4

Assisted Solution

by:BostonMA
BostonMA earned 500 total points
ID: 34241389
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
 

Author Closing Comment

by:rhservan
ID: 34241536
Thank you for your expertise.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now