Home » Developer & Programmer » Reports & Discoverer » help (disc 10.1.2)
help [message #335541] Tue, 22 July 2008 08:56 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi All
I have to create a report where there are four stages on the X aixs:

oncall-unit price
oncall-negotiated rate
project specific
amendments
I have to find the number of firms for each stage for each quarter in a graph.
My question is how do i get the 4 stages on the Xaxis ?

any advice will be of grt help.

thnks
Re: help [message #335637 is a reply to message #335541] Wed, 23 July 2008 01:33 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Could you tell us what the data model is you're working with? (table descriptions and preferably some sample data)
Re: help [message #335748 is a reply to message #335637] Wed, 23 July 2008 09:13 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thanks for the reply

I have a table in which i have 2 fields: contract_type and contract_comp_method
On the X axis i need to have 4 combinations of the above 2 fields
1)contract_type=on call and contract_comp_method=unit price
2)on call and negotiated rate
3)project specific and other
4)amendments
its like group A,B,C,D
and on the Y XAIS i need to have the number of days and the graph must represent the quarter for each color of the bar from 2006 to 2008.


thnks
Re: help [message #335886 is a reply to message #335748] Thu, 24 July 2008 01:42 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
The information you provided can not be complete, since you only mention 1 table with 2 columns, which can never result into a graph with number of days. It would make matters a bit easier of you would provide the complete details.

However, I think you are looking for a calculated item, something like:

case when column_a = 'x' and column_b like 'abc%' then 'A'
when column_a = 'x' and column_b not like 'abc%' then 'B'
when column_a in ('y','z') then 'C'
else 'D'
end


Enter the conditions as needed in the various when statements.


Previous Topic: how to pass parameter to report
Next Topic: date to quarter help
Goto Forum:
  


Current Time: Fri Dec 09 17:43:18 CST 2016

Total time taken to generate the page: 0.25321 seconds