I was able to resolve this by making the open query select list a CTE and selecting from the CTE.

This seems to work for me in another way. I now have ALL in the parameter select box which shows everything .

AND

(

(NULLIF(isnull(d.dw_ac_approval_date,''),'') IS NOT NULL and @approval_date = 'YES')

OR (NULLIF(isnull(d.dw_ac_approval_date,''),'')...

Hi All,

Thanks for your responses. I figured it out when I was playing with it yesterday. This is the code that gave me exactly what I was looking for.

declare @open_period_name...

Thanks Old hand

Thanks for post.

I entered into similar issue when I was asked to deliver a report on the first working day of the month.

I tried the sql posted but...

Problem solved. Tablix Properties then tick both the add a page break after and keep together on one page if possible did the trick for me.

EO

Thanks. Not yet tested but that looks like something that I need.

Emma

Ok. Thanks Grant and also to everyone that contributed.

EO

Thanks for the information. Can I be helped with the script for such task using extended event.

E.O

Yes, something like that. I have a table that was created by previous developers. Current development shows that some of the data from the table is incorrect. So I want...

I just solved it by using the expression:

((Fields!Number_of_Instalments.Value - 1)* Fields!Admin_Fee.Value)+ (Fields!Admin_Fee.Value / iif(Fields!Monthly_Payment.Value * Fields!Final_Amount.Value = 0,1,Fields!Monthly_Payment.Value * Fields!Final_Amount.Value))

EO

Saw this my posting and decided to put the solution that worked for me.

I created the subscription normal and putting an end date to the subscription because it wil now...

Hi ,

The code that I used in the job did not work for me. Can you let me know the code to check if any rows are returned.

Thanks,

EO

Thanks Kevin, this is a little bit simpler.

I am testing the job at the moment to see how it works out.

Below is my SQL in the job step

IF @@rowcount...

Thanks Pietlinden. Yes I was referring on how to do it in VB.net expressions although your SQL is so useful.