Home » Archived » BIRT » Cannot adjust the X-axis Attributes
| Cannot adjust the X-axis Attributes [message #66179] |
Tue, 09 August 2005 13:32  |
Eclipse User |
|
|
|
Originally posted by: statineni.issintl.com
Hello ,
Iam created a Chart and got the values inserted from the DataSet.
All the values are mixed up on Xaxis they are comming up as one line.Can
some one tell me how i can provide space between these values on Xaxis.I
checked entire "Chart Dialog" and i cannot find anything realated to it.
Appreciate quick response.
Thanks,
Sudha
|
|
|
| Re: Cannot adjust the X-axis Attributes [message #66221 is a reply to message #66179] |
Tue, 09 August 2005 16:14  |
| Eclipse User |
|
|
|
Hi Sudha,
A screenshot would help, but I understand you have too many labels and they
overlap. The best solution for now is to rotate them vertically. If you
would be interested in a new feature like label staggering or automatic drop
of some labels, please file a bugzilla enhancement for it.
To rotate the labels, follow those instructions (from another thread):
"You could go to Chart builder -> Attributes -> X Axis -> Labels, then
you'll
find a button beside the Label grid -> Font. Click the button to invoke Font
Descriptor, there is an attribute named Rotation. By changing the value of
rotation, You could set the X-Axis label to be vertically or arbitrary angle
you like."
Thanks,
David
"Sudha Tatineni" <statineni@issintl.com> wrote in message
news:24a7e9d50cae0aebc6968b25bdd1c921$1@www.eclipse.org...
> Hello ,
>
> Iam created a Chart and got the values inserted from the DataSet.
> All the values are mixed up on Xaxis they are comming up as one line.Can
> some one tell me how i can provide space between these values on Xaxis.I
> checked entire "Chart Dialog" and i cannot find anything realated to it.
>
>
> Appreciate quick response.
> Thanks,
> Sudha
>
|
|
|
| Re: Cannot adjust the X-axis Attributes [message #66499 is a reply to message #66221] |
Wed, 10 August 2005 10:09 |
| Eclipse User |
|
|
|
Originally posted by: statineni.issintl.com
Hello David,
I am able to rotate the X.axis attirbutes. Thanks !!
I got one more doubt.
I have 'Month_year' column whose datatype is 'datetime' in SQL server
table and the values i entered in that column are in the formatll be like
'12/1/2004'. But when i used this "Month_Year" column in BIRT iam getting
the time stamp too.
Example :
Iam getting the format as "12/1/2004 00:00:00"
I want it in the format "Dec 2005 " but it will show in the column as
'12/1/2005'and no time stamp beside it.
I dont have facility in the SQL Server2000 other than
'datetime','smalldatetime' and 'timestamp' datatypes.
So can i use expression builder to get the format i want ?.If so HOw can i
use it.Could you send me the sample.Could you please send me your email to
send the screen shots.
Thanks
Sudha
David Michonneau wrote:
> Hi Sudha,
> A screenshot would help, but I understand you have too many labels and they
> overlap. The best solution for now is to rotate them vertically. If you
> would be interested in a new feature like label staggering or automatic drop
> of some labels, please file a bugzilla enhancement for it.
> To rotate the labels, follow those instructions (from another thread):
> "You could go to Chart builder -> Attributes -> X Axis -> Labels, then
> you'll
> find a button beside the Label grid -> Font. Click the button to invoke Font
> Descriptor, there is an attribute named Rotation. By changing the value off
> rotation, You could set the X-Axis label to be vertically or arbitrary angle
> you like."
> Thanks,
> David
> "Sudha Tatineni" <statineni@issintl.com> wrote in message
> news:24a7e9d50cae0aebc6968b25bdd1c921$1@www.eclipse.org...
>> Hello ,
>>
>> Iam created a Chart and got the values inserted from the DataSet.
>> All the values are mixed up on Xaxis they are comming up as one line.Can
>> some one tell me how i can provide space between these values on Xaxis.I
>> checked entire "Chart Dialog" and i cannot find anything realated to it.
>>
>>
>> Appreciate quick response.
>> Thanks,
>> Sudha
>>
Hello David,
Here is the screen shot
|
|
|
| Re: Cannot adjust the X-axis Attributes [message #66520 is a reply to message #66499] |
Wed, 10 August 2005 10:35 |
| Eclipse User |
|
|
|
Sudha,
There are several formatting options for datetime values. Where are you
using it? If it's an chart you can invoke the format specifier by clicking
on the 0.0# button next to the Data Definition. If it's in a data element,
you can go to the property editor view and select Format DateTime in the
properties tab.
Hope this helps,
David
"Sudha Tatineni" <statineni@issintl.com> wrote in message
news:9c60f2be496c583b7a885fa6ab14c37b$1@www.eclipse.org...
> Hello David,
>
> I am able to rotate the X.axis attirbutes. Thanks !!
> I got one more doubt.
>
> I have 'Month_year' column whose datatype is 'datetime' in SQL server
> table and the values i entered in that column are in the formatll be like
> '12/1/2004'. But when i used this "Month_Year" column in BIRT iam getting
> the time stamp too.
>
> Example :
>
> Iam getting the format as "12/1/2004 00:00:00"
> I want it in the format "Dec 2005 " but it will show in the column as
> '12/1/2005'and no time stamp beside it.
> I dont have facility in the SQL Server2000 other than
> 'datetime','smalldatetime' and 'timestamp' datatypes.
>
> So can i use expression builder to get the format i want ?.If so HOw can i
> use it.Could you send me the sample.Could you please send me your email to
> send the screen shots.
>
> Thanks
> Sudha
>
> David Michonneau wrote:
>
>> Hi Sudha,
>
>> A screenshot would help, but I understand you have too many labels and
>> they overlap. The best solution for now is to rotate them vertically. If
>> you would be interested in a new feature like label staggering or
>> automatic drop of some labels, please file a bugzilla enhancement for it.
>
>> To rotate the labels, follow those instructions (from another thread):
>> "You could go to Chart builder -> Attributes -> X Axis -> Labels, then
>> you'll
>> find a button beside the Label grid -> Font. Click the button to invoke
>> Font
>> Descriptor, there is an attribute named Rotation. By changing the value
>> off
>> rotation, You could set the X-Axis label to be vertically or arbitrary
>> angle
>> you like."
>
>> Thanks,
>
>> David
>
>> "Sudha Tatineni" <statineni@issintl.com> wrote in message
>> news:24a7e9d50cae0aebc6968b25bdd1c921$1@www.eclipse.org...
>>> Hello ,
>>>
>>> Iam created a Chart and got the values inserted from the DataSet.
>>> All the values are mixed up on Xaxis they are comming up as one line.Can
>>> some one tell me how i can provide space between these values on Xaxis.I
>>> checked entire "Chart Dialog" and i cannot find anything realated to it.
>>>
>>>
>>> Appreciate quick response.
>>> Thanks,
>>> Sudha
>>>
> Hello David,
>
> Here is the screen shot
>
>
>
|
|
|
| Re: Cannot adjust the X-axis Attributes [message #66540 is a reply to message #66520] |
Wed, 10 August 2005 11:17 |
| Eclipse User |
|
|
|
Originally posted by: statineni.issintl.com
David,
There will be several Dates like "05/1/2005 00:00:00" , "04/1/2005
00:00:00" on X-axis and cost values on Y axis.
Now my point is I want them as " May 05 " instead of "05/1/2005 00:00:00".
The value in SQLServer table is in the format '12/1/2004' under
"Month_Year" column with datatype "dateTime". So when iam trying to use
this column in chart x-axis the format is comming up like "05/1/2005
00:00:00" instead of " May 05 ". Is there any way to convert it ?
I tried 0.0 button and changed the value to datetime from number but no
luck. I dont understand how to set it in property editor view because it
is going to expression builder and when i dragged and dropped "getMonth()"
method from date functions i dont see any change. May be i need to code
properly apart from dragging and dropping "getMonth()" function onto
expression area.
Hope you got me.
Sudha.
David Michonneau wrote:
> Sudha,
> There are several formatting options for datetime values. Where are you
> using it? If it's an chart you can invoke the format specifier by clicking
> on the 0.0# button next to the Data Definition. If it's in a data element,
> you can go to the property editor view and select Format DateTime in the
> properties tab.
> Hope this helps,
> David
> "Sudha Tatineni" <statineni@issintl.com> wrote in message
> news:9c60f2be496c583b7a885fa6ab14c37b$1@www.eclipse.org...
>> Hello David,
>>
>> I am able to rotate the X.axis attirbutes. Thanks !!
>> I got one more doubt.
>>
>> I have 'Month_year' column whose datatype is 'datetime' in SQL server
>> table and the values i entered in that column are in the formatll be like
>> '12/1/2004'. But when i used this "Month_Year" column in BIRT iam getting
>> the time stamp too.
>>
>> Example :
>>
>> Iam getting the format as "12/1/2004 00:00:00"
>> I want it in the format "Dec 2005 " but it will show in the column as
>> '12/1/2005'and no time stamp beside it.
>> I dont have facility in the SQL Server2000 other than
>> 'datetime','smalldatetime' and 'timestamp' datatypes.
>>
>> So can i use expression builder to get the format i want ?.If so HOw can i
>> use it.Could you send me the sample.Could you please send me your email to
>> send the screen shots.
>>
>> Thanks
>> Sudha
>>
>> David Michonneau wrote:
>>
>>> Hi Sudha,
>>
>>> A screenshot would help, but I understand you have too many labels and
>>> they overlap. The best solution for now is to rotate them vertically. If
>>> you would be interested in a new feature like label staggering or
>>> automatic drop of some labels, please file a bugzilla enhancement for it.
>>
>>> To rotate the labels, follow those instructions (from another thread):
>>> "You could go to Chart builder -> Attributes -> X Axis -> Labels, then
>>> you'll
>>> find a button beside the Label grid -> Font. Click the button to invoke
>>> Font
>>> Descriptor, there is an attribute named Rotation. By changing the value
>>> off
>>> rotation, You could set the X-Axis label to be vertically or arbitrary
>>> angle
>>> you like."
>>
>>> Thanks,
>>
>>> David
>>
>>> "Sudha Tatineni" <statineni@issintl.com> wrote in message
>>> news:24a7e9d50cae0aebc6968b25bdd1c921$1@www.eclipse.org...
>>>> Hello ,
>>>>
>>>> Iam created a Chart and got the values inserted from the DataSet.
>>>> All the values are mixed up on Xaxis they are comming up as one line.Can
>>>> some one tell me how i can provide space between these values on Xaxis.I
>>>> checked entire "Chart Dialog" and i cannot find anything realated to it.
>>>>
>>>>
>>>> Appreciate quick response.
>>>> Thanks,
>>>> Sudha
>>>>
>> Hello David,
>>
>> Here is the screen shot
>>
>>
>>
|
|
|
| Re: Cannot adjust the X-axis Attributes [message #66665 is a reply to message #66540] |
Wed, 10 August 2005 22:23 |
| Eclipse User |
|
|
|
Sudha,
Please try the following steps:
Invoke Chart Dialog -> Data -> X Axis; Set Type: DataTime, then invoke the
0.0# button next to the field.
In Format Specifier -Base Axis dialog, Set Data Type: Date/Time, then go to
Advanced, Set Pattern: MMM dd
Hope it is what you want.
Cheers.
Regards,
Nina
"Sudha Tatineni" <statineni@issintl.com> wrote in message
news:cd6fe9bd467ddcaeee13e4beebe0591b$1@www.eclipse.org...
> David,
>
> There will be several Dates like "05/1/2005 00:00:00" , "04/1/2005
> 00:00:00" on X-axis and cost values on Y axis.
>
> Now my point is I want them as " May 05 " instead of "05/1/2005 00:00:00".
> The value in SQLServer table is in the format '12/1/2004' under
> "Month_Year" column with datatype "dateTime". So when iam trying to use
> this column in chart x-axis the format is comming up like "05/1/2005
> 00:00:00" instead of " May 05 ". Is there any way to convert it ?
>
> I tried 0.0 button and changed the value to datetime from number but no
> luck. I dont understand how to set it in property editor view because it
> is going to expression builder and when i dragged and dropped "getMonth()"
> method from date functions i dont see any change. May be i need to code
> properly apart from dragging and dropping "getMonth()" function onto
> expression area.
>
> Hope you got me.
> Sudha.
>
> David Michonneau wrote:
>
>> Sudha,
>
>> There are several formatting options for datetime values. Where are you
>> using it? If it's an chart you can invoke the format specifier by
>> clicking on the 0.0# button next to the Data Definition. If it's in a
>> data element, you can go to the property editor view and select Format
>> DateTime in the properties tab.
>
>> Hope this helps,
>
>> David
>
>> "Sudha Tatineni" <statineni@issintl.com> wrote in message
>> news:9c60f2be496c583b7a885fa6ab14c37b$1@www.eclipse.org...
>>> Hello David,
>>>
>>> I am able to rotate the X.axis attirbutes. Thanks !!
>>> I got one more doubt.
>>>
>>> I have 'Month_year' column whose datatype is 'datetime' in SQL server
>>> table and the values i entered in that column are in the formatll be
>>> like '12/1/2004'. But when i used this "Month_Year" column in BIRT iam
>>> getting the time stamp too.
>>>
>>> Example :
>>>
>>> Iam getting the format as "12/1/2004 00:00:00"
>>> I want it in the format "Dec 2005 " but it will show in the column as
>>> '12/1/2005'and no time stamp beside it.
>>> I dont have facility in the SQL Server2000 other than
>>> 'datetime','smalldatetime' and 'timestamp' datatypes.
>>>
>>> So can i use expression builder to get the format i want ?.If so HOw can
>>> i use it.Could you send me the sample.Could you please send me your
>>> email to send the screen shots.
>>>
>>> Thanks
>>> Sudha
>>>
>>> David Michonneau wrote:
>>>
>>>> Hi Sudha,
>>>
>>>> A screenshot would help, but I understand you have too many labels and
>>>> they overlap. The best solution for now is to rotate them vertically.
>>>> If you would be interested in a new feature like label staggering or
>>>> automatic drop of some labels, please file a bugzilla enhancement for
>>>> it.
>>>
>>>> To rotate the labels, follow those instructions (from another thread):
>>>> "You could go to Chart builder -> Attributes -> X Axis -> Labels, then
>>>> you'll
>>>> find a button beside the Label grid -> Font. Click the button to invoke
>>>> Font
>>>> Descriptor, there is an attribute named Rotation. By changing the value
>>>> off
>>>> rotation, You could set the X-Axis label to be vertically or arbitrary
>>>> angle
>>>> you like."
>>>
>>>> Thanks,
>>>
>>>> David
>>>
>>>> "Sudha Tatineni" <statineni@issintl.com> wrote in message
>>>> news:24a7e9d50cae0aebc6968b25bdd1c921$1@www.eclipse.org...
>>>>> Hello ,
>>>>>
>>>>> Iam created a Chart and got the values inserted from the DataSet.
>>>>> All the values are mixed up on Xaxis they are comming up as one
>>>>> line.Can some one tell me how i can provide space between these values
>>>>> on Xaxis.I checked entire "Chart Dialog" and i cannot find anything
>>>>> realated to it.
>>>>>
>>>>>
>>>>> Appreciate quick response.
>>>>> Thanks,
>>>>> Sudha
>>>>>
>>> Hello David,
>>>
>>> Here is the screen shot
>>>
>>>
>>>
>
>
|
|
|
| Solved - Re: Cannot adjust the X-axis Attributes [message #66814 is a reply to message #66665] |
Thu, 11 August 2005 11:02 |
| Eclipse User |
|
|
|
Originally posted by: statineni.issintl.com
Nina,
Great Thanks a lot!!!!!.
I did a slight change in the advanced pattern instead of "MMM DD" i gave
it as "MMM yy".
Regards,
Sudha.
Nina Li wrote:
> Sudha,
> Please try the following steps:
> Invoke Chart Dialog -> Data -> X Axis; Set Type: DataTime, then invoke the
> 0.0# button next to the field.
> In Format Specifier -Base Axis dialog, Set Data Type: Date/Time, then go to
> Advanced, Set Pattern: MMM dd
> Hope it is what you want.
> Cheers.
> Regards,
> Nina
> "Sudha Tatineni" <statineni@issintl.com> wrote in message
> news:cd6fe9bd467ddcaeee13e4beebe0591b$1@www.eclipse.org...
>> David,
>>
>> There will be several Dates like "05/1/2005 00:00:00" , "04/1/2005
>> 00:00:00" on X-axis and cost values on Y axis.
>>
>> Now my point is I want them as " May 05 " instead of "05/1/2005 00:00:00".
>> The value in SQLServer table is in the format '12/1/2004' under
>> "Month_Year" column with datatype "dateTime". So when iam trying to use
>> this column in chart x-axis the format is comming up like "05/1/2005
>> 00:00:00" instead of " May 05 ". Is there any way to convert it ?
>>
>> I tried 0.0 button and changed the value to datetime from number but no
>> luck. I dont understand how to set it in property editor view because it
>> is going to expression builder and when i dragged and dropped "getMonth()"
>> method from date functions i dont see any change. May be i need to code
>> properly apart from dragging and dropping "getMonth()" function onto
>> expression area.
>>
>> Hope you got me.
>> Sudha.
>>
>> David Michonneau wrote:
>>
>>> Sudha,
>>
>>> There are several formatting options for datetime values. Where are you
>>> using it? If it's an chart you can invoke the format specifier by
>>> clicking on the 0.0# button next to the Data Definition. If it's in a
>>> data element, you can go to the property editor view and select Format
>>> DateTime in the properties tab.
>>
>>> Hope this helps,
>>
>>> David
>>
>>> "Sudha Tatineni" <statineni@issintl.com> wrote in message
>>> news:9c60f2be496c583b7a885fa6ab14c37b$1@www.eclipse.org...
>>>> Hello David,
>>>>
>>>> I am able to rotate the X.axis attirbutes. Thanks !!
>>>> I got one more doubt.
>>>>
>>>> I have 'Month_year' column whose datatype is 'datetime' in SQL server
>>>> table and the values i entered in that column are in the formatll be
>>>> like '12/1/2004'. But when i used this "Month_Year" column in BIRT iam
>>>> getting the time stamp too.
>>>>
>>>> Example :
>>>>
>>>> Iam getting the format as "12/1/2004 00:00:00"
>>>> I want it in the format "Dec 2005 " but it will show in the column as
>>>> '12/1/2005'and no time stamp beside it.
>>>> I dont have facility in the SQL Server2000 other than
>>>> 'datetime','smalldatetime' and 'timestamp' datatypes.
>>>>
>>>> So can i use expression builder to get the format i want ?.If so HOw can
>>>> i use it.Could you send me the sample.Could you please send me your
>>>> email to send the screen shots.
>>>>
>>>> Thanks
>>>> Sudha
>>>>
>>>> David Michonneau wrote:
>>>>
>>>>> Hi Sudha,
>>>>
>>>>> A screenshot would help, but I understand you have too many labels and
>>>>> they overlap. The best solution for now is to rotate them vertically.
>>>>> If you would be interested in a new feature like label staggering or
>>>>> automatic drop of some labels, please file a bugzilla enhancement for
>>>>> it.
>>>>
>>>>> To rotate the labels, follow those instructions (from another thread):
>>>>> "You could go to Chart builder -> Attributes -> X Axis -> Labels, then
>>>>> you'll
>>>>> find a button beside the Label grid -> Font. Click the button to invoke
>>>>> Font
>>>>> Descriptor, there is an attribute named Rotation. By changing the value
>>>>> off
>>>>> rotation, You could set the X-Axis label to be vertically or arbitrary
>>>>> angle
>>>>> you like."
>>>>
>>>>> Thanks,
>>>>
>>>>> David
>>>>
>>>>> "Sudha Tatineni" <statineni@issintl.com> wrote in message
>>>>> news:24a7e9d50cae0aebc6968b25bdd1c921$1@www.eclipse.org...
>>>>>> Hello ,
>>>>>>
>>>>>> Iam created a Chart and got the values inserted from the DataSet.
>>>>>> All the values are mixed up on Xaxis they are comming up as one
>>>>>> line.Can some one tell me how i can provide space between these values
>>>>>> on Xaxis.I checked entire "Chart Dialog" and i cannot find anything
>>>>>> realated to it.
>>>>>>
>>>>>>
>>>>>> Appreciate quick response.
>>>>>> Thanks,
>>>>>> Sudha
>>>>>>
>>>> Hello David,
>>>>
>>>> Here is the screen shot
>>>>
>>>>
>>>>
>>
>>
|
|
|
Goto Forum:
Current Time: Mon May 05 01:50:14 EDT 2025
Powered by FUDForum. Page generated in 0.05580 seconds |
Home