SQL Request Control – Cascading Multiple Fields from SQL Database Table

Hi Eric,

You can use

select customerLastName + '-' +  customerFirstName + '-' + customerEmail AS CustName from Customer

Thanks Mathew.

It works fine now.

Eric

Hi Eric

Can you please add a screen shot of this working? I am trying to do the same.

Thanks

Hi Sojan

Can you please share a screenshot of this working?

Thanks

Hi Abhi,

what screen shot do you want

Of the action please if you can.

Hi Abhi,

Unfortunately that was a project for a client. data is not available to me anymore.

I wish I had a snapshot.

I apologize.

Eric

Hi Eric

Where can I input the formula above?

Hi Abhi,

If it is a stored procedure, it should be inside the procedure , or if you are using the sql query you can use it directly on the sql query.

Hello Sojan Mathew‌,

I am having a problem on environment using this kind of query to return the results on query type as your example.

When running the TEST query it returns values just as SSMS returns the same values. However, when query from the form preview or after publishing this appears to not work.

I am almost wondering if I should open a ticket in regards to this issue. I don't see anything not allowing this to work appropriately. When I do simple query like:

Select EmployeeID from Employees

This returns the values as expected on the form. I am stumped on this one. Anyone have any advice at this point?

‌

I found the carriage returns were causing the query to break. I deleted the extra spaces and returns and the query started working.

Select FirstName + ' ' + LastName AS EmployeeName ,EmployeeID FROM Employees Where Active = 1 Order by 1

Hope this helps anyone with this issue!