Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio >> Crystal Reports for Visual Studio

How change a detail item at runtime based on detail Value

I have a report group header section with a label named "Payee". In the detail section just below, I have a DB field cmstrust.tran_type named field5. When the detail(field5) section returns "CR", I'd like the detail item "payee" to populate with another value. Kind of like 2 detail fields, one on top of the other, one shows when a specific item returns on the same detail row .Can this be done, and if so, how ? Im out of real-estate.
Im using VS 2005 with crystal
Thanks
[512 byte] By [Eric1971] at [2008-1-7]
«« Browser-Enabled InfoPath,Dataset and multi-line text
»» Use string to define an object
# 1
create a "suppress" formula for each field.

Format Field -> suppress field.

make the formula return true when you want it suppressed.

JoeBeam at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 2
I'm following you. However, I'm new to formulas in Crystal. I have the formula window opened, I selected my field(far below) that I want to suppress. I want CMSTrust.PAYOR to show when the trigger field, CMSTrust.TRAN_TYPE = "CR". I need to enter what exactly ? Thanks much

CMSTrust.Payee

Eric1971 at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 3
put the two fields on the report.

right-click the first field-> format field -> common tab -> suppress formula

enter the logic to suppress this field {CMSTrust.TRAN_TYPE} = "CR"
save and close

right-click the second field-> format field -> common tab -> suppress formula

enter the oppostite logic to suppress this field {CMSTrust.TRAN_TYPE} <> "CR"
save and close

position the two fields so they are the same size and at the same location.

hope this helps.

JoeBeam at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
# 4
Joe, that was exactly what I needed. Thank You.
Eric1971 at 2007-10-2 > top of Msdn Tech,Visual Studio,Crystal Reports for Visual Studio...
Visual Studio
Crystal Reports for Visual Studio

Visual Studio Hot Topic

Visual Studio New Topic

Visual Studio

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified