Hide parts based on total count

2 posts, 0 answers
  1. danparker276
    danparker276 avatar
    389 posts
    Member since:
    Aug 2010

    Posted 06 Jan 2012 Link to this post

    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?
  2. Hadib Ahmabi
    Hadib Ahmabi avatar
    181 posts
    Member since:
    Nov 2011

    Posted 09 Jan 2012 Link to this post

    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
Back to Top