Cross Tab and pictures if possible 1

[szed]

I am using CR10 & excel.

I have a report that works easily with a cross tab except for one field. They want an indicator, which is an up, down, or across (no change) arrow on the side.
I have this stored as a numerical value in the spreadsheet, 0 = no change, 1=up arrow, and 2 = down arrow.

My issue is how to get this into the cross tab. I can display the value but when I try to update the display string for this field it doesn't work, I just keep getting blanks. Plus the cross tab wants to sum the field, but that shouldn't impact it, there is only one unique row for each value so there won't be anything to sum, wasn't sure if that might be part of the issue.

Also, I am testing with text, how do I pull a picture object into a formula to use?

Any suggestions??

 

[kenhamady]

I don't think you can use true pictures, but I know that you can use symbols like Wingdings. Write a formula like this:

If {Shipped} = "T"
then Chr(254)
else Chr(168)

Have your Cross-tab do a MAXIMUM rather than a sum or count. Then format this summary field using WingDings, a large font and/or a color. These codes give you check boxes (checked and empty) but I am sure you could find the codes for arrows.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[szed]

Thanks a lot Ken!!
I used that logic and found arrow symbols in wingdings listed on the web, from there I got the numeric codes, then I used the following code:
@Arrowfield
if {'CIO_Data_'.FLAG} = 0 then "<font face='Symbol' color=yellow>&#222</font>"
else if {'CIO_Data_'.FLAG} = 1 then "<font face='Symbol' color=red>&#221</font>"
else if {'CIO_Data_'.FLAG} = 2 then "<font face='Symbol' color=green>&#223</font>"

Then I changed the text interpretation to HTML and it works great.