I am trying to create a report where the final product will be an accumulation of results from several queries (multiple query report). Every line should be a result of new query. It may be that I have to use 2-3 tools. The source of data is an analysis services cube. The delivery tool will be a dashboard (performance point). It is possible that users may have to do extra formatting. This way some users can report number as a sum and other use details.

I tried to use reports from Dashboard designer and then put them together on the dashboard but I need more control on a layout. I looked at reporting within Analysis services. I am about to look at report builder. I would appreciate any ideas.

For more desc look:

Rows:Budget-Column1 Actuals - Column 2
Revenue (where project <> z and account not in ( “1”, “12”)
Revenue (where project = z and account = “1”)
Revenue (where account = “12”)
Total revenue

Expense (where account <> “6” and project <> y)
Expense (where account = “6”)
Expense (where project = y)
Total expense