SSRS reports displays nothing after deployment

Question

I have deployed a ssrs report in report server. when I'm trying to run that report in report server, it displays nothing. but it fetches the appropriate result in 'Preview'. I am new to ssrs reports.

My query :

if @department is not null and @Course is not null  select
student_name,average from student where student_id=@studentid

else if @department is not null and @Course is null select
student_name,average from student  where student_id=@studentid and
department_name=@department


@department , @course are optional user inputs  
@student_id is mandatory user input

Mhand7 Mhand7 · Accepted Answer · 2016-02-07T08:42:00

try to open the report from the report viewer in the report server, you should get a better message there to what is the problem

SSRS reports displays nothing after deployment

2 Answers