Case when Date_Amended is null then Date_Created else Date_amended end as Latest_Date

U can use textbox and write expression and normal text into text box like below:

= "Report for " + Cstr(Parameters!Month.Value) + Cstr(Parameters!Year.Value)

I havent tested it but it should work with...

Yes it is possible.

=iif(Parameters!name.Value = "VVV", "Report_1", "Report_2")

Assume that you have two report Report_1 and Report_2 and Report_1 populates if your name parameter is VVV otherwise it will populate Report_2....

I dont think it works in that way. U need to write actual query.

Basically you need to retrieve recepient list in that query.

So something like:

Select email_address, table_field from yourtable...

Then how about this?

declare @b1 nchar(10)

declare @b2 char(10)

set @b1 = 'B'

set @b2 = 'B'

select @b1 + 'a', @b2 + 'a'

--------------------

B a B...

Thanks for your prompt reply. It seems it uses more than 2 character. Because when i see the output it is like 10 character. Is it because i have declare...

I believe u can handle different parameter for one report but i dont think u can send different report from one subcritption itself. Because subscription works on report itself. To...

hi,

U can easily do this via data driven subscription. In fact it gives you option to write query to select your email address according to your condition. The article below...

Do u use subscription or data driven Subscription?

U can pass parameter in both types of subscription. But if you want to send message (mail) in certain conditin or certain users...

U dont believe but i have spent around 2-3 days to get this solution. I am glad it is helpful for you.

U can write stored procedure where you use both of your queries. If you have same format data in both queries then u can combile both query output into one...

Well, from the code you gave it is impossible to get 8 columns. if it is right code then you will get the number of records into record column. U...

CASE

WHEN

DATEDIFF(DAY, [Date on Waiting List], GETDATE()) / 7 < 4

THEN 1

WHEN

DATEDIFF(DAY, [Date on Waiting List], GETDATE()) / 7 >= 4

AND

DATEDIFF(DAY, [Date on Waiting List], GETDATE()) / 7 <...

It really depends on ur server and machine cofiguration and speed. If you have 7 million record in a table then of course ur organization is haivng server with good...

What is the problem here?