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

Possible to create multiple area/line charts with data? Expand / Collapse
Author
Message
Posted Friday, June 14, 2013 12:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 19, 2013 6:42 AM
Points: 3, Visits: 9
My data is:

UID (Unique Identifier)
Username
Timestamp
CPU %

I want to have an area chart or a line chart for each UID. I have about 20,000 rows per day and want to trend the CPU usage per UID. Is that possible without having to create a dataset for each and apply that to a new chart?
Post #1463739
Posted Monday, June 17, 2013 8:23 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:05 AM
Points: 4,427, Visits: 4,178
Yes you can use one dataset for several items (tablix, charts, sparklines etc.) in a report.
If you're using SSRS 2008 R2 or 2012 you can also create a shared dataset to use in different reports.


Markus Bohse
Post #1464170
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse