Bar Chart Fixing Column/bar width dynamically
Printed From: Crystal Reports Book
Category: General Information
Forum Name: New feature request
Forum Discription: Share what features you want to see in the next release of Crystal Reports.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5251
Printed Date: 02 May 2024 at 11:30pm
Topic: Bar Chart Fixing Column/bar width dynamically
Posted By: amitk
Subject: Bar Chart Fixing Column/bar width dynamically
Date 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 |
Replies:
Posted By: Ammu Thomas
Date 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 |
Posted By: Dan3D
Date 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.
|
Posted By: Ammu Thomas
Date 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 |
Posted By: Dan3D
Date 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.
http://threedgraphics.com/tdg/products/tools/crchart/html_docs/docs/min_groups.htm - http://threedgraphics.com/tdg/products/tools/crchart/html_docs/docs/min_groups.htm
-Dan
|
Posted By: Ammu Thomas
Date 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 |
Posted By: Dan3D
Date 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
|
Posted By: Ammu Thomas
Date 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 |
Posted By: amitk
Date 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., It will used to avoid the large size bar when data is available for less then three value. ------------- Regards, Amitk |
Posted By: Ammu Thomas
Date 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 |