As a SQL Noob, what would I need to do to add a total count of nodes to say the Asset Inventory Report?
Thanks for any help!
Did you get anywhere with this?
Try this
Thanks for your reply bobmarley. This just shows a number 1 next to each node in the column rather than the total listed.
I want the report to show specific down nodes (which i've got to work) and display somewhere on the report, how many are on the list....
Can't seem to find it anywhere.
:S
Put up a screenshot of Select Fields, Filter Results, and Field Formatting and maybe we can figure it out.
@matt_rees In the web based report writer it would just be a matter of adding a datasource, choosing a custom table
and then using the below query as your selection
SELECT COUNT(NodeID) AS 'Count Of Down Nodes' FROM [dbo].[Nodes]
WHERE Status = '2'
This one is cool : web report + sql = awesome!
jvb thanks for this and your help! That's definitely progress. My only problem now is that it is displaying ALL down nodes and not how many are actually on that specific report. I have a custom property in place to only show me specified down nodes, is there a way to count the number that the report lists?
