Eclipse Community Forums: BIRT

Home » Archived » BIRT » Missing column(Missing column)

Wed, 27 July 2011 07:57

Eclipse User

Hi All,

I am using a code to generate a report using BIRT.

Here, I am using "Month" in COLUMN of crosstab.
If month have 3 records for ex Jan, Feb, Mar Then cross tab displays that records only.

I want all the Months in column like,

JAN Feb Mar Apr May ...... Dec
26 20 35 - - -

But, Now it displays, First 3 columns.

Plz help me on this

Re: Missing column [message #703435 is a reply to message #703295]

Wed, 27 July 2011 10:55

Eclipse User

Is your month dimension set as a date time dimension? If so look at the
empty rows/columns setting for the crosstab. See attached exmaple.

Jason

On 7/27/2011 7:57 AM, jeyinul wrote:
> Hi All,
>
> I am using a code to generate a report using BIRT.
>
> Here, I am using "Month" in COLUMN of crosstab.
> If month have 3 records for ex Jan, Feb, Mar Then cross tab displays
> that records only.
>
> I want all the Months in column like,
>
> JAN Feb Mar Apr May ...... Dec
> 26 20 35 - - -
>
> But, Now it displays, First 3 columns.
>
> Plz help me on this

Attachment: xtab-empty.rptdesign
(Size: 49.75KB, Downloaded 409 times)

Re: Missing column [message #704883 is a reply to message #703435]

Fri, 29 July 2011 03:05

Eclipse User

Month Column is not datetime.
Its string

Re: Missing column [message #705257 is a reply to message #704883]

Fri, 29 July 2011 11:55

Eclipse User

The only way I think you will be able to get this to work (as BIRT will
not know what is missing) is to add entries to your dataset or switch to
a date time dimension.

Jason

On 7/29/2011 3:05 AM, jeyinul wrote:
> Month Column is not datetime.
> Its string

Re: Missing column [message #707129 is a reply to message #705257]

Mon, 01 August 2011 05:17

Eclipse User

Can you tell me how to add in data set.

Plz explain.

Regards,
Jeyinul.

Re: Missing column [message #707355 is a reply to message #707129]

Mon, 01 August 2011 10:24

Eclipse User

What kind of dataset are you using? Is this a JDBC data set?

Jason

On 8/1/2011 5:17 AM, jeyinul wrote:
> Can you tell me how to add in data set.
>
> Plz explain.
>
> Regards,
> Jeyinul.

Re: Missing column [message #712426 is a reply to message #707355]

Sun, 07 August 2011 04:28

Eclipse User

Hi jason,

IT is JDBC Data set.

Same kind of Problem i met in Chart. But it is solved by adding the below code in data binding and chart.

if(dimension["Group26"]["mon"]=='Jan'){
1;
}else if(dimension["Group26"]["mon"]=='Feb'){
2;
}else if(dimension["Group26"]["mon"]=='Mar'){
3;
}else if(dimension["Group26"]["mon"]=='Apr'){
4;
}
else if(dimension["Group26"]["mon"]=='May'){
5;
}

Now help me in cross tab.

Regards,
Jeyinul.

[Updated on: Mon, 08 August 2011 06:14] by Moderator

Re: Missing column [message #713659 is a reply to message #712426]

Mon, 08 August 2011 14:28

Eclipse User

You could try to add a computed column that converts you month string to
a date.

Jason

On 8/7/2011 4:28 AM, jeyinul wrote:
> IT is JDBC Data set

Re: Missing column [message #713896 is a reply to message #713659]

Tue, 09 August 2011 06:30

Eclipse User

Hi jason,

Thanks for your reply.
I tried jason. But it displays error saying that can not convert.

Please let me know some other way or script. I don't the script.
Please send me Jason.

Thanks and Regards,
Jeyinul.

Re: Missing column [message #713990 is a reply to message #713896]

Tue, 09 August 2011 10:31

Eclipse User

Add a computed column with an expression similar to this:

var mn = 0;
if( dataSetRow["month"] == "Jan" ){
mn= 0;
}
if( dataSetRow["month"] == "Feb" ){
mn= 1;
}
if( dataSetRow["month"] == "Mar" ){
mn= 2;
}
if( dataSetRow["month"] == "Apr" ){
mn= 3;
}
if( dataSetRow["month"] == "May" ){
mn= 4;
}
if( dataSetRow["month"] == "Jun" ){
mn= 5;
}

new Date(2010, mn, 1, 1, 1, 1, 1);

Set its data type to date.

Jason

On 8/9/2011 6:30 AM, jeyinul wrote:
> Hi jason,
>
> Thanks for your reply.
> I tried jason. But it displays error saying that can not convert.
>
> Please let me know some other way or script. I don't the script.
> Please send me Jason.
>
> Thanks and Regards,
> Jeyinul.
>

Re: Missing column [message #714344 is a reply to message #713990]

Wed, 10 August 2011 07:30

Eclipse User

Thanks Jason,

Its working. I tracked that field in "Cross tab - column".
But still i am having the problem to display all the months.

I am using one filter. The filter is Project. It displays the records based on the project. In that Particular project, There are 3 records for Jan, Feb, Mar.

So, it displays the records for only 3 months.

If the month is not having a value then by default it is hidden.

Same Problem Jason.

Can you help me any other way.

Thank you once again for your effort on this.

Regards,
Jeyinul.

Re: Missing column [message #714499 is a reply to message #714344]

Wed, 10 August 2011 12:36

Eclipse User

Did you use the computed column in the data cube and set its type to
date/time? Make sure you have the cross tab set to show empty values.
Look at Empty Rows/Columns property in the property editor. If you have
some way to reproduce the issue it would be better.

Jason

On 8/10/2011 7:30 AM, jeyinul wrote:
> Thanks Jason,
>
> Its working. I tracked that field in "Cross tab - column". But still i
> am having the problem to display all the months.
>
> I am using one filter. The filter is Project. It displays the records
> based on the project. In that Particular project, There are 3 records
> for Jan, Feb, Mar.
>
> So, it displays the records for only 3 months.
>
> If the month is not having a value then by default it is hidden.
>
> Same Problem Jason.
>
> Can you help me any other way.
>
> Thank you once again for your effort on this.
>
> Regards,
> Jeyinul.

Previous Topic:	Birt Report with scripted dataset, Rptdesign Preview issue
Next Topic:	Birt in a WebApp

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 17:04:05 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter