Last post Nov 06, 2014 01:09 PM by PatriceSc
Nov 06, 2014 09:45 AM|Jim2401|LINK
I am new to SSRS REPORT BUILDER 3.0 . I am passing 2 input parameters to to get the report .1: Employee No 2:Date and retrieving employee details on the report. Now i want to show the employee name for selected employee no on the report . But how to get
this information (EX: i know the query from employee table where emp no =@empno). But how and where i can write this query for input parameter @empno. So that i can drag and drop employee name on my report ? LIKE CRYSTAL REPORTS... Any help or comments would
be great ..
I DONT KNOW IT IS A RIGHT APPROACH:
1 CREATING DATASET and query : SELECT EMPNAME FROM EMPLOYEE WHERE EMPNO='@EMPNO' 2: CREATE PARAMETER GENERAL: INTERNAL AVAILABLE VALUES: DATASET , VALUE FIELD, LABEL FIELD
BUT ITS NOT WORKING
Nov 06, 2014 01:09 PM|PatriceSc|LINK
Knowing how it fails could help to understand what is wrong. Don'tr you have some kind of error message.
Try WHERE EMPNO=@EMPNO (without the quotes so for now the problem is perhaps that you don't have any input as you are looking for an empo which is the @"empno" string rather than that match the @empno parameter.