Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Missing column(Missing column)
Missing column [message #703295] Wed, 27 July 2011 07:57 Go to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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


Jason Weathersby

BIRT Exchange
Re: Missing column [message #704883 is a reply to message #703435] Fri, 29 July 2011 03:05 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
Month Column is not datetime.
Its string
Re: Missing column [message #705257 is a reply to message #704883] Fri, 29 July 2011 11:55 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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


Jason Weathersby

BIRT Exchange
Re: Missing column [message #707129 is a reply to message #705257] Mon, 01 August 2011 05:17 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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.


Jason Weathersby

BIRT Exchange
Re: Missing column [message #712426 is a reply to message #707355] Sun, 07 August 2011 04:28 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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]

Report message to a moderator

Re: Missing column [message #713659 is a reply to message #712426] Mon, 08 August 2011 14:28 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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


Jason Weathersby

BIRT Exchange
Re: Missing column [message #713896 is a reply to message #713659] Tue, 09 August 2011 06:30 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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.
>


Jason Weathersby

BIRT Exchange
Re: Missing column [message #714344 is a reply to message #713990] Wed, 10 August 2011 07:30 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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.


Jason Weathersby

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


Current Time: Wed Apr 23 02:42:34 EDT 2014

Powered by FUDForum. Page generated in 0.03505 seconds