yes, that's even better.

i see.

i would add a third column whose width matches the width of columns 1 and 2 added together, and fill it with the image again, so you now have...

Thanks, I think I see what you are trying to do, but the logic is flawed in the expressions that determine visibility and I am going to offer an alternative...

Can you supply an example of a report that doesn't work?

I have many reports that hide parts at runtime and none fail to reclaim the space, so I wonder how...

It looks like you have your parameters wrong:

=Switch(Parameters!metodo.Value = "tp5", "TIPO 5", Parameters!metodo.Value = "tp2", "TIPO 2", isnothing(Parameters!metodo.Value), "TODOS")

But also, don't you have labels for those values in the parameter...

Without any specifics or test data, the best I can do is say -

Make sure your dataset contains at least one row for every group (think outer join) and...

Oh yes! I actually like problem solving, and coding (whether in tsql, java, javascript, c#, whatever) is a rewarding way of doing that, even when the problem may not actually...

Eirikur Eiriksson (5/10/2015)

---

zogher (5/9/2015)

---

Hi,

Thanks for the reply.

Couple of things to note (yes, my example is rather simplified), I...

Based on the limited sample, it could be as simple as this:

select

case when substring(mt.colC, 1, 1) = 'X' then 'colA' when substring(mt.colC, 2, 1) = 'X' then 'colB'...

That is just a label, it can be used with a GOTO statement to branch the code.

Have you checked the plan that is being used on Server1 when the query is run remotely like that from Server2?

If it is taking 20 seconds, you should be able...

dogramone (5/1/2015)

---

My favorite date format for hard coded dates is dd mmm yyyy, so 15 apr 2015. I can't see any valid date format set on the server or...

PowerQuery: https://www.microsoft.com/en-us/download/details.aspx?id=39379

PowerPivot/PowerView: Should be Built in - go to Options/addins/manage com addins and select the addins to enable them

Power BI is the next big thing - there is a preview...

Click on the Tables node, then press F7 to open the Object Explorer Details window, where you can sort by any available field, including name.

I get repairlevel as nvarchar(22), not BIGINT? but that is on 2012, not 2008.

For completeness, my table create for this command on 2012 is

CREATE TABLE <table_name> (

[Error] [int] NULL

, [Level]...