It sounds like you just want to exclude rows from the queries where the parameter is null.

If it is SSIS as suggested by the title, then just open the script component and set a breakpoint before you run it, then inspect the value in the code.

rick.servant (11/11/2015)

---

=IIF(Fields!Category.Value = "Actual" AND Fields!Periodic.Value <5,"red","black") <---------This is working

However, I need to replace the <5 with the Budget comparison as below which is not working yet.

=IIF(Fields!CAT_ACTUAL_BUDGET.Value =...

I was typing on a phone, so couldn't copy/paste...

Sorry, no - the forum mangled my post.

I have edited my previous post, just remove the spaces in the words.

Try this:

= "j a v a s c r i p t : void( w i n d o w.open('" & URL & "','_blank'))"

j-1064772 (11/6/2015)

---

Yes, I should have known to look at books on line for the syntax, I just assumed I knew all there was to know about the INSERT statement I...

The simplest answer for how to convert from RDL to RDLC is: rename.

The content/structure of the file does not change, however the ReportViewer control does not "fetch" data for you,...

Have you considered logging the caller from the procedure itself?

Something like this.

use tempdb;

go

/* Create a table to log calls to stored procedures */

create table LogSP (

id int identity(1,1)...

It's still there in the latest update - I can't check older versions, sorry.

I can't make SQL handle XML that large - can you?

The maximum size of an XML data type...

What specific version and service pack are you on?

By manually, Eirikur may have meant that you will need to convert...

You just need to include TransactionEffDate in the ORDER BY clause of the Row_number() function.

with cte as

(

select *

, row_number() over(partition by [invoiceNumber], [Group]

...

exec sp_describe_first_result_set N'select top 10 * from [myTable]'