I think ; yes...

I think it is not related about type conversion.

- You used a lot of non-sargable conditions a.dim_1 = substring(b.dim_value,1,2)

-This subquery table index

"

SELECT...

You can download SSDT 2016 after that you can develop SSIS package ,SSRS and SSAS.

https://msdn.microsoft.com/en-us/library/mt204009.aspx

Could you look at this article about SSRS credentials

[/url]

My best is Real-Time Operational Analytics

No there is not any event handler.

I m using Microsoft Data Provider for SAP It calls a RFC (Remote Function Call) from SAP and in some loop iterations...

When I look at the Agent Job Activity I see error.

But loop is finished succesfully why write error to job history and

It writes first error and first loop error.

Could you check in connection proporties Save my password option.

It must be check. I think it is related the connection settings.

Could you send a sample of that excel file?

Could you format this column to text in excel ?

I guess somethink write query parameters to report and after check it

your subscription report.

Are they true?

I think you can use sub-report with drilldown.

http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD

Restore SSRS ReportServer database can cause this.

Can you check your SSRS version ?

You can see this only Enterprise and Developer edition.

https://www.microsoft.com/en-us/cloud-platform/sql-server-editions

Is report have any default parameter ?