Slammer and the likes is was keeps me from exposing port 1433 directly to the internet.

RDP is by default limited to two concurrent sessions for admin purposes. VNC, TeamViewer and...

Hello Derek,

That's right and is already in place within our LAN-Environment. But in this case, the path to the remote server leads through the internet. I always thought that opening...

I guess the sister article maybe isn't online yet. After all, the article is the first of a two-part series.

I'm looking forward to the other part 🙂

Thanks for the Tips, some of them have already come in quite handy.

For the Expression 4, I must warn you that they will not always return the last day of...

You can change the interval in the axis-properties of the chart. Although i don't know how it will behave if you havent got data for these intervals.

Hi Jean-Paul,

Good to hear that it worked out 🙂

Temporary tables are worth a try, hopefully it won't have the same restrictions like the "Select * from" approach.

I'm not so experienced in using cursors, thats why my suggestions might...

Quick-Shot: Try to wrap a " Select * from (yourqueries) as T " around your queries. Although i don't know if this works when using cursors.

Hmm...

So when there is no Name returned in your first query, then your Complex one uses the one of the current user?

Hi Jean-Paul,

Did you try to add something like this to your complex select statement?

Where column in ((select distinct ResourceName From MSP_EpmResource_UserView))

or you could add the distinct ResourceNames as separate Dataset...

@Carleton: SSRS 2008 delivers .xls files, not .xlsx, when exporting to excel. I assume that it uses the Excel2003-Renderer.

You could create a new report and add the reports you want to merge as sub-reports.

Please open new threads for new questions....

if you can talk directly to the database, try doing a select on that field and filter out all nulls and then sort by that field. either at the beginning...

are you setting that null value in your query or is it given from the database?

seems like you've got a space " " somewhere in that column, otherwise the IIF-Clause...

make sure that the /reports directory is properly configured on the IIS

you can check that in the SSRS-Configuration Tool. The point "Virtual Directory for report manager" should have a green...