Well I tried to use simple select statement from that task and still same error... but other tasks using same connection are working fine...

I tried taking new task and same...

I tried to execute a stored procedure without parameters also.. I tried by changing connection types also, but still no luck.!

I tried executing single EXEC also.. but still same error..!

Hi Ganesh,

Are you giving path of files kept on Network location? If so, try getting those file on local machine using FTP task/any other way based on your server location...

Hi fawwad,

Below the report designer, you will see Row Group section.

There in the table group properties, make sure you have selected grouping on whatever field you required. Then below it,...

Thanks a lot Craig... it served the purpose....

I just missed to make column of totals which I was calculating on the run... 😛

Yep.. it worked fine.. 😀

seems like grouping won't work with case statements...! :unsure:

Instead of handling this in report using expression, if you are not using this dataset anywhere in report then why don't you handle it on sql part only.

Like writing query...

That is what I want to say.. It seems like you are connected to internet through proxy and when trying to resolve this address on proxy, its taking you somewhere...

I think this is what you are looking for -

select (DATEADD(wk, DATEDIFF(wk, 6, getDate() - 15), 7))

Just put the no of days old date you want in place of 15...

Do you use proxy server to access internet?? If so then try using IP address/system name instead of localhost....

Well this helped me a lot... and also this query executes faster than whatever I worte....!

Thanks a lot Wayne..!!! 😎

Eventhough its returning just 1000 rows but it does matters how many rows its processing and how many joins it has....?

Also is your SQL Sever physical one or virtual?

Is...

Well table you can consider as -

Invoice Table -

[Invoice No] int, [Record/Transfer Time] datetime, [Departname] varchar(50)

I do agree that we will need to do self join as there is...

Whats the return type of value?? Money or String or Double?