Hide Control Key Group Value in SSRS
<p>I have been using SSRS off and on since SQL Server 2008. There are a number of typical SSRS pitfalls and gotchas. One of these I need to go over with some one.</p>

<p>This should be pretty easy for an experienced SSRS resource / expert.</p>

<p>Let me explain the scenario</p>

<p>I have an Invoice Header and Detail. The header contains the Invoice number and InvID. The INVID is the link column for the Invoice detail or the FK in the Invoice detail. I guess that must be pretty obvious to all.</p>

<p>Now I need a simple report that displays Invoices and their items.</p>

<p>For some reasons I do not want to use the Invoice number to group the invoices in the report. I want to use the INVID.</p>

<p>But I want to hide the value of the INVID and display only the invoice number.</p>

<p>In other words the report should look something like follows</p>

<pre><code>Invoice Number  Date / Descriptio  Qty Rate Tax Amount
11001           12/52016
                Item No 1          10  10    2  102
                Item No 2          20  10    2  202
</code></pre>

<p>So on and so forth....</p>

<p>I know this is very easy. Any inputs would be welcome...</p>

<p>Plus any good recommendations in terms of resources for refreshing my knowledge of SSRS</p>

<p>Regards</p>