1. Home
  2. Forum
  3. Report Platform
  4. IF EXISTS ERROR
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

IF EXISTS ERROR

Hi,

 IF EXISTS (SELECT ap_Id from asp_application where ap_Id ='E754A56C-C509-4F3C-86B5-DDE3849933C0')

BEGIN

SELECT REPLACE (ctrc_Id,'F03BE894-E5A2-4B08-8047-18B7340BCA4D','EBF409F8-5563-4E8D-B34A-3EA06D0FB0C2') AS ctrc_ID,

   REPLACE (ctrl_Name,'United States','Singapore') AS ctrl_Name

FROM asp_CountriesForCompany

JOIN asp_countryLocalizations ON ctrl_CountryId = ctrc_Id AND ctrl_CultureId = 'BECCC41B-3F42-448C-825C-425CA04FE5DA' AND ctrc_IsEnable = 1

END

ELSE

BEGIN

SELECT

ctrc_ID,

ctrl_Name

FROM asp_CountriesForCompany

JOIN asp_countryLocalizations ON ctrl_CountryId = ctrc_Id AND ctrl_CultureId = 'BECCC41B-3F42-448C-825C-425CA04FE5DA' AND ctrc_IsEnable = 1

END

Im currently having this script, when I run it I do experience this error.


Sf_Exception - System.Exception: Incorrect syntax near the keyword 'IF'. Incorrect syntax near ')'. at Syncfusion.RDL.Data.SqlDataExtension.GetData(String& error) at Syncfusion.Reporting.Web.ReportDesigner.DataProvider.GetTableData() at Syncfusion.Reporting.Web.ReportDesigner.Internal.ReportDesignerInternalHelper.ProcessDesigner()

How can I resolve this?


1 Reply
AM Arumugasami Murugesan Syncfusion Team September 9, 2021 03:04 PM UTC

Hi Marvin, 

 
Thanks for contacting Bold Report support. 

 
We have validated the reported issue and we were able to reproduce the issue in syncfusion designer but this issue was not occurred in latest bold reports control. So, we suggest you to check with in the bold reports and share the details. 

 
Note: Due to Bold reports migration we are not providing any fix changes in report platform. 

 
  
Regards, 
Arumugasami M 


Loader.
Up arrow icon