mdavidson_2

I'm going to post what fixed my issue in case another user ends up with a similar problem: To reiterate the problem: I was trying to reference a scalar function declared on a MSSql Server through jasperstudio. I was getting syntax errors and no dataset would populate in the "data preview". What I was doing wrong: I was focusing on the "syntax error issue". The problem was not with my syntax referencing the function. The problem was the data adapter that I was using. I had used the net.sourceforge.jtds.jdbc.Driver as my adapter to this point. I was hitting many different databases (Postgres, MySQL, MSSql...) with it without issue. *BUT* in order to use the function declared on the MSSql db Server, I needed to create a new data adapter using the com.microsoft.sqlserver.jdbc.SQLServerDriver driver. NOTE: The "Dataset and query editor dialog" still displayed a syntax error on the line in the select statement that referenced the function, but the data set was sucessfully returned as expected.

Its a scalar function on the database. It works in SSMS and returns the expected results.

I have a function declared on MSSql Server. The function works as intended on the MSSql Server. When I try to call it in a select statement in JasperSoft Studio 6.5, I'm getting syntax errors and no results. The error is specific to the call to the function. Function name: dbo.GetPersonTypeDesc( ) The select statment looks like this: SELECT dbo."Incident"."IncidentID", dbo."Incident"."IncidentTypeENum", dbo."Person"."PersonTypeCde", dbo.GetPersonTypeDesc(Incident.IncidentTypeENum,Person.PersonTypeCde) as 'VALUE'FROM dbo."Incident" LEFT INNER JOIN dbo."Person" ON dbo."Incident"."IncidentID" = dbo."Person"."IncidentID"[/code]What's the proper syntax to call the procedure?