zapouk (10/21/2011)

This is the scenario I've got, so will test it both ways - with and without UDF. I read somewhere that if your function is scalar and returning one...

At least you've got user_name(), suser_name(), @@servername and @@servicename.

select * from sys.dm_exec_sessions where session_id = @@SPID

No need to change your query. Change what is located on each axis/group instead. That should do the trick.

That's what I'd do, yes. Everyone can see the list of all the departments, then use AD groups to grant permission to the different department folders.

Quick and dirty "right direction":

You'll have to have some kind of table controlling user info and access. Then you would typically use suser_name() in your query to retrieve the user...

How about ports? Can you connect to the database server from the report server using other tools, such as SQL Server Management Studio, sqlcmd or other tool? I also asked...

May using day of month (1-31) be a solution?

Could it be that you're creating a new report server which shall use an existing database, or a scale out scenario? If so, you must restore the encryption key. http://msdn.microsoft.com/en-us/library/ms157133.aspx.

When the user connects (using for instance Internet Explorer), SSRS will use integrated security by default. If the user comes from a non-trusted domain, there will be a popup asking...

Seems like some kind of security issue, yes. Is BudgetReport using windows integrated security? Username and password? Are the required ports opened between the report server and the database server?

You may want to have a look at the pivot operator.

Yes, rebuild index may require less log in bulk logged recovery model: http://msdn.microsoft.com/en-us/library/ms191244.aspx and http://msdn.microsoft.com/en-us/library/ms191484.aspx

Thanks for the repsonse. As far as I've seen, there is no such thing in the SQL Standards. I surely see your points, and in fact it is kind of...

As far as I know, there is no such thing as access based visibility. You can however, as I stated, hide it for all users, and you (as the developer)...

No offence intended, but if you try to keep it simple to understand, perhaps telnet is not the best idea, as telenet client is not installed by default on Windows...