Hello
I am new to the Jet Reports and Jet Data Manager application, but am making a lot of progress on cubes very quickly. However, I am currently stuck and wonder if anyone has any advice.
In the Business Function, in one of the tables I am trying to add together the information from 2 columns - [First Name] and [Last Name] to allow a custom field to be created showing someone's full name. In SQL Server I have run the following query which displays the correct results:
SELECT [First Name] + ' ' + [Last Name]
FROM [RICHARD_STAGING].[dbo].[DR_LIVE_dbo_Employee_V]
However, in trying to replicate this as either a SQL Snippet or as a "Custom Value" within "Field Transformations", I keep getting errors and don't know why the code won't work. If anyone can offer any advice as to how the query should be structured to allow this concatenation to work it would be much appreciated.
Many thanks in advace
Richard
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Richard,
Please post questions related to Jet Enterprise in the Jet Enterprise section of this community site. People monitor that section of the site to answer questions about Jet Enterprise.
Kind regards,
Hughes -
Jet Reports Historic Posts Thanks for that - I'll post it there. I would have done initially but I couldn't find it on the front page.
Please sign in to leave a comment.