none
Intersecting datasets

    Question

  • I would like to take the intersection of 2 datasets to create a report using Report Builder 2.0

    I can do this in Business Objects. Can I do it with Report Builder 2.0?

    Thanks,

    Michael
    Thursday, January 22, 2009 6:16 PM

Answers

  • Hi Michael,

    Multidimensional Expression (MDX) queries or Data Mining Prediction (DMX) queries can only be generated by a Reporting Services query designer because a result set must be retrieved as a flattened rowset. If you want to create a dataset in Report Builder 2.0, you can create a new query or you can import an existing query from a file or from another report. Only the .sql and .rdl file types are supported.

    If you have two datasets in the report, the following list describes how you can use multiple datasets in a report:

     

    If you have any more questions, please let me know.

     

    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Monday, January 26, 2009 8:24 AM