Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do i get all the month names to display in the report? Expand / Collapse
Author
Message
Posted Wednesday, May 29, 2013 2:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:53 AM
Points: 10, Visits: 24
I've created a report that shows number of visits to our websites by month. However, its not showing the month names for each month, only january, november and january. How do I show every month number? There is visits(data) every month since Jan 2011 to present. I've included screen shots to help explain

  Post Attachments 
Graph.jpg (10 views, 63.85 KB)
ChartGroups.jpg (7 views, 29.81 KB)
Horizontal Axis labels.jpg (5 views, 53.82 KB)
Horizontal Axis options.jpg (5 views, 54.34 KB)
Post #1457609
Posted Wednesday, May 29, 2013 3:50 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 3:36 AM
Points: 407, Visits: 383
Check the Data, whether you have a data for said months, if there is a data it should reflect in graph too..
Post #1457639
Posted Wednesday, May 29, 2013 4:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:53 AM
Points: 10, Visits: 24
Yeah I have data and I have enough columns for all the months i have data, it just doesn't display the labels next to the columns. Any ideas how i can get the month names next to the labels?
Post #1457655
Posted Wednesday, May 29, 2013 5:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 6:14 AM
Points: 2, Visits: 335
Under the horizontal axis options try changing the interval from auto to 1
Post #1457679
Posted Wednesday, May 29, 2013 6:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:53 AM
Points: 10, Visits: 24
Thanks that works great Now the month names are displaying in alphabetical order (April, August....October September), how do i get them to display correct order?

  Post Attachments 
datesWrongOrder.jpg (6 views, 64.14 KB)
Post #1457689
Posted Wednesday, May 29, 2013 2:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 6:14 AM
Points: 2, Visits: 335
Most Calendar tables I've worked with have column that numbers months so you can select out that column and sort on it under your category groups. If you don't have that then you could build your own sort in your code. Something like this:
DISTINCT CASE cal_month_name WHEN 'January' THEN 1
WHEN 'February' THEN 2
WHEN 'March' THEN 3
WHEN 'April' THEN 4
WHEN 'May' THEN 5
WHEN 'June' THEN 6
WHEN 'July' THEN 7
WHEN 'August' THEN 8
WHEN 'September' THEN 9
WHEN 'October' THEN 10
WHEN 'November' THEN 11
WHEN 'December' THEN 12 ELSE 13 END AS CalSort
Post #1457957
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse