Is this expression written in textboxproperties -> Visibility-> hide expression?

I have written this expression in above mentioned place , when i do it preview it does not show columns but...

this has to be done by grouping and expression in ssrs . So , cannot use CTE.

Anyways i did resolve this by grouping.

can you reply with your iff condition?

Thank you. I got it resolved.

@luis:Thank you for reply . I tried your query and the result from your query is :Aug 10 2016 5:29AM .

Which is not what i want....

?? the table that has sendate is created by someone else , my table has datetime.

The campaignname with date appeneded is duplicates . so , yes to your question.

example from my table:

Day10ReminderCampaign2016_09_16_01:43:05

Day10ReminderCampaign2016_09_17_01:44:01

Day10ReminderCampaign2016_09_18_01:43:59

Day10ReminderCampaign2016_09_19_01:45:42

Day10ReminderCampaign2016_09_20_01:22:18

Day10ReminderCampaign2016_09_16_01:43:05

Day10ReminderCampaign2016_09_16_01:43:05

Day3ReminderCampaign2016_09_16_02:24:16

Day3ReminderCampaign2016_09_16_02:24:16

Yes. Finally i am able to remove dupes by just getting distinct values from view and inserting into destination.

My source has duplicate. Campaignnames appened with sendate dupes.

So my example also contains dupes. In my reference tables , which comes from view over stage/source table has just campaign name...

Thanks to everyone. Your responses are helpful , it works as needed.

Thank you for the reply. I solved it by changing the Sql server service agent service to run as local servcie account in configurationManager. Since i am testing on local...

the link to downlaod is not working. And i am trying to unistall and re-install the sql server 2014 developer edition. Please let me know if you find the link...

I sthere nay way , i can download ssis and ssrs on SQL express?

I am still having issue with the order of column s it appears.

example : column 1 , column 2 ...column 5

The file shows : column 5 , column 3...

This is resolved by unchecking the column in excel destinations ---> columns section