OraFAQ Forum: Reports & Discoverer » Graphics Builder

Home » Developer & Programmer » Reports & Discoverer » Graphics Builder - Easy Question?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Graphics Builder - Easy Question? [message #109540]

Fri, 25 February 2005 11:01

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

Hello.

Now that I let the steam disperse over my frustration with Graphics Builder, I can actually ask my question.

How can I control the ordering of bars in a bar chart along the X axis? For example. I have the values plotted along the X axis as:

Unknown Veteran Not Veteran Vietnam Veteran Disable Vet

I need to switch it to read:

Unknown Not Vet Veteran Vietnam Veteran Disabled Vet

How do I control that?

Also, I have many bar chart reports that are compared by gender. For example, I will have a paygrade group plotted on my X axis and within each paygrade group, I compare the MALES and FEMALES. Say in one report, for paygrade 10, I see MALES plotted before FEMALES. Now in another report, for the same paygrade, I see FEMALES plotted before MALES. How can I keep the plotting consistent across the reports? I don't see any options jumping out at me, so I assume this may have to be resolved programmatically. Does anyone have any suggestions? Thanks!

Regards,
Steve

Report message to a moderator

Re: Graphics Builder - Easy Question? [message #109851 is a reply to message #109540]

Tue, 01 March 2005 08:29

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

nobody?

Report message to a moderator

Re: Graphics Builder - Easy Question? [message #109867 is a reply to message #109851]

Tue, 01 March 2005 09:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Doesn't an order by in your query take care of that?

I've never used Graphics myself but a quick (EMP) test showed me that I can perfectly control the order along the X axis using an ORDER BY clause.

MHE

[Updated on: Tue, 01 March 2005 14:43]

Report message to a moderator

Re: Graphics Builder - Easy Question? [message #109877 is a reply to message #109540]

Tue, 01 March 2005 11:03

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

Maaher -

Thank you for the response. I may run into some problems with the ORDER BY, because I think I purposefully left it out for a reason I can longer recall. I will try your solution. Thank you!

Steve

Report message to a moderator

Re: Graphics Builder - Easy Question? [message #109885 is a reply to message #109540]

Tue, 01 March 2005 13:26

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

Maaher -

Your solution worked. I thought it would be an easy fix, but wasn't sure what it was. You can also exercise greater control by ranking your ORDER BY clause in a manner like this:

ORDER BY
PayGrade,
DECODE(papf.sex, 'M', 1
,'F', 2)

Again, thank you!

Steve

edit for typo

[Updated on: Tue, 01 March 2005 15:03]

Report message to a moderator

Re: Graphics Builder - Easy Question? [message #109896 is a reply to message #109885]

Tue, 01 March 2005 14:42

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I used DECODE too in my tests, but forgot to post my queries. Glad to see you found the solution!

MHE

Report message to a moderator

Previous Topic:	conditional page breaks
Next Topic:	a tree structure in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:14:47 CST 2024