February 23, 2009 at 3:48 pm
i am working on a report
where the select statement is like
Select EmployeeId,EmployeeFirstname,EmployeeLastnname,EmployeeRegion, other columns from table
where the Emploeeregion should be a parameter and employee name should be other parameter
i created a dataset to display the employeeregion.
created one more dataset where the employee name will be displayed based on the employeeregion
Now i need to modify my original query where it retrieves the data of the employee selected in the employeename parameter.
even though they select employee name my final query should go by employeeid
please let me know if i am not clear
February 24, 2009 at 5:22 am
Where exactly are you having a problem. Is it with populating the drop downs or the actual SQL query on the database, could you maybe clear up your question a bit.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply