I am new to reporting services. My client wants something like dynamic Reports where he can generate reports based on any column on the table. For Example: if we have a table "student" and id, name, emailid as columns, we need to generate report on any column.
The query for this is select * from student where id = @id or name = @name or emailid= @emailid. If I want to query the report based only on name, I enter the value for name but the
report says id and emailid parameters cannot be null. Any idea on how to do this??
and also just to know does SSRS support vb script??
View Complete Post