New feature request
 Crystal Reports Forum : General Information : New feature request
Message Icon Topic: Bar Chart Fixing Column/bar width dynamically Post Reply Post New Topic
Author Message
amitk
Newbie
Newbie


Joined: 18 Jan 2009
Location: India
Online Status: Offline
Posts: 5
Quote amitk Replybullet Topic: Bar Chart Fixing Column/bar width dynamically
    Posted: 18 Jan 2009 at 11:24pm

I am facing problem with bar chart as the size of bar is so large when data is available for one country/column.

when we set it using overlap & gap width property as small bar it looks very small when countries/columns are larger in number.

How we can fix the Bar size dynamically so it looks good on reports when ever values shown are small or larger in numbers.

Question

 

 

Regards,
Amitk
IP IP Logged
Ammu Thomas
Newbie
Newbie


Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
Quote Ammu Thomas Replybullet Posted: 02 Feb 2009 at 4:19am
Hi,
I am also facing the similar kind of  problem like ,i would like to have the fixed bar size for the stacked bar report .But in my report , the bar size is varying depends on the no of divisions on x axis.Is it possible to  have the fixed Bar size  by setting 'overlap & gap width property' ?If so how to set it?I dont see any option to set the same in Crystal report X1.
 
Regards,
Ammu
Ammu
IP IP Logged
Dan3D
Newbie
Newbie


Joined: 25 Feb 2007
Location: United States
Online Status: Offline
Posts: 33
Quote Dan3D Replybullet Posted: 09 Feb 2009 at 11:32pm
If all else fails, this capability is built into our CRChart add-in product for Crystal Reports.
 
-Dan
 
DISCLAIMER: I work for the company threedgraphics.com, that makes this product. This product costs money.
IP IP Logged
Ammu Thomas
Newbie
Newbie


Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
Quote Ammu Thomas Replybullet Posted: 10 Feb 2009 at 12:34am
Hi Dan,
i  would like to know whether we can achieve my requirement(Fixed Bar Size) with crystal report XI Developer.
Ammu
IP IP Logged
Dan3D
Newbie
Newbie


Joined: 25 Feb 2007
Location: United States
Online Status: Offline
Posts: 33
Quote Dan3D Replybullet Posted: 10 Feb 2009 at 12:42am
Hi Ammu,
 
I do not know how to do this with "standard" CR XI Developer.
It CAN be done if you happen to purchase my CRChart plug-in.  I created a number of special macros, like @MIN_GROUPS, just to solve these kind of issues.
 
 
-Dan
IP IP Logged
Ammu Thomas
Newbie
Newbie


Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
Quote Ammu Thomas Replybullet Posted: 10 Feb 2009 at 12:49am
Hi Dan,
 could you provide a sample example what you have done , so that it would help me to recommand to buy the product.
Regards,
smitha
Ammu
IP IP Logged
Dan3D
Newbie
Newbie


Joined: 25 Feb 2007
Location: United States
Online Status: Offline
Posts: 33
Quote Dan3D Replybullet Posted: 10 Feb 2009 at 12:56am
I suggest you download the free demo version of our software and play with some of the macros like @MIN_GROUPS. In 5 minutes you will probably solve a number of graph issues that will hopefully make your bosses want to purchase the software!
 
-Dan
 
IP IP Logged
Ammu Thomas
Newbie
Newbie


Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
Quote Ammu Thomas Replybullet Posted: 10 Feb 2009 at 1:33am
Hi DAN,
I had a look at the site.The example is showing different bar size for different groups With the @MIN_GROUPS macro.
 
Ammu
IP IP Logged
amitk
Newbie
Newbie


Joined: 18 Jan 2009
Location: India
Online Status: Offline
Posts: 5
Quote amitk Replybullet Posted: 10 Feb 2009 at 2:12am

Hi Dan/Ammu,

I have checked that macro its working fine but i have to purchase that DLL that’s increasing cost.

 

So currently I am using the following solution.

 

You could create multiple charts, each placed in its own section where you adjust the bar width depending upon how many "on change of" values there might be and also conditionally suppress the section on the same basis, e.g.,

distinctcount({table.onchgoffield}) < 3

 

It will used to avoid the large size bar when data is available for less then three value.



Edited by amitk - 10 Feb 2009 at 2:12am
Regards,
Amitk
IP IP Logged
Ammu Thomas
Newbie
Newbie


Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
Quote Ammu Thomas Replybullet Posted: 10 Feb 2009 at 2:17am
Hi Amit,
Thnaks for you r reply.I had thought about the soluntion what you have told me.But it can not be applicable in m y case as i have to go for more than 5 graphs.Another problem is that in one rpt file itself has more than 3 graphs.
 
Regards,
smitha
Ammu
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.018 seconds.