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
307 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

26 Experts available now in Live!

Get 1:1 Help Now