sql server reporting services: I need to count the number of row returned on the query
@@rowcount would seem to work
But I need to be able to use this number in the report
How do I turn this is to a useable Field???

sorry Im no delevoper, Im sure it's easy but Ive hacked a round a bit and
still NG

thanks

If u r using Table in ur report, then the following calculation will help u
out:

=Count(<field_name>.value, "<table_name>")

Regards,

ok, I should have been more detailed
the query I am using references 2 tables
it then uses a where A=B
so my result is information from both tables

so I do not think I could just reference one table as you indicate.

I have gooten the result in regular query anaylizer with select @@rowcount
how can I do the similar and then use the result in my report
I need to disply this number AND I then need to do some math against it to
generate other number and statistics

I'll paste in my query belo
-------------------------------------------------------------------------------------
SELECT shp_hedr.order_no, shp_hedr.order_dt, shp_hedr.cust_no,
shp_hedr.st_name,
shp_hedr.cust_po, shp_hedr.ship_date, shp_hedr.inv_no, shp_hedr.inv_date,
shp_detl.manu_no, shp_detl.item_no, shp_detl.due_date, datediff(day,
ship_date, due_date) AS Days

FROM DB01.dbo.shp_detl shp_detl, DB01.dbo.shp_hedr shp_hedr

WHERE shp_detl.ship_no = shp_hedr.ship_no
AND ((shp_hedr.ship_date>=@FromDt
And shp_hedr.ship_date<=@ToDt))

order by days

select @@rowcount -- me trying to get the number..n
-----------------------------------------------------------------------------------------


[quoted text, click to view]