| Author |
Message |
amitk
Newbie
Joined: 18 Jan 2009
Location: India
Online Status: Offline
Posts: 5
|
   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.
|
|
Regards,
Amitk
|
 IP Logged |
|
|
Ammu Thomas
Newbie
Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
|
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 Logged |
|
Dan3D
Newbie
Joined: 25 Feb 2007
Location: United States
Online Status: Offline
Posts: 33
|
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 Logged |
|
Ammu Thomas
Newbie
Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
|
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 Logged |
|
Dan3D
Newbie
Joined: 25 Feb 2007
Location: United States
Online Status: Offline
Posts: 33
|
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 Logged |
|
Ammu Thomas
Newbie
Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
|
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 Logged |
|
Dan3D
Newbie
Joined: 25 Feb 2007
Location: United States
Online Status: Offline
Posts: 33
|
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 Logged |
|
Ammu Thomas
Newbie
Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
|
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 Logged |
|
amitk
Newbie
Joined: 18 Jan 2009
Location: India
Online Status: Offline
Posts: 5
|
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 Logged |
|
Ammu Thomas
Newbie
Joined: 02 Feb 2009
Location: India
Online Status: Offline
Posts: 6
|
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 Logged |
|
|
|
