SSRS 2005 combine data sets

[Alan0568]

New to SSRS 2005 and looking for a basic pointer. I have a SSAS cube as a data source. I want to select cust_id, prod_dept_id, ord_qty in one data set (filtered by various background attributes) and then have another data set with the same columns but filtered differently. Fine OK have done that no problem.

I now want to display them in a table as follows

cust_id, prod_dept_id, ord_qty(from dataset1), ord_qty(from dataset2)

so I guess I need to group, join link in some way? On the [cust_id, prod_dept_id] columns.

Thanks in advance.

 

[xlbo]

AFAIK, ther eis no concept of joining data sets in RS - you would need to do the join in the query so that all data is returned in the same data set

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Alan0568]

Thanks for the reply. If I was using a SQL source I could quite easily do one select with nested queries etc but with SSAS as a source I'm a little stuffed. I was thinking there was a way of doing this at report level with groupings or something?

If not I'll have to re-think.

 

[xlbo]

Not as far as I know I'm afraid. I have tried something similar without success using IIF statements but RS is not an OLAP tool and doesn't have an option to synchronise data sets like Crystal / Business Objects etc

I am working on SSRS 2000 so there may be an option in 2005 but from what I have read I don't believe there is......always willing to be proved wrong though.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SQLBI]

Can you not create a new AS cube combining the required data and use that new single cube as your report datasource?

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

 

[Alan0568]

As this is for a specific 'non user' type job thats actually a very good idea- Thanks !