Incorrect syntax near ')'

[Ichiorochi]

Hello everyone, so today I have run into this nasty little incorrect syntax near ')' error, and the thing is i have checked all the variables and parameters through. My SQL connecting seems to be set up correctly as it gives me a succesful connection when I test it. And before you suggest that i look at the SQL server I would like to add I DON'T have access to the server so while that may be the problem it would mean i can't solve it yet.

Code: Select all

----------------------------
[Customer Explanation]



----------------------------
[General Info]

Application: Stimulsoft Reports.Net
Framework:   v4.0.30319
Version:     Version: 2014.3.0 from 1 December 2014
MachineName: Machine
OSVersion:   Microsoft Windows NT 6.1.7601 Service Pack 1
UserName:    User

----------------------------
[Exception Info]
Message:     Incorrect syntax near ')'.

Source:      .Net SqlClient Data Provider

StackTrace:
   ved System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   ved System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   ved System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   ved System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   ved System.Data.SqlClient.SqlDataReader.get_MetaData()
   ved System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   ved System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   ved System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   ved System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   ved System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   ved System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   ved System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   ved System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   ved Stimulsoft.Report.Dictionary.StiSqlSource.UpdateParameters()
   ved Stimulsoft.Report.Dictionary.StiSqlAdapterService.ConnectDataSourceToData(StiDictionary dictionary, StiDataSource dataSource, Boolean loadData)
   ved Stimulsoft.Report.Dictionary.StiDataSource.Connect(StiDataCollection datas, Boolean loadData)
   ved Stimulsoft.Report.Dictionary.StiDataSourcesCollection.Connect(StiDataCollection datas, Boolean loadData)
   ved Stimulsoft.Report.Dictionary.StiDictionary.Connect(Boolean loadData)
   ved Stimulsoft.Report.Engine.StiRenderProviderV2.ConnectToData(StiReport report)
   ved Stimulsoft.Report.Engine.StiRenderProviderV2.Render(StiReport report, StiRenderState state)
   ved Stimulsoft.Report.Engine.StiReportV2Builder.RenderSingleReport(StiReport masterReport, StiRenderState renderState)
   ved Stimulsoft.Report.StiReport.RenderReport(StiRenderState renderState)
   ved Stimulsoft.Report.StiReport.Render(StiRenderState renderState, StiGuiMode guiMode)
   ved Stimulsoft.Report.StiReport.Render(Boolean showProgress)
   ved Stimulsoft.Report.Design.Controls.StiDesignerWebPreviewControl.btRefresh_Click(Object sender, EventArgs e)

----------------------------
[Assemblies]
mscorlib, Version = 4.0.0.0
Stimulsoft.Base, Version = 2014.3.0.0
Stimulsoft.Report, Version = 2014.3.0.0
Stimulsoft.Report.Design, Version = 2014.3.0.0
System.Windows.Forms, Version = 4.0.0.0

[Alex K.]

Hello,

Most probably, a problem in the SQL query or expression.
Can you please send us your report which reproduces the issue for analysis.

Thank you.