Hi Luis do you mind explaining what exactly this part does ? Will it treat the nulls as blank?

ISNULL(@parameter2,'') = ''

That helped.

Thanks Luis

Looks like something in the where clause that needs to be tweaked.This is what I am using ....

WHERE

((parameter1 = @parameter1) OR

(parameter1 = @parameter1 AND...

Noted. Thanks

I tried this sometime back... Hope it helps you

https://msdn.microsoft.com/en-us/dd220470.aspx

Try using a Table and add Image in the top row.

and data in the row below that.

Your query will probably have to be tweaked to get the row information per...

Thanks a lot

If its today it should show data from last week to last week - 52 weeks

Because we are in the middle of the week.. Hope I am not confusing

52 weeks from current week. If its the middle of the week then 52 weeks from past week So, The starting date will be based of current date

Set Interactive height property of the report to 0 inc

Did you try List ? I guess that should work here

Yes, I will definitely try this.

Thanks

Thanks. Tweaked it a bit to get different columns

declare @ThisDate datetime;

set @ThisDate = GETDATE();

with ThreeWeek as (select rn from (values (0),(1),(2))dt(rn))

select distinct dateadd(wk, datediff(wk, 0, @ThisDate) + (0),...

Monday So, Need to see May 4 , 2015 , May 11, 2015 , May 18,2015