BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: Upcoming Events: BONYMAUG: May 14, BI2014 Nice, France: May 21.

Need to display trend arrows in WebI report


 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
A_bouser
Forum Member
Forum Member



Joined: 05 Oct 2004

Posts: 27



PostPosted: Tue Jun 13, 2006 11:40 pm 
Post subject: Need to display trend arrows in WebI report

Hi, I need to display arrows for trend in a WebI report and then be able to save it as PDF. I can display up and down arrows in report but in PDF it shows HTML tags and not arrows.
Is there any other way (apart from image url). BO is on Solaris so I don't think wingdings font is a solution.

Thanks
Back to top
Farhan Jaffery
Forum Enthusiast
Forum Enthusiast



Joined: 27 Aug 2005

speaker.gif
Posts: 1010
Location: Houston, TX


flag
PostPosted: Wed Jun 14, 2006 2:27 pm 
Post subject: Re: Need to display trend arrows in WebI report

We use gif/jpeg/png image files and then use alerters to determine the right image to display trend.
_________________
Farhan Jaffery
SAP Certified - BOE 3.x
J.P. Morgan Chase
Houston, Texas
Back to top
A_bouser
Forum Member
Forum Member



Joined: 05 Oct 2004

Posts: 27



PostPosted: Wed Jun 14, 2006 3:51 pm 
Post subject: Re: Need to display trend arrows in WebI report

Why do we need to use alerter, we can use IF or CASE statement. What benefit do we get using alerter.
I want to avoid using image because then we cannot use alternate rows in different colour, the background of image is white so background colour of rows has to be white.
Also if user changes the size of cell this image will not get alinged.
Thanks
Back to top
Farhan Jaffery
Forum Enthusiast
Forum Enthusiast



Joined: 27 Aug 2005

speaker.gif
Posts: 1010
Location: Houston, TX


flag
PostPosted: Thu Jun 15, 2006 2:15 pm 
Post subject: Re: Need to display trend arrows in WebI report

Using the if statement, you are limited to ascii charcter representation of arrows. Using images/alerters, you get much more control over type/allignment/style of images. Resizing of the cell should not be an issue if you set the allignment properties of the image correctly within the alerter.

If you are using Release 2, you can make the alerters smart enough to know what row is it and then choose the image with the right background color.

_________________
Farhan Jaffery
SAP Certified - BOE 3.x
J.P. Morgan Chase
Houston, Texas
Back to top
filip
Senior Member
Senior Member



Joined: 29 Dec 2005

Posts: 94


flag
PostPosted: Fri Jun 16, 2006 1:26 am 
Post subject: Re: Need to display trend arrows in WebI report

fjaffery wrote:
Using the if statement, you are limited to ascii charcter representation of arrows.


That's not entirely true: you can also use images in combination with the If-statement. You just have to change the cell properties into "image URL".
Back to top
Emanuel
Senior Member
Senior Member



Joined: 12 Dec 2005

Posts: 38
Location: US



PostPosted: Tue Jun 20, 2006 8:34 am 
Post subject: Re: Need to display trend arrows in WebI report

The only problem I see using images showing trends is when exported to excel, trends (images) do not appear. In webi or pdf, works like a charm. Let me know if there is any workaround for that.

Emanuel
Back to top
Farhan Jaffery
Forum Enthusiast
Forum Enthusiast



Joined: 27 Aug 2005

speaker.gif
Posts: 1010
Location: Houston, TX


flag
PostPosted: Tue Jun 20, 2006 12:24 pm 
Post subject: Re: Need to display trend arrows in WebI report

We use png/jpeg images and have no issues. These images appear in Crystal/Webi/PDF. The only known issue is with gif images in pdf with inconsistent behavior.
_________________
Farhan Jaffery
SAP Certified - BOE 3.x
J.P. Morgan Chase
Houston, Texas
Back to top
Emanuel
Senior Member
Senior Member



Joined: 12 Dec 2005

Posts: 38
Location: US



PostPosted: Tue Jun 20, 2006 4:59 pm 
Post subject: Re: Need to display trend arrows in WebI report

Yes that's true but when you export to excel the images do not appear ... other formats look fine
Back to top
alphaomegabeta
Senior Member
Senior Member



Joined: 02 Jan 2007

Posts: 45


flag
PostPosted: Wed Apr 04, 2007 10:55 am 
Post subject: Re: Need to display trend arrows in WebI report

In my Webi report, when I view it in pdf mode, the images do not appear, even after I do a refresh. The images are red and green trend arrows in jpeg.

The code I am using in the trend variable set to read as image URL is:

=If([Total Accounts Opened]<Previous([Total Accounts Opened]);"http://www.images.com/red.JPG";"http://www.images.com/green.JPG")

In Webi mode the reports shows the trend images fine. Note: (the url in example is fake).

I tried this in an individual cell also, still did not work.

What could be wrong?

_________________
"Continuous effort, not strength or intelligence is the key to unlocking our potential"
Back to top
cyg
Senior Member
Senior Member



Joined: 14 Jun 2004

Posts: 35



PostPosted: Fri Apr 13, 2007 4:40 am 
Post subject: Re: Need to display trend arrows in WebI report

The Arial font would have up/down arrows, or a lot of other symbols. It is nothing fancy but it serves the purpose. And it works fine if exported to excel/pdf.

In windows you can copy and paste it from the Character Map (in WinXP its found in Programs > Accessories > System Tools)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0594 seconds using 17 queries. (SQL 0.0135 Parse 0.0346 Other 0.0113)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo