COUNT value on ASP reporting not present in SSRS reporting

Author Message
Darren

  • Total Posts : 51
  • Scores: 0
  • Reward points : 26310
  • Joined: 10/25/2007
  • Status: offline
COUNT value on ASP reporting not present in SSRS reporting Thursday, January 26, 2012 12:11 PM (permalink)
0
hi all,
 
In SCCM/SMS ASP reports, many of the reports which list results, show a value in the top right hand corner of the report which indicates the count of the number of recods returned in the report.  This value is not present in SSRS reports.
 
I have search quite a bit and most of what I see is people offering how to create an SSRS report returning a count.
 
was this value taken away in SSRS or is it located somewhere i am not seeing?  I am not looking to create a new report but rather when I run an existing report (example:  list all machines which have Adobe Reader X installed), see not only the resulting list but know the count of the number of records.  I am willing to modify a report if necessary but if the info is there and I am simply not seeing it that would be great because it is likely not just 1 report but many.
 
Thoughts?
 
Thanks
Darren 
 
#1
    skissinger

    • Total Posts : 4645
    • Scores: 448
    • Reward points : 75260
    • Joined: 9/13/2001
    • Location: Sherry Kissinger
    • Status: offline
    Re:COUNT value on ASP reporting not present in SSRS reporting Thursday, January 26, 2012 1:53 PM (permalink)
    4
    I believe you will need to edit the report.  I use Report Builder 3.0, so this is how I would edit a report to add Count...  Using the default report "Computers with specific software registered in Add Remove Programs"...
    -open Report Builder 3.0, Open the report.
    -Save As the report to a new name (in case I mess up)
    -Click on a field in the table, like [netbios_name0], so that the table active.
    -rightclick on the row indicator (the grey thing on the left).  Select "Insert Row, Outside Group - Below"
    -right-click on the empty field under [Netbios_name0], and type in the word "Count:"
    -right-click on the empty field under [SiteCode] and "Expression..."
    -in the Set Expression for value, leave the = sign, and add Count(  at the bottom, in Category click Fields, and select a value to count... like Netbios_name0.   At the top, close it with the )
     so you'll end up with    =Count(Fields!Netbios_Name0.Value)
    Hit OK. and "run" the report, see if it works.
    mofmaster@myitforum.com
    My Blog
    Microsoft MVP - ConfigMgr
     
    #2
      Darren

      • Total Posts : 51
      • Scores: 0
      • Reward points : 26310
      • Joined: 10/25/2007
      • Status: offline
      Re:COUNT value on ASP reporting not present in SSRS reporting Friday, January 27, 2012 1:09 PM (permalink)
      0
      Thank you Sherry!  Great detailed workaround.
       
      #3
        Darren

        • Total Posts : 51
        • Scores: 0
        • Reward points : 26310
        • Joined: 10/25/2007
        • Status: offline
        Re:COUNT value on ASP reporting not present in SSRS reporting Friday, January 27, 2012 4:49 PM (permalink)
        0
        how do I modify a rating.  I intended to give more stars, not 2 :)
         
        #4
          skissinger

          • Total Posts : 4645
          • Scores: 448
          • Reward points : 75260
          • Joined: 9/13/2001
          • Location: Sherry Kissinger
          • Status: offline
          Re:COUNT value on ASP reporting not present in SSRS reporting Friday, January 27, 2012 4:53 PM (permalink)
          5
          Meh.  Let it go.  it's just a forum.
          mofmaster@myitforum.com
          My Blog
          Microsoft MVP - ConfigMgr
           
          #5
            Online Bookmarks Sharing: Share/Bookmark

            Jump to:

            Current active users

            There are 0 members and 1 guests.

            Icon Legend and Permission

            • New Messages
            • No New Messages
            • Hot Topic w/ New Messages
            • Hot Topic w/o New Messages
            • Locked w/ New Messages
            • Locked w/o New Messages
            • Read Message
            • Post New Thread
            • Reply to message
            • Post New Poll
            • Submit Vote
            • Post reward post
            • Delete my own posts
            • Delete my own threads
            • Rate post

            2000-2012 ASPPlayground.NET Forum Version 3.9