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
311 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Data source in SSRS 2 60
SSRS Dynamic Date Parameter 25 583
SSRS MONTHNAME and IIF 16 85
SSRS 2012 r2 - Parm Drop Down has Date/Time 12 44
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 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