Hello Philip,

So, for the SQL Server part (SSMS, SSDT) you should first install .NET 4.5 (and probably .NET 3.1 if it is not there). Once that is done, you can...

You should check the previous log - the one that was before the restart. You can also look at Event Viewer (Start -> Run -> eventvwr) for additional clues. If...

Hi Ranzz,

In that case you can use the mentioned method - just write a simple stored procedure, that will list the permissions you need. More details on permissions and what...

What is your SQL Server version and which permissions exactly you need to look at - server level, database level, Windows level?

In any case - you could explore the possibility...

We are talking about tempdb of a clustered SQL Server 2012 instance and since that release Microsoft supports tempdb on a local drive. For detailed instruction, you can check here:

There is nothing to stop you doing it (from technical perspective).

I would still consider this as an approach, as you might get this drive hammered down by one of...

Hi casanova,

You can reference the values from the dropdown in a dataset by using @ symbol in front of the name of the parameter.

So for example if you have...

There are two approaches in order to actually get report parameters to work.

Approach one: when you create your underlying dataset, you explicitly define the parameters in a where clause of...

Hello ronaldkrex,

I guess you can try using Group page braking by going to Tablix Properties -> Page Breaks and check the option "Between each instance of a group". This worked...

I haven't seen such an expression and I am not quite sure if it actually exists. As a workaround I can suggest you to create a table in your database...

If I understood correctly, you just have to select your header columns, then go to the Property windows in VS and in color selection window go to Expressions. From there...

Hi there,

You can use for start date the following expression: DateAdd("d",-7,Today()) and for end date Today().

Those expressions can be set as default values for both parameters in the report definition...

Well as you are using one and the same destination you can use either Merge transformation, or Union all transformation.

Hi there,

I guess if I understood the problem correctly,instead of a lookup you can create a function in the database which to be called with an Execute SQL task and...

I'm glad I could help. Now about the window - you can open it by going to View->Report Data or press hot key combination Ctrl+Alt+D.

all best,

ivan