Excellent examples Brenda,
sorry if my answer sounded a bit cryptical. My only excuse is, I come from a
programming background J
Mvh /Mehrdad
--------------------------------------------------------------------------------------
Mehrdad Ravanbod
IT/Database
Admin
Email: [log in to unmask]
Moderna
Museet
Tel mobil: 0708 945795, ankn. 5246
Box 16382
103 27
Stockholm
Från: The Museum
System (TMS) Users [mailto:[log in to unmask]] För Brenda Podemski
Skickat: den 22 oktober 2010 19:15
Till: [log in to unmask]
Ämne: Re: Crystal reports inquiry
Hi Michelle,
I don't know if Mehrdad's reply was enough to get you
going, but here's a quick example of how you might use formula fields for
this purpose:
Formula field: ConstituentDates
IF ISNULL({CONSTITUENTS.DISPLAYDATE})
THEN ""
ELSE IF ISNULL({CONSTITUENTS.NATIONALITY}) THEN {CONSTITUENTS.DISPLAYDATE}
ELSE " , " + {CONSTITUENTS.DISPLAYDATE}
Formula field: ConstituentNationality
IF ISNULL({CONSTITUENTS.NATIONALITY}) then ""
ELSE {CONSTITUENTS.NATIONALITY}
Formula field: ConstituentNationalityDates
IF {@ConstituentNationality}
= "" AND {@ConstituentDates}
= "" THEN {CONSTITUENTS.DISPLAYNAME}
ELSE {CONSTITUENTS.DISPLAYNAME} + " (" + {@ConstituentNationality} + {@ConstituentDates} + ")"
You would use the ConstituentNationalityDates formula
field for display.
Handled in this way your full constituent string will
display properly, even if DisplayDate or Nationality (or both) are missing.
Exporting to Excel is sometimes tricky business.
Typically, a format that looks nice on screen does not export cleanly and vice
versa. If the intent is to get a clean Excel export I use ListViews when
possible.
Best,
Brenda
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Brenda Podemski
Business Applications Administrator
Collection Information & Access
The J. Paul Getty Museum
www.getty.edu
v. +1 310-440-7087 | f. +1 310-440-7752 |
e. [log in to unmask]
>>> Mehrdad Ravanbod
<[log in to unmask]> 10/18/2010 7:47 AM >>>
Hi
I suggest you use a
formula, formulas provide much better means of concatenating Strings and literals
than simple combining of database fileds and text fields!
Mvh /Mehrdad
--------------------------------------------------------------------------------------
IT/Database
Admin
Email: [log in to unmask]
Moderna
Museet
Tel mobil: 0708 945795, ankn. 5246
Box 16382
103 27
Stockholm
Från:
Skickat: den 4 oktober 2010 21:20
Till: [log in to unmask]
Ämne: Crystal reports inquiry
Crystal report experts, expert-wannabe's, and/or anyone able to offer
assistance (not intended to sound too desperate);
I'm struggling with a Crystal issue that goes beyond my limited knowledge, and
wonder if anyone could offer assistance with this matter.
I'd like a report that returns the Constituent 'DisplayName', followed by
'Nationality' and 'DisplayDate'.
Perhaps an easy task (for some), but with two additional variables:
1 - I'd like parenthesis after 'DisplayName' surrounding 'Nationality', 'DisplayDate'.
A typical way to display, but I cannot get it to work properly. ie: Henri
Lebasque (French, 1865-1937)
2 - when I export the report to Excel, I need all three fields (DisplayName,
Nationality, DisplayDate) to appear in ONE column, not three separate columns.
And lastly, during the export to Excel, any tips on why some records, at
random, don't appear in their respective columns? ie: 'Dimensions' falls under
'Medium' column, 'DisplayName' falls under 'Dimensions' column. Anyone else
experience this odd behavior and might offer advice?
Any suggestions would be greatly appreciated. Many thanks, in advance.
--
Michelle VanAuken
Picker Art Gallery, Colgate University
13 Oak Drive, Hamilton, NY 13346
315.228.7692
[log in to unmask]