Help - build rpt dynamically using RDL for given mdx query

Discussion in 'microsoft.public.sqlserver.olap' started by Summa, Aug 2, 2004.

  1. Summa

    Summa Guest

    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
     
    Summa, Aug 2, 2004
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.