Lookup Function works fine.

I mean it retrieves results from another DB, wich is what I want, not exactly the result I expect but it seems to work allright.

This is...

It might sound like a crazy ideia but here it goes:

I could use a Lookup function to return the info I need into a column, and based on that info...

DONE. Thanks!

In this same example I got another condition I have to apply, but the info required is in another Database.

My example:

If project = "planned" (from DB abc) switch indicator...

How's that?

OK. Gonna try this one.

Goes directly into the indicator expression?

Thanks

Best regards

Thanks Anthony!

I've never used a CASE statement in SSRS before, I'm using instead an IIF statement.

Anyway can you write me the CASE statement for this particular example?

Thanks man, you've helped...

This not working for some reason.

Instead, do you know a way to link different datasets from 2 different datasources in a tablix cell expression?

Dataset1 from Datasource1

Dataset2 from Datasource2

Thanks

Regards

Thanks Genius! Works Fine.

Just a question. In the expression, how do I write for the yellow indicator?

DayDifference>=15 and <30.

Thanks

OK! In the mean time how do I create a Stored Procedure where I want data from 2 Databases.

I want ProjectName from DB1 & ProjectStage from DB2.

Thanks

Best Regards

OK thanks anyway!

What about linkin 2 tablix? Possible? Crazy stuff right?

Regards.

OK. Thanks!

It is possible to relate 2 tables from different datasources?

For example: I have Dataset1 from Datasource1 and Dataset2 from Datasource2.

I want from Dataset1 : ProjectName;

and from Dataset2 : ProjectStage....

Thanks men! It works just fine!

Can you take a look at my other problem?:

Thanks in advance.

Regards

Something mus be wrong in the expression. Do you scan anything?

The conditions were:

Green - Allocation>=ValuePlanned

Yellow - Allocation/ValuePlanned, >0,7 and <1

Red - Allocation/ValuePlanned <0,7

White - ValuePlanned=0

Yeah! It works but only when the Value Planned is <> 0, where it should show the white indicator.

In these cells it says that 'an error occured because it...

Yes, and the indicator expresion in the value property!

My example is like the one you atached but for Value Type and Value there's more than one value.

What do you say?