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

Converting from Spreadsheet reporting to SSRS Expand / Collapse
Author
Message
Posted Tuesday, August 14, 2012 10:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 10:33 AM
Points: 45, Visits: 127
I am in the process on trying to convert a bunch of our monthly reports from Excel Spreadsheets to SSRS reports. I have attached a picture of what I am trying to go from and what I have currently have in SSRS.

The top is Excel, I have everything in my query and new report except for the graphing. Is this even possible? I can add a bar graph instead to the report, but I don't think I can get the % to Goal column on the graph or can I?

Thanks for any pointers or help.

Tim


  Post Attachments 
ReportHelp.jpg (35 views, 32.34 KB)
Post #1344852
Posted Tuesday, August 14, 2012 12:19 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 10:33 AM
Points: 45, Visits: 127
I ended up continuing to mess with this through lunch and got my Chart to do what I needed. But it does bring up a second question now. Is it possible to keep the size of the series the same no matter how many people are on the list?

We have 4 teams that I am going to be outputting this report for and they range in size from 8 members down to 3 currently. The team with 3 has these large bars that graph out their numbers. I would like them to all be the same size.

Now to fine tune colors and such to keep the marketing folks happy....
Post #1344948
Posted Tuesday, August 14, 2012 1:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 10:33 AM
Points: 45, Visits: 127
Guess I should have kept playing before replying to my own post, for others here is the answer on the sizing:

Click on the Series in your chart, select Custom Attributes and there is a MaxPixels property. Set that to whatever number you want, and it will only be that big. I think PointWidth also has something to do with it, default value for it is 0.8.

Sorry for the noise, but I learned something. Hopefully someone else might also.
Post #1344987
Posted Wednesday, August 15, 2012 4:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 18, 2014 10:57 AM
Points: 2,112, Visits: 3,712
TimParker (8/14/2012)
Hopefully someone else might also.


Cheers Tim, thanks for posting your solution.
Post #1345200
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse