Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Filter Association Post Reply Post New Topic
Author Message
dkrumholz
Newbie
Newbie


Joined: 08 Feb 2013
Location: United States
Online Status: Offline
Posts: 2
Quote dkrumholz Replybullet Topic: Filter Association
    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?

Edited by dkrumholz - 10 Feb 2013 at 12:47am
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet 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
 
'@' symbol represents that it is a formula field.  there is no significance for this.
 
 
 
Thanks,
Sastry
IP IP Logged
dkrumholz
Newbie
Newbie


Joined: 08 Feb 2013
Location: United States
Online Status: Offline
Posts: 2
Quote dkrumholz Replybullet Posted: 17 Mar 2013 at 12:34am
thanks
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.027 seconds.