Error rendering report: Can not open the report data source [Main]. Exception

Error rendering report: Can not open the report data source [Main]. Exception

Posted by: thomas.hayashi on 5 December 2019, 9:34 am EST

• 

  thomas.hayashi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 December 2019, 9:34 am EST

  I’m trying to convert a legacy C1Report to a C1FlexReport by importing the C1Report into the C1FlexReport Designer.

  I can successfully preview the report “0 - Laudos” using the C1Report Designer, however I cannot do the same using the C1FlexReport Designer.

  Returning the following error:
  
  Error rendering report:
  
  Can not open the report data source [Main].
  
  Exception:
  
  Não é possível interpretar símbolo ‘"’ na posição 65.

  (which roughly translate: Not possible to interpret the symbol ‘"’ in the position 65)

  I’ve tried to replace all " to ’ without success and also don’t know what this position 65 refers to.

  I’ll attach the report, the report data, prints and the versions I’m using on the zip file.C1Report_Conversion_erro.zip

• 

  thomas.hayashi

  • Post Options:
  • Link
    Copy

  Posted 5 December 2019, 1:40 pm EST

  Actually, I’ve found the position 65, which is the tag

  “NumeroPedido='” & NumeroPedido & “’ AND Quebra='” & Quebra & “'”

  However, I could not tweak to make it work on the C1FlexReport, is there a way to convert this ?

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 6 December 2019, 2:39 am EST

  Hello,

  I could observe the said error. However, on removing the filter expression corresponding to the subreport field in PageHeader, everything works fine and the report renders as expected.
  
  It also works fine on setting the single expression term as: ```
  
  " “[NumeroPedido] = '” & [NumeroPedido] & “'”

  
  Refer the attached report. 
  
  Thanks,
  Esha 
  [zip filename="Conversion.zip"]https://gccontent.blob.core.windows.net/forum-uploads/file-08501de4-bae3-4337-80a6-7af9aa69f740.zip[/zip]