Re: Pls Help me, Sql Server Report for Product dimention in Foodmart

#1

What you described is not a matrix report. It is a data table. You can use
the examples in
http://msdn.microsoft.com/library/de...lapasandrs.asp
which discuss how to build a table based on a query like this.

The ALL row is returned but doesn't have a caption for it. Your workaround
described below is one way to handle it.

Then you need to create a set of groupings, and filter each of the groupings
based on whether or not the field in the rowset actually contains anything.
There's a complete walkthrough of that in the whitepaper. You can also
download the samples, which contain the rdl files.

The samples don't include the ALL level, but if you add the piece you
described in your last post, you should be able to get that to work without
any issues.

-Sean

Sean Boon
Microsoft Office BI

"Summa" <Summa (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I have a Matrix in my report with rows and columns for the Product
dimension,
here is MDX query I used,

SELECT
{ [Measures].Members} on Columns,
{ [Product].Members } on rows
FROM SALES

but my problem is when u run this query in Sql Report DATA Tab ,
there is no "All Products" in "Prodcut Family" column in the query result

pane.

Quote:

So in my report I am getting a Blank cell for All products, then I
managed get it done using this ,

=IIf(IsNothing(Fields!Product_Product_Family.Value ), "All Products",
Fields!Product_Product_Family.Value)

formula to get "All Product " text on that particular cell , but I
want my report to work like this, as u run the report I want only the All

product level to be shown,

Quote:

I mean , I want first level as "All Products" , report preview as eg

Unit Sale Store Cost Store Sales
sales Count Store Sales Net
+All Product xxxx xxxxx xxxxxxx
xxxxxxx xxxxxx

then when u click on All Products other levels will be displayed as
appropriate.

I saw the Food Sales sample but it has used (Combo Box ) Filter for
Prodcut Family ( Drink ,Food, Non- Consumable) level and it dose not have a

Level "All Products" in the combo box and report is consist with Prduct
Department Level to Brand Name Level , But In my case I want all the levels
in my report.

Quote:

(Family level, Department , Category , Sub Category, Brand Name and
Product Name Level)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Pls Help me, Sql Server Report for Product dimention in Foodmart

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Pls Help me, Sql Server Report for Product dimention in Foodmart - 07-27-2004 , 12:25 PM