No need to do =SPLIT(JOIN..., in SSRS 2008

It can be done in the properties, in the action section. Just add the parameters.

The problem that can show up, is when any...

Doesn't work for me.

Do you have another example?

This is something usefull to know.

If you get the solution for relational DB, post it here.

Thanks!

Regrdas

Found the bug.

New Challenge:

So now I have 2 parameters, but instead, these 2 parameters, it is possible to have only 1 with the same values?

For example in 1 parameter:

Air Force...

Not working body.

I got this:

Dataset1

SELECT distinct chapter

FROM chapter_capacity_table

Dataset2

Select distinct capacity

FROM chapter_capacity_table

WHERE (chapter in @Chapter)

!?

Thanks

Basically what i want is to dynamically populate a parameter based on the selection of a previous parameter.

Solutions?

Regards!

Thanks

ANd how do I do that? I've never done that before.

So I create 2 parameters: 1 with the chapter and another that shows all capacities related to the selected chapter....

Imagine a field with chapters and another with capacities.

Capacities are in chapters. For example:

Air Force (chapter)

Defense (capacity)

Protection (capacity)

Missil Acquisition (capacity)

Navy (chapter)

...

Thath was my plan, but it is possible to make a bar chart clickable?

What can be done, that I know of, is make all the report clickable.

Thanks

Regards

Thanks

It is possible to base a Traffic Light indicator comparing values from textboxes?

For example:

I have to compare these 2 columns:

%Realized (the data to this cell is based in an expression...

Found the solution!

Here it goes

DATEDIFF(DAY, ProjectStartDate, ProjectFinishDate) AS TotalProjectDuration

OK

It is possible to base a traffic light on textboxes values?

I got:

Textbox1 (% Realized)

Textbox2 (% Planned)

I want my indicator to light up green when: % Realized > % Planned; Red...

Hi, it seems that we are having the same trouble.

In my case, I want the stage name of my project, where the stage name is in DataSet1 and Project in...

Hi!

I believe that I've used correctly the Lookup function, but it doesn't retrieve the correct result.

Going to be hard to explain, but here it goes:

DataSet1 (from DataSource1) with ProjectName, from...

Take also a look at:

http://blog.hoegaerden.be/2010/05/16/looking-up-data-on-different-sources

Nice blog post.

Regards