danparker276
Top achievements
Rank 2
Rank 2
danparker276
asked on 06 Jan 2012, 08:29 PM
I wondering the best way to hide details of the reports based on the count.
My query has select top(1000), so only the top 1000 items are returned. If I get 1000, I display a message saying please refine your parameters.
How should I set the visibility to hide the details and the groups. I tried to set the binding of visibility to the expression
IIF( count(fields.field1) < 1000, true, false) , but that's not going to get a total count of the items. What's a good way to do this? Is there a total result set count?
My query has select top(1000), so only the top 1000 items are returned. If I get 1000, I display a message saying please refine your parameters.
How should I set the visibility to hide the details and the groups. I tried to set the binding of visibility to the expression
IIF( count(fields.field1) < 1000, true, false) , but that's not going to get a total count of the items. What's a good way to do this? Is there a total result set count?
1 Answer, 1 is accepted
0
Hadib Ahmabi
Top achievements
Rank 1
Rank 1
answered on 09 Jan 2012, 03:17 PM
I guess, you can always run another query asking the SQL server about the count
SELECT Count (*) FROM ... WHERE ... and then use it in the report
SELECT Count (*) FROM ... WHERE ... and then use it in the report