I'm producing a report in Report Builder 3.0 that needs to show events grouped by time of day, and another table with the same data grouped by day of week. Both tables show the same results, just grouped differently. The query that generates the ungrouped data is expensive, so I don't want to run it twice. I've created queries in Management Studio that get the ungrouped data into a global temp table, and then I can fetch both grouped data sets from there. Unfortunately I can't get this to work in Report Builder. I have one Dataset that runs the main query, saves it into global temp, and then returns the first result set. The second Dataset returns the results from global temp. This keeps failing, the second result set is blank. Does Reporting services run the queries in the order they are in the report, or are they run concurrently? If they are run concurrently this would explain it. Is there anything I can do to change this so that the second query doesn't run until the first one has completed? Is there a better way of achieving the results I'm after?

I'll answer the first question myself, since I've just worked it out. Yes, the queries are run concurrently. I can deal with this by setting a global flag in the main query, and the second query waits in a loop until this flag is set before proceeding. It works now. Second question is still open though - is there a better way of doing this?

Hi Hoopy1, Actually, you could group this dataset on the report level. Both of Matrix and Table control supply the goup feature, you could select the group datafield based on your requirement. Thanks, Challen Fu