Thanks David for your help. I've kind of made a similar solution and that would've worked, but I couldn't use it.

The system I am reporting off is a huge...

thanks for NOT helping dude..I know all of the above, but hey since you can't help me with a solution then don't bloddy bother

Thx for your reply

The categories is not stored in the database as I said and yes I have to hardcode the categorization of the products, but they will not change...

Yeeeahhh...i got it working

I added a having statement on the end like this:

having (

grouping(country.country) = 0

...

Thanks for that Carl, nearly there but not quite.

I was thinking about rollup but I wasn't really sure.

My problem is now that I got a lot of repeating fields with...

Thanks alot David. You saved my day with that

A few small changes had to be done, but your suggestion is spot on. ...

Thanks for that but I don't think you really read my post...

I want to count the request id's for both total request created and total request's created that has been...

The reason why I used a right join is because some requests doesn't have a change recorded, but that doesn't make a different though

Forgot to include the group statement:

Group by lname

So I get the following result:

Name Total

user1 5

user2 2

user3 ...

I had a look at that post at it looks very similar...but i can seem to find a way to do the insert into the temp table. And do I...

"Insert the results into a temp table with an added IDENTITY (INT, 1, 1)"

How would you do that? :/

Thanks for that phill. Creating several small dts packages have crossed my mind, but i do want to do this in one

I managed...