COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: koolbachi on 14 Feb 2006 05:29:12 AM

Title: I want know in report studio whether we can change the X-axis label to display
Post by: koolbachi on 14 Feb 2006 05:29:12 AM
Hi everybody,

Sorry for my previous query.

Bekow is the client reuqirement:
I want know in report studio whether we can change the X-axis label to  display vertically.

Thanks
Title: Re: I want know in report studio whether we can change the X-axis label to disp
Post by: mikegreen on 14 Feb 2006 07:57:57 PM
Can you take a screenshot of what you have and note what you want rotated vertically?

Are you trying to force the x axis (horizontal) to be 90 degrees all the time?

Title: Re: I want know in report studio whether we can change the X-axis label to display
Post by: koolbachi on 14 Feb 2006 08:13:09 PM
Thanks ,

Actually i want to keep the label in X-axis shloud be  displayed always vertically.

regards
Title: Re: I want know in report studio whether we can change the X-axis label to disp
Post by: mikegreen on 14 Feb 2006 08:26:27 PM
I posted a topic on this a few weeks ago actually... I wanted to force it to display the x-axis at 45 degrees always...

If I turn off stagger, skip, rotate 45, truncate, and leave on rotate 90 I am able to space-pad my data item on the front end to make it not go horizontal (regular text-like) and do the 90 degree rotation....
Title: Re: I want know in report studio whether we can change the X-axis label to display
Post by: koolbachi on 15 Feb 2006 01:34:22 PM
 I tired but not happening .

Could you please update.

Like in X-Axis i have label ( Query item = name) is shown horizontal.

I want it to show vertically label.

Its a combination chart.

Thanks
Title: Re: I want know in report studio whether we can change the X-axis label to disp
Post by: mikegreen on 15 Feb 2006 04:57:09 PM
Can you take a screenshot of what you have and note what you want rotated vertically?
Title: Re: I want know in report studio whether we can change the X-axis label to display
Post by: koolbachi on 18 Feb 2006 12:56:27 AM
Thanks for ur reply...


But if Take the X-axis label like date.....i want to show label vertical because there is lot of data if i show label i will be able to get the graph neatly...

thanks
Title: Re: I want know in report studio whether we can change the X-axis label to disp
Post by: mikegreen on 18 Feb 2006 12:10:27 PM
If there is enough data to make it look cluttered, then it should be rotating 90 degrees pending you have it set not to skip/stagger/rotate 45....

Like I said before, take a screenshot and post it so we are all on the same page.
Title: Re: I want know in report studio whether we can change the X-axis label to display
Post by: koolbachi on 20 Feb 2006 09:37:29 AM
Hi all ,

I have attached the chart ,....

The first is the output presently i a getting .....but i needs to get the output given in the second chart......

Please look in X-axis Label...which vertical in Second chart...

Urgent

Thanks
gops
Title: Re: I want know in report studio whether we can change the X-axis label to disp
Post by: mikegreen on 20 Feb 2006 09:42:21 AM
Your issue is much clearer now with the image...

CRN is breaking it because it sees the spaces... I would remove the spaces in the item.  Is that an option for you? It appears the similar data below is already space-less.

Cheers,
Mike
Title: Re: I want know in report studio whether we can change the X-axis label to display
Post by: koolbachi on 20 Feb 2006 10:28:36 AM
Thanks mike,

Could you please clearly mention how make the x-aixs label look vertical, as show in the second chart .....

Which will be very helpful for me .....

Please how to get the output show in the second chart...



Thanks
gops
Title: Re: I want know in report studio whether we can change the X-axis label to disp
Post by: mikegreen on 20 Feb 2006 10:34:46 AM
Do you read everything that I am writing here?

"CRN is breaking it because it sees the spaces... I would remove the spaces in the item.  Is that an option for you? It appears the similar data below is already space-less."
Title: Re: I want know in report studio whether we can change the X-axis label to display
Post by: koolbachi on 20 Feb 2006 10:47:24 AM
Hey Mike ,

sorry to say that i am not getting what you want to say....

Its breaking because CRN is having space in between the items....

I want to know that whether i can get the label vertical...in X-axis.

Please briefy on the stepsthat...need you help.

Thanks
gops
Title: Re: I want know in report studio whether we can change the X-axis label to disp
Post by: mikegreen on 20 Feb 2006 10:51:29 AM
CRN is LINE BREAKING the text into 2 lines. I asked if you can remove the spaces from your data element. That will solve your problem. Consult your DBA to find out what function you can use to remove the spaces in the string/data element.

STEPS:
Remove spaces in your data
Set chart properties to what I posted a few days ago to not stagger/etc
Run report