Got this one sorted after speaking to a colleague, thanks.

FYI - added UserID via Report -> Report Parameters and then added these to the individual reports via report properties.

Hi

Thanks for your response.

So I have 2 reports, each with it's own data set. These work individually.

I can add both to a single report but get an error "sub report...

Tested and working.

Thanks. 😀

If you believe this can be done in a much simpler way, I'd really like to know how! :w00t:

Thanks for the solution above. I will test this out.

Appreciate...

Yes.

First, I'll declare all columns in the attribute table as variables.

DECLARE@xid numeric

DECLARE@xGroup numeric

DECLARE@xname varchar(10)

DECLARE@xValue varchar(10)

DECLARE@xuserID numeric

I set them to the values I want. Some are constant values while the others...

Hi

Thank you for the SQL to generate the attribute ID. Not sure if I've been completely clear on this...

My user IDs come from another query. I need to insert each...

Hi

Thanks again for responses. Code below should create tables and insert some sample data.

Notes

- ID of User and Group tables correspond with User & Group in Attributes and Membership tables

-...

Ramesh Saive (2/6/2010)

---

As Jeffrey said, if you just need incremental values without bothering about gaps then an IDENTITY column would do the best job. All you have to do...

Thanks for the response.:-)

Ok...

I have the following tables:

User - contains id and name of user

Group - contains id and name of group

Membership - contains the unique id of user and...

bc_ (12/9/2009)

---

Reporting Services has the functionality to send reports via email subscriptions and rendered in a variety of formats. The only thing I see in your original request that...

Hi. I was looking at reporting services previously. The problem is I think I need a combination of the 2 to email reports and so on. How would you recommend...