Thank you Elliot.

When I need to understand how exactly something works

MSDN is the worst place.

I don't know, maybe it's just me but

I just get very angry when you read 2-3 pages article

and...

the question is:

SSRS comes with some DDS solution.

[New Data Driven Subscription] button at the toolbar in Report Manager

How do I use it?

I can't find any documentation on this.

Any samples?

What third party DDS tool?

Can you give me a link please?

We were going to design our own system.

I guess it's a few tables with SubscriptionID, SubscriptionName,

ParameterName, ParameterValue, etc. columns

We're not...

I have attached Excel file with the results of

SET STATISTICS PROFILE ON

By the way,

Add or change indexes, table schema is not an option.

I will not have permissions to do that.

Bingo!

Thanks a lot Garadin!

This explains everyhitng.

I thought it returns data and works like WHERE ID IN (Select...

Thanks.

But I'm trying to learn how to use EXISTS.

Can you write me SQL with EXISTS

to get what I want?

Resolved!

I refreshed everything I could. Dataset, fields, parameters, etc.

and it started to work.

Anyway,

Thank you very much Steve.

I can't do PRINT. I'm in Visual Studio Report Designer.

I did SELECT @P_COB1 and disabled the rest of SQL.

The result is 'NA'.

Dataset runs OK.

Preview also throws an error when...

Resolved !

UNPIVOTing fixed the chart!

here is the code:

select

#cusip.COB

, #cusip.CUSIP

, #cusip.Spread

from

#cusip inner join #CreditSpreadCurve_250 on

#cusip.[Index] = #CreditSpreadCurve_250.Instrument

and #cusip.COB = #CreditSpreadCurve_250.COB

UNION

select

#cusip.COB

, 'Index'

, #CreditSpreadCurve_250.Spread

from

#cusip inner join #CreditSpreadCurve_250...

It is for Reporting Services.

I have a Line Chart that is supposed to show

5 lines. 4 CUSIP values and one [IndexValue] value.

With just CUSIP value the chart looks good.

But as...

I found the solution.

In Textbox Properties, Navigation tab, select "Jump to URL"" option.

Then insert this Javascript script:

="void(window.open('http://wmbcextrmw80101.na.corp.tdwm.com/ReportServer/Pages/ReportViewer.aspx?%2fMarket+Risk%2fSystems+QA%2fUAT%2fCUSIP+Chart&rs:Command=Render&Parm1="+Fields!CUSIP.Value+"'))"

The URL path to the report you can get if you type http://servername/ReportServer/ in...

Guys,

I don't understand why you focused so much on this criteria:

... WHERE DateDiff(day,[COB],[TimeStamp])>=5

It's really not the right criteria for [Spread] value staying the same for more than 5 consecutive business...

By the way IFCode shortcuts didn't work for me

with previous version of FireFox.

But now I will definitely start using it.

It works.

.