I have a Parameter in my report which gets the name of a person. The user wants to see the last name first and the first name on the parameter dropdown. But in the database it is one single field with firstname first and then lastname. For Example: Database field: karthik kota parameter dropdown: kota karthik

hello, this should work: =split("John Smith", " ")(1) & " " & split("John Smith", " ")(0) replace john smith with your database field

When I pass this parameter should I change the SQL Query.

sorry, ya this should be done in the query. here's how you can do it if you are using a SQL server database: select right('John Smith', CHARINDEX(' ', 'John Smith')) + ' ' + left('John Smith', CHARINDEX(' ', 'John Smith'))

Hi Nick, You need to change query, declare @fullname nvarchar(100) select @fullname = 'karthik kota' select RIGHT(@fullname,charindex(' ',reverse(@fullname))) + ' ' + Left(@fullname,charindex(' ',@fullname)) as FullName Just replace this in dataset which populates parameter availabe values. You can use table field in place of loacl variable. -Chintak

you might also need below link in furture:- http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648 Thanks Kumarkk

The easy way is to simply use a separate query to pull you list of values... Something like this... SELECT UserID, FirstName + ' ' + LastName AS FullName FROM TableName HTH, JasonJason Long

what if the field is spt rt - doe,john how can i add =split("John Smith", " ")(1) & " " & split("John Smith", " ")(0) not to include spt rt - thanks,JK