Thanks Lynn.

That is exactly what they are doing.

Anything I can do to help them?... Other than "not supported too bad".

And

Do you know of any documentation I can use to support...

Thanks Lynn.

Do I have to use a CTE? Always have trouble writing those..

Could I use a temp table?

Hi Lynn,

Thanks for your reply.

Yep, join sure sounds like what I need.

How would I go about that type of join?

Thanks Craig.

It's a long ugly story, but I'm stuck with creating a report w/SSRS 2005. Those two queries are each used to populate a table on the report. Two tables,...

Maybe it will help to simplify my request..

What I need is to be able to take both expressions from each table and divide them...something like

count(Fields!EE_ID.Value, "ULTIPRO_WSI")/count(Fields!EE_ID.Value, "dataset2")

problem is whne...

wow interesting.

Thanks Lynn, I'll try and figure out how to add the drop down list.

good point thanks lynn.

thanks Geoff! exactly what I needed!

I created a new dataset, but didn't see anywhere to add my query once I create it.

fwiw - I have the one table already working with it's dataset. I need...

Okay will do.

Thanks Phil and everyone else.

Yes there are no aggregates...

Hmm...

So I'm not sure how to proceed now.

What I really need is everything grouped by year first, then company code, then branch code. But retaining the...

Cold coffee -

I didn't think they were required to answer a fairly straight forward question about grouping.

If you guys need more info. let me know.

Thanks Phil & Lynn...

you both have helped me before..just wanted to thank you both so much.

good karma to you!

Thanks opc !! you rock

Gotcha..

thanks guys I'm gonna stick with mirroring..for now..

Thanks again for all the advice