CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 How to display 2 fields from Joined Table

Print topic Send  topic

Author Message
Pinchas
Posted: 11/26/2002, 1:18 AM

One way which I know is to define two fields V1 and V2 and join each one of them to show the desired field and after this to define a third virtual field V3 and in BeforeShow event
fldv3 = fldv1 & " " and fldv2

I think this is a complicated way, Is there a simple way to implement this issue?

Tom
Posted: 11/26/2002, 9:43 AM

If you are using CCS, you can write a database expression for a field in the properties for the source type. Instead of db column, use db expression and put in your fldv1 & " " & fldv2

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.