SELECT     
  c.Brand
, a.[MTDSales]
, a.[MTDCost]
, a.[MTDMargin]
, SUM(fis.InStockValue) 
FROM  FactStockTable b 
INNER JOIN dimArticle c ON b.ArtNo = c.ArtNo 
INNER JOIN
	(SELECT c.Brand, CAST(SUM(d.LineAmount) AS decimal(10, 0)) AS [MTDSales], CAST(SUM(d.Cost) AS decimal(10, 0)) AS [MTDCost], 
	1 - SUM(d.Cost) / NULLIF (SUM(d.LineAmount), 0) AS [MTDMargin]
	FROM  FactSalesTable d 
	INNER JOIN dimArticle AS i ON d.ArtNo = c.ArtNo 
	INNER JOIN dimDates AS d ON d.SalesDate = d.DateID 
	INNER JOIN (SELECT  CONVERT(CHAR(7), DATEADD(mm, 0, DATEADD(mm, 0, GETDATE())), 120) AS timeframe) AS t ON d.YrMth = t.timeframe
	GROUP BY   c.Brand) a 
ON   c.Brand = a.Brand
WHERE c.Brand  = @BrandName
GROUP BY c.Brand , a.[MTDSales], a.[MTDCost], a.[MTDMargin]

WHERE c.Brand  = ISNULL(@BrandName,NULL)

WHERE c.Supplier= ISNULL(@SupplierName,NULL)

quote:

---

Originally posted by HenryFulmer

Thanks - the unionall works fine and I have now one combined result set. I have created two separate data sets, one for Brand and one for Supplier, to provide available values for the parameters that the user can select from.
I've set up the parameter to allow NULL values and I've et up the default value to be NULL.
I've adjusted my queries to:

WHERE c.Brand  = ISNULL(@BrandName,NULL)

and respectively

WHERE c.Supplier= ISNULL(@SupplierName,NULL)

However, when previewing the report I am always prompted to select values for both parameters. What would need to be changed for the report to accept the NULL value? Thanks for any help.

---