|
Re: Missing column [message #703435 is a reply to message #703295] |
Wed, 27 July 2011 14:55 |
|
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
|
|
|
|
Re: Missing column [message #705257 is a reply to message #704883] |
Fri, 29 July 2011 15:55 |
|
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 #707355 is a reply to message #707129] |
Mon, 01 August 2011 14:24 |
|
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 08:28 |
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 10:14] Report message to a moderator
|
|
|
|
|
Re: Missing column [message #713990 is a reply to message #713896] |
Tue, 09 August 2011 14:31 |
|
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 #714499 is a reply to message #714344] |
Wed, 10 August 2011 16:36 |
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.03313 seconds