Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some suggestions
Message
 
 
To
02/09/2008 12:30:15
General information
Forum:
Visual FoxPro
Category:
Stonefield
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01343877
Message ID:
01344197
Views:
15
>Hi Naomi.
>
>>I have another question. We have a report where we set filter by person's last name and first name. We want to be able to have the title of the report to be something like
>>
>>"Individual Donor's Report - First Name Last Name."
>
>You can enter an expression into the header of a report by prefixing it with "=". There's a built-in function called GetConditionValue that returns the filter value for the specified field. So, combining these two ideas, you can use something like this for the report header:
>
>= "Individual Donor's Report - " + GetConditionValue('Donors.FirstName') + ' ' + GetConditionValue('Donors.LastName')
>
>Doug

Hi Doug,

Just to make sure - our fields are coming from People table and we use this table in the Data Selection. So, in our case it would be People.FName, etc., correct?

Thanks again and we're going to try this in a second.

Yes, worked beautifully! Thanks again.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform