Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
314 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 2000 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
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.

 

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 2000 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

661 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