Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to achieve multiple detail bands with columns?
Message
From
20/07/2003 16:47:55
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
 
To
20/07/2003 16:39:18
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00809019
Message ID:
00811867
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
Henry
You have to convert the TmpData.date1 column to a character.
iif(TmpData.SortKey = "6", TmpData.Descr+" "+transform(TmpData.Date1), TmpData.Descr)
>Hi Cathy:
>
>Here is an expression I used in the report for a field. The idea here is to evaluate whether the SortKey is for Consultations. If so, then print both the description and the Date Referred (Date1), else, just print the Descr field.
>
>
iif(TmpData.SortKey = "6", TmpData.Descr+" "+TmpData.Date1, TmpData.Descr)
>
>However, I get a "Operator/operand type mismatch". Wondering if the concats of the Descr and the Date1 fields is causing the problem. If so, how do I get the Date Referred also to print for consults?
>
>Thanks Cathy.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform