Display dataset record count in SSRS report Header?

Posted on 2008-11-18
Last Modified: 2013-11-26
I'm using Microsoft Visual Studio, SQL Server Reporting Services.
I have a report with multiple datasets, and wish to display the record count of the primary dataset in the report header.

How can I do this?

Thanks in advance...
Question by:PetEdge
    1 Comment
    LVL 37

    Accepted Solution

    The short answer would be that it's not possible.  But as with many things (and we don't give up easily): there's a workaround!  That's actually one of the important things to remember about SSRS: many things that you would first think of as being not possible are actually possible if you spend some time looking for it.  Some gems are exposed after opening about 5 popup property screens :-)

    For your question I'll just point you to the following explanation (why repeat it if someone else already did it well):

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now