Passing values to subreport in SSRS throwing an error - Data Retrieval failed for the report, please check the log for more details.

Hi,

I have the subreport calling from the main report. The subreport is based on MDX query agianst the SSAS cube. some dimensions in cube has values 0 and 1.

when I try to pass '0' to the sub report as the parameter value, it gives an error "Data Retrieval failed for the report, please check the log for more details".

Actually I am using table for storing these parameter values. In the main report I am calling this table (dataset) and passing these values to subreport.

so I have given like [0],[1] and this works fine. when I give only either [0] or [1] then it is throwing an error.

Could you please advise on this.

Appreciate all and any help.

Thanks,

Divya