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