Using @@RowCount with Report Writer

mcalpinj

@RowCount.

The output from the query displays the node name, the IP address, the number of interfaces on that node, and lastly, the total count of interfaces retrieved from the query.  This last one is the column where I am only displaying zero on the web page.

Why would it work correctly in the Report Writer but not display that way on the web page?

Below is the query;

Select
    Nodes.NodeID,
    Nodes.SysName,
    Nodes.IP_Address,
    Count(*)   As NumOfInterfaces,
@RowCount As TotalInterfaces
From
    dbo.Nodes   Nodes,
    dbo.Interfaces   Interfaces
Where (
            Interfaces.NodeID = Nodes.NodeID
)
 
And (
     ( Nodes.IP_Address LIKE '10.2.100.%' )
    Or ( Nodes.IP_Address LIKE '10.2.102.%' )
    Or ( Nodes.IP_Address LIKE '10.2.104.%' )
    )
Group by
    Nodes.IP_Address,
    Nodes.SysName,
    Nodes.NodeID
Order by
    Nodes.SysName Asc, Nodes.IP_Address Asc
;