Print Page | Close Window

Filter Association

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19072
Printed Date: 04 Apr 2025 at 8:33pm


Topic: Filter Association
Posted By: dkrumholz
Subject: Filter Association
Date Posted: 08 Feb 2013 at 1:56pm
I'm using Crystal for VS2010 for reporting from Timesheet. I am new to Crystal and I am modifying an existing report to add an additional grouping. The other grouping headers have a field with the group name and they have a filter associated with them so the header display field can be constructed depending on its value. So it can say "Project: xxx" or "No project association" depending on the data. I can add a field to the new header I have created but I can't figure out how to associate a filter with it to do the do the string construction. Does an "@" sign displayed with the fieldname indicate that a filter is associated with the field or does the "@" sign have some other significance? But my primary question is - how do I get a filter associated with my textfield?


Replies:
Posted By: Sastry
Date Posted: 16 Mar 2013 at 8:43pm
Hi
 
Do not place your text field directly into the report, in field explorer you will find formula fields and right click on it and create a new one.
 
Now here enter a formual to associate a condition to it.
 
Example :
 
If {databasefield_Country} = "USA"  Then
 
{USA_SALES_DATABASEFIELD}
 
Else
 
0
 
mailto:@ - '@' symbol represents that it is a formula field.  there is no significance for this.
 
 
 


-------------
Thanks,
Sastry

Posted By: dkrumholz
Date Posted: 17 Mar 2013 at 12:34am
thanks


Print Page | Close Window