hI .....
I have mdx querys and I want to build report on the fly using report definition language with style sheets and all .. (there is no pre build report format),

here's my query ..........
SELECT [Measures].members on columns,
NON EMPTY CROSSJOIN({DESCENDANTS([Store].[All Stores], [Store Name], LEAVES )}, {DESCENDANTS([Product].[All Products], [Product].[Product Name], LEAVES )}) on rows
FROM SALES

and this query consits only 2 dimension (product and store) it can be more than 2 dimensions, So I want do this in code, and I feel report with more than one dimension is very slow....

guys I am talking creating on the fly some thing like "MDXDrillDownManyLevels.rdl" of "Sample Sql Server Report " in ASandRSSamples.EXE

Thanks.

any help

you have to create your own program to generate an RDL file.
Also, Reporting services doesn't support CSS Style files, you must provide
the formating information to each element in the report yourself.

and you are right, more then 1 dimension if you want to use the lower level
of each dimension gets a lot of time to be processed!!!
also its too huge to be usefull for a normal human:
50 stores * 1000 products = 50000 rows !!!


"Summa" <Summa (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news:B68C26FA-319A-4195-9EB6-80F6D5F406F8 (AT) microsoft (DOT) com...
report format),
LEAVES )}) on rows
than one dimension is very slow....
ASandRSSamples.EXE