Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Zero Display ...(Zero Display ...)
Zero Display ... [message #888974] Mon, 18 June 2012 20:59 Go to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Hi I am working on report which will display the count for 8 quarters. When I am creating data set I am getting the count for the records that are available. The results are as follows.

QUARTER_START_DATE CNT
------------------ ---
Oct-11 1
Jul-12 34
Oct-12 3
Jul-13 1

I am using the following query:

SELECT
TO_CHAR((TRUNC ("TARGET-DEPLOYMENT-DATE",'Q')+93),'MM-YYYY') AS quarter_start_date ,COUNT (ASSETURN) AS cnt
FROM ERRUSER.RPT_CLASSIFIERS_36
WHERE
"TARGET-DEPLOYMENT-DATE" >= ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -9 )
AND "TARGET-DEPLOYMENT-DATE" < ADD_MONTHS ( TRUNC (SYSDATE, 'Q'),15)
GROUP BY (TRUNC ("TARGET-DEPLOYMENT-DATE" ,'Q'))
ORDER BY TRUNC ("TARGET-DEPLOYMENT-DATE" , 'Q')

Can u suggest me how can I achieve the following result:


QUARTER_START_DATE CNT
----------------- ---
Q3 - 2011 0
Q4 - 2011 1
Q1 - 2012 0
Q2 - 2012 34
Q3 - 2012 0
Q4 - 2012 3
Q1 - 2013 0
Q2 - 2013 1


Thanks in advance,
AR
Re: Zero Display ... [message #888978 is a reply to message #888974] Mon, 18 June 2012 21:04 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Hi I am working on report which will display the count for 8 quarters. When I am creating data set I am getting the count for the records that are available. The results are as follows.

QUARTER_START_DATE CNT
------------------ ---
Oct-11 1
Jul-12 34
Oct-12 3
Jul-13 1

I am using the following query:

SELECT
TO_CHAR((TRUNC ("TARGET-DEPLOYMENT-DATE",'Q')+93),'MM-YYYY') AS quarter_start_date ,COUNT (ASSETURN) AS cnt
FROM ERRUSER.RPT_CLASSIFIERS_36
WHERE
"TARGET-DEPLOYMENT-DATE" >= ADD_MONTHS ( TRUNC (SYSDATE, 'Q') , -9 )
AND "TARGET-DEPLOYMENT-DATE" < ADD_MONTHS ( TRUNC (SYSDATE, 'Q'),15)
GROUP BY (TRUNC ("TARGET-DEPLOYMENT-DATE" ,'Q'))
ORDER BY TRUNC ("TARGET-DEPLOYMENT-DATE" , 'Q')

Can u suggest me how can I achieve the following result:


QUARTER_START_DATE CNT
----------------- ---
Q3 - 2011 0
Q4 - 2011 1
Q1 - 2012 0
Q2 - 2012 34
Q3 - 2012 0
Q4 - 2012 3
Q1 - 2013 0
Q2 - 2013 1

Please let me know if any information required.

Thanks in advance,
AR
Re: Zero Display ... [message #888979 is a reply to message #888978] Mon, 18 June 2012 21:07 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Please note that in the above post both QUARTER_START_DATE and CNT are two different columns. The values are as follows:

QUARTER_START_DATE

Q3 - 2011
Q4 - 2011
Q1 - 2012
Q2 - 2012
Q3 - 2012
Q4 - 2012
Q1 - 2013
Q2 - 2013

CNT

0
1
0
34
34
3
0
0

Thanks
AR
Re: Zero Display ... [message #889239 is a reply to message #888979] Tue, 19 June 2012 03:54 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Does the BIRT designer see the first column of this:


QUARTER_START_DATE CNT ------------------
---
Oct-11 1
Jul-12 34
Oct-12 3
Jul-13 1

as a date or a string? If it is a date you could use a crosstab setup
to show empty values as described here:

http://www.eclipse.org/birt/phoenix/project/notable2.5.php#jump_11

See attached example.


Jason

On 6/18/2012 5:07 PM, A R wrote:
> Please note that in the above post both QUARTER_START_DATE and CNT are
> two different columns. The values are as follows:
>
> QUARTER_START_DATE
>
> Q3 - 2011
> Q4 - 2011
> Q1 - 2012
> Q2 - 2012
> Q3 - 2012
> Q4 - 2012
> Q1 - 2013
> Q2 - 2013
>
> CNT
>
> 0
> 1
> 0
> 34
> 34
> 3
> 0
> 0
>
> Thanks
> AR
>
Re: Zero Display ... [message #889811 is a reply to message #889239] Tue, 19 June 2012 18:00 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Hello Jason,

That was a nice example. I have few more questions that, if I want to show the result in graph and instead of empty values '0' means ...how we can achieve this.

I tried to take the datacube as a dataset for graph. What I learned is, we can only refer to a group at a time. Correct me if I am wrong.

Thanks,
AR
Re: Zero Display ... [message #889843 is a reply to message #889811] Tue, 19 June 2012 21:40 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Hi Jason - I am able to create a dataset which is giving the following results :

JUL-2011 0
OCT-2011 1
JAN-2012 0
APR-2012 0
JUL-2012 35
OCT-2012 3
JAN-2013 0
APR-2013 0
JUL-2013 1
OCT-2013 0

Thanks,
AR
Re: Zero Display ... [message #889848 is a reply to message #889843] Tue, 19 June 2012 22:04 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Does this mean you got it to work? BTW you can make empty values
display 0 in your example. There is a row/column setting in the
crosstab for that. You can also create a chart view from a the crosstab
that should display the chart.

Jason

On 6/19/2012 5:40 PM, A R wrote:
> Hi Jason - I am able to create a dataset which is giving the following
> results :
>
> JUL-2011 0
> OCT-2011 1
> JAN-2012 0
> APR-2012 0
> JUL-2012 35
> OCT-2012 3
> JAN-2013 0
> APR-2013 0
> JUL-2013 1
> OCT-2013 0
>
> Thanks,
> AR
Re: Zero Display ... [message #889852 is a reply to message #889848] Tue, 19 June 2012 22:40 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
- Yes Jason, I am able to proceed with the help of dataset. I am working on , to replace the months with respective quarters.

Please find the attached report design.

- I will try the using cross tab and update you. That is a great learning Smile

Thanks
AR
Re: Zero Display ... [message #889854 is a reply to message #889848] Tue, 19 June 2012 22:56 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Jason can you tell me how we can achieve the following :
This is the input to x-axis in chart.

Data as is :

QUARTER
Jul-11
Oct-11
Jan-12
Apr-12
Jul-12
Oct-12
Jan-13
Apr-13


Expected:

QUARTER
Q3-2011
Q4-2011
Q1-2012
Q2-2012
Q3-2012
Q4-2012
Q1-2013
Q2-2013


- AR
Re: Zero Display ... [message #889863 is a reply to message #889854] Wed, 20 June 2012 03:17 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

What data type is quarter in your data table?

Jason

On 6/19/2012 6:56 PM, A R wrote:
> Jason can you tell me how we can achieve the following : This is the
> input to x-axis in chart.
>
> Data as is :
>
> QUARTER
> Jul-11
> Oct-11
> Jan-12
> Apr-12
> Jul-12
> Oct-12
> Jan-13
> Apr-13
>
>
> Expected:
>
> QUARTER
> Q3-2011
> Q4-2011
> Q1-2012
> Q2-2012
> Q3-2012
> Q4-2012
> Q1-2013
> Q2-2013
>
>
> - AR
Re: Zero Display ... [message #890034 is a reply to message #889863] Wed, 20 June 2012 17:34 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
It is TIMESTAMP(6) in database.

-AR
Re: Zero Display ... [message #890064 is a reply to message #890034] Wed, 20 June 2012 21:42 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Jason please let me know if u want me to provide any other details.

-AR
Re: Zero Display ... [message #890077 is a reply to message #890064] Wed, 20 June 2012 22:35 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I do not have a timestamp example but look at the attached. I return a
date and then use a cube to split it into quarters. I have three
examples in the report. The first is just a stander crosstab. The
second is a crosstab that I have created a chart view from and the third
is a crosstab with a contained chart for the measure.

Jason

On 6/20/2012 5:42 PM, A R wrote:
> Jason please let me know if u want me to provide any other details.
>
> -AR
  • Attachment: quarters.zip
    (Size: 6.53KB, Downloaded 57 times)
Re: Zero Display ... [message #890080 is a reply to message #890077] Wed, 20 June 2012 23:46 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Sorry to trouble you Mr.Jason. Will update you asap. Thank you very much.

-AR

[Updated on: Wed, 20 June 2012 23:51]

Report message to a moderator

Re: Zero Display ... [message #890285 is a reply to message #890080] Thu, 21 June 2012 18:25 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Jason - I m not able to execute the report. When ever I am trying to execute , the BIRT environment closes automatically. I have downloaded BIRT 3.7.2 environment to execute the report. Please suggest.

Thanks
AR
Re: Zero Display ... [message #890291 is a reply to message #890285] Thu, 21 June 2012 18:55 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Have you tried in 3.7.2? That is version I wrote it in.

On 6/21/2012 2:25 PM, A R wrote:
> Jason - I m not able to execute the report. When ever I am trying to
> execute , the BIRT environment closes automatically. I have downloaded
> BIRT 3.7.2 environment to execute the report. Please suggest.
>
> Thanks
> AR
Re: Zero Display ... [message #890316 is a reply to message #890291] Thu, 21 June 2012 21:57 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Yes
Re: Zero Display ... [message #890580 is a reply to message #890316] Fri, 22 June 2012 15:42 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

That example runs in my 3.7.2 install. Can you start eclipse with the
-clean option?

Jason

On 6/21/2012 5:57 PM, A R wrote:
> Yes
Re: Zero Display ... [message #892365 is a reply to message #890580] Wed, 27 June 2012 21:59 Go to previous messageGo to next message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Hello Jason - I have modified the dataset accordingly and I am able to achieve my requirement. Thanks for the suport ...I will try the option suggested by you and update on the same.

Thanks
AR
Re: Zero Display ... [message #892618 is a reply to message #892365] Thu, 28 June 2012 18:23 Go to previous message
A R is currently offline A R
Messages: 104
Registered: April 2012
Senior Member
Hi Jason - can u please look into the following thread ...

http://www.eclipse.org/forums/index.php/m/892363/#msg_892363

Thanks
AR
Previous Topic:question on report design
Next Topic:Does Birt 2.3.x support IE9?
Goto Forum:
  


Current Time: Sun Oct 26 00:34:45 GMT 2014

Powered by FUDForum. Page generated in 0.02724 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software