Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vani_r14
Starting Member
24 Posts |
 Posted - 2009-07-12 : 18:54:25
|
| Hi I am trying to create a report with bar / column chart for multiple database in a sql server instance to find out the maximum user connection that has occured for each month over the period of 6 months. The graph has two categories and one value axis. Category axis includes the database names and months and value axis includes the maximum no of connections for each month. Each instance can have any no of databases and some instance have 20+ databases. When trying to put them in the chart I find that we are getting the details with the labels correctly for each database when the no is a maximum of 7. if the maximum no of databases exceed 7 to 8 then the graph is drawn but the labels are either missing or incomplete. Can someone please help or point me in the right direction to find out why this is happening.thanks in advanceVani |
|
|
yavvie
Starting Member
46 Posts |
Posted - 2009-07-27 : 09:30:15
|
| In Axis properties on the selected axis you have the first tab - Axis options, where you set the interval of the scale. If it is set to Auto then the report itself chooses what to display, so you have to set there the right interval to be displayed - in your case it should be 1 (maybe it will require you to play with it a bit but it should be here) |
 |
|
|
freezea
Starting Member
5 Posts |
Posted - 2009-09-09 : 14:22:01
|
Hi, vani_r14.You can use RAQ Report. With it, you can make chart easily. Examples are shown below:  If you want, you can get it freely at http://www.raqsoft.com/.Welcome to my blog at http://freezea.blogspot.com/. |
|
|
|
|
|
|
Charts Not displaying all labels