thanks for your quick reply.

is there a more simple and quicker way to do it.

if that is the only way , where can I get the code?

the other thing is...

Am not sure if this can help

search: "I FINALLY got it to work.... the functionality I was looking for:"

in

http://www.sqldev.org/sql-server-reporting-services/in-a-data-model-how-do-i-filter-rows-based-on-the-identify-of-the-user-54257.shtml

you can filter the dataset using the userID

it looks like that is the only option you got

unless you give primary key to your table.

or to create a unique key you may create a named query having two...

hello there

I am having this issue

and it is becoming unresponsive if you hit run in the report builder while you are selecting fileds for more than 3 times.

did you got...

you can use "filter" by windowsId inside the model

check the credentials that your datasource is using

and make sure the model is using the right datasource

it is there on file, options on the report builder

Thanks All,

Appreciated

Thanks for your quick reply,

Restore and delete records?

since the size is big, it takes a lot of time to restore it on another server.

plus copying over the file on...

Anyone out there who can shed some light on?

appreciated

Jack,

Thanks,

Is there any way that SSRS can do for us to get the user id when he/she gets logged into intranet to access the pre defined report model?

ok as I...

one thing to note , our users are very limited approx. 2 users per state.

please let me know your recommendation.so that I can implement it.

with regard to identifying the users...

no , child packages dont use ....but on the master package properties.......failparentonfailur is true

Hi all,

Have changed the code to work for sql 2000

But it only creates the audit table for the first column, and it doesnt loop to other columns.

Have spent more time...

Thsnks guys for your quick reply.

I agree we should create stored proc.and here is the code for that.

would you guys make it work for sql server 2000. it errored out...