<div>
can you provide code you already have?
</div>


<div>
Hi,<br />
I can see that working, though we have decided that it's too much work when the two BM's can just share their report<br />
<br />
Thanks
</div>


Hi,
I can see that working, though we have decided that it's too much work when the two BM's can just share their report

Thanks

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I will give you the background b4 asking the question.<br />
<br />
Brand Manager 1 looks after the following Brands <br />
Blue stock<br />
Red stock<br />
Green stock<br />
<br />
Brand Manager 2 looks after the following Brands<br />
Yellow stock<br />
Pink stock<br />
Light Blue stock<br />
<br />
I have a simple report with a parameter that selects the Brand Manager, the report then will list their Brands and their sales for a particular month.<br />
<br />
I've been asked when selecting BM1 that his Blue brand sales include sales from Light Blue (which belongs to BM2)<br />
&nbsp;and visa vesa when selecting BM2<br />
<br />
Is this possible?<br />
<br />
Thanks<br />
Anthony
</div>
</div>


Hi All,

I will give you the background b4 asking the question.

Brand Manager 1 looks after the following Brands 
Blue stock
Red stock
Green stock

Brand Manager 2 looks after the following Brands
Yellow stock
Pink stock
Light Blue stock

I have a simple report with a parameter that selects the Brand Manager, the report then will list their Brands and their sales for a particular month.

I've been asked when selecting BM1 that his Blue brand sales include sales from Light Blue (which belongs to BM2)
 and visa vesa when selecting BM2

Is this possible?

Thanks
Anthony

SQL report request

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.