Eclipse Community Forums: BIRT

Home » Archived » BIRT » Zero Display ...(Zero Display ...)

Mon, 18 June 2012 16:59

Eclipse User

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 17:04

Eclipse User

Re: Zero Display ... [message #888979 is a reply to message #888978]

Mon, 18 June 2012 17:07

Eclipse User

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]

Mon, 18 June 2012 23:54

Eclipse User

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
>

Attachment: xtab-emptyqtr.zip
(Size: 3.53KB, Downloaded 265 times)

Re: Zero Display ... [message #889811 is a reply to message #889239]

Tue, 19 June 2012 14:00

Eclipse User

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 17:40

Eclipse User

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 18:04

Eclipse User

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 18:40

Eclipse User

- 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

Attachment: new_report_4.rptdesign
(Size: 49.53KB, Downloaded 234 times)

Re: Zero Display ... [message #889854 is a reply to message #889848]

Tue, 19 June 2012 18:56

Eclipse User

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]

Tue, 19 June 2012 23:17

Eclipse User

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 13:34

Eclipse User

It is TIMESTAMP(6) in database.

-AR

Re: Zero Display ... [message #890064 is a reply to message #890034]

Wed, 20 June 2012 17:42

Eclipse User

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 18:35

Eclipse User

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 250 times)

Re: Zero Display ... [message #890080 is a reply to message #890077]

Wed, 20 June 2012 19:46

Eclipse User

Sorry to trouble you Mr.Jason. Will update you asap. Thank you very much.

-AR

[Updated on: Wed, 20 June 2012 19:51] by Moderator

Re: Zero Display ... [message #890285 is a reply to message #890080]

Thu, 21 June 2012 14:25

Eclipse User

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 14:55

Eclipse User

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 17:57

Eclipse User

Yes

Re: Zero Display ... [message #890580 is a reply to message #890316]

Fri, 22 June 2012 11:42

Eclipse User

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 17:59

Eclipse User

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 14:23

Eclipse User

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:

-=] Back to Top [=-

Current Time: Mon Jul 14 19:38:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter