I have a report is using sharing dataset(ds file), in some query condition it execution fail and cause to timeout. it's access from Oracle Database. I had try following testing. the sql script query by SQL developer/ Dbeaver are working well and response result with 10 secs. move the rdl, ds file from 2014 ssrs -> 2016 ssrs it's same situation the problem still there. the RDL file set the dataset via sql script directly , it will walk well too why i'm using sharing ds, because the dataset is provid to 2 rdl with different view but same script. and the sql script lenght is over 2000 rows... i want it easy to maintain.

SSRS report cannot query success via ds

I have a report is using sharing dataset(ds file), in some query condition it execution fail and cause to timeout.

it's access from Oracle Database.

I had try following testing.

the sql script query by SQL developer/ Dbeaver are working well and response result with 10 secs.
move the rdl, ds file from 2014 ssrs -> 2016 ssrs it's same situation the problem still there.
the RDL file set the dataset via sql script directly , it will walk well too

why i'm using sharing ds, because the dataset is provid to 2 rdl with different view but same script. and the sql script lenght is over 2000 rows... i want it easy to maintain.

SSRS report cannot query success via ds

0 Answers