locked
HOW TO GET input parameters full name by sql query passing @parameter RRS feed

  • Question

  • User1760698851 posted

    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

    Thursday, November 6, 2014 9:45 AM

Answers

  • User753101303 posted

    Hi,

    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.

    Try http://msdn.microsoft.com/en-us/library/ee210533.aspx#Query

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, November 6, 2014 1:09 PM