Scripting inside report

[drechema]

Hello,

I am running netcore 3 in Mac OSX

I made a simple report using Designer Community following documentation. The Script C# looks like this inside the .frx file:

<ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
    private void EstadoResultado_BeforePrint(object sender, EventArgs e)
    {
      if (((Int16)Report.GetColumnValue(&quot;demo&quot;)) &gt; 0) {
        Demo.TextColor = Color.Red;
      }
    }
  }
}
</ScriptText>

The report works fine in Preview from Designer Community.

I developed a simple Web API project using netcore 3.1 following one of your samples. The API use PDFSimpleExport to generate a PDF from report:

            report.Prepare();
            PDFSimpleExport pdf = new PDFSimpleExport();
            MemoryStream memStream = new MemoryStream();
            report.Export(pdf, memStream);

This code works perfectly with a report with no Scripting. But if I try with the before scripted report I have:

An unhandled exception has occurred while executing the request.
FastReport.Utils.CompilerException: (21,24): Error CS0012: The type 'Color' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Drawing.Primitives, Version=4.2.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
(21,36): Error CS0103: The name 'Color' does not exist in the current context

   at FastReport.Code.AssemblyDescriptor.InternalCompile()
   at FastReport.Code.AssemblyDescriptor.Compile()
   at FastReport.Report.Compile()
   at FastReport.Report.Prepare(Boolean append)
   at FastReport.Report.Prepare()

How can we add the reference to that assembly? How can we add the needed assembly referenced in the Report Script? Everything inside the Script is pure NetCore, I mean will run in any paltform?

Thanks

[drechema]

Tested with netcore2.1 framework and get same error

[drechema]

I also try in Windows and get same error

[KirillKornienko]

Hello! We fixed this error in the last MR #178. Nuget package version: 2020.2.9 (https://www.nuget.org/packages/FastReport.OpenSource/2020.2.9). Please, try this changes and share your opinion.

[drechema]

Hello @KirillKornienko,
I have tested with release 2020.2.9 and works perfect !! Thanks a lot for your help

But after ... I tried to make more in the Script and I get this new error :-(

Exception has occurred: CLR/FastReport.Utils.CompilerException
An unhandled exception has occurred 'FastReport.Utils.CompilerException' in FastReport.dll
(83,22): Error CS0012: The type 'CollectionBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Collections.NonGeneric, Version=4.1.2.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
(89,29): Error CS0012: The type 'IDynamicMetaObjectProvider' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Dynamic.Runtime, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
(109,21): Error CS0012: The type 'CollectionBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Collections.NonGeneric, Version=4.1.2.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
(89,8): Error CS0012: The type 'IDynamicMetaObjectProvider' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Dynamic.Runtime, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
(116,22): Error CS0012: The type 'CollectionBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Collections.NonGeneric, Version=4.1.2.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.'
   en FastReport.Code.AssemblyDescriptor.InternalCompile()
   en FastReport.Code.AssemblyDescriptor.Compile()
   en FastReport.Report.Compile()
   en FastReport.Report.Prepare(Boolean append)
   en FastReport.Report.Prepare()

It seems quite similar problem... I don't know if I am doing something wrong...

[KirillKornienko]

Please, send us your sample report (*.frx) with this bug.

[drechema]

I have prepared a .frx that throw this error
demo-win.frx.zip

I only added a function dealing with lists and arrays like this one:

  private void AddTable(List<string[]> table){
     TableObject tbl = new TableObject();
     for (int icol=0;icol<4;icol++){
       TableColumn col = new TableColumn();
       tbl.Columns.Add(col);          
     }
     foreach (var row in table){
       TableRow tr = new TableRow();
       tr.AutoSize = true;
       for (int icol=0;icol<4;icol++) {
         TableCell tc = new TableCell();
         tc.Text = row[icol];
         tr.AddChild(tc);        
       }
       tbl.Rows.Add(tr);
     }
     tbl.Bounds = new RectangleF(NombrePrueba.Left, NombrePrueba.Bottom, Units.Centimeters * 10, Units.Centimeters * 0.5f);
     tbl.CanGrow = true; 
     tbl.Top = 18;
     DatosOrden.Objects.Add(tbl);    
   }

Thanks!

[drechema]

The above report runs fine form the designer (well... it's no pretty but works) but throw the error at Prepare method if is launched from code

[KirillKornienko]

Hello! In the latest update 2020.3.0, we fixed this problem. Please, try this changes and share your opinion.

[KirillKornienko]

Hello @drechema. Yes, dotnet add package FastReport.Compat --version 2020.3.2 before OpenSource version. This package is specified in the dependencies FastReport.OpenSource. It's strange that it does not load automatically.

[drechema]

Yes!! It's working
After install this packages

dotnet add package FastReport.OpenSource --version 2020.3.1
dotnet add package FastReport.Compat --version 2020.3.2

the project is running and the report is showed !!
Thanks a lot !!

[drechema]

@KirillKornienko everything works good but let me go ahead. What I need if a want to use another third party library inside the Report?

I tested adding:

using Newtonsoft.Json.Linq;

And then I have an exception:

An unhandled exception has occurred while executing the request.
FastReport.Utils.CompilerException: (13,6): Error CS0246: The type or namespace name 'Newtonsoft' could not be found (are you missing a using directive or an assembly reference?)

   at FastReport.Code.AssemblyDescriptor.InternalCompile()

But Newtonsoft.Json.dll exist in the bin directory. Should I include the library in the project using nuget or similar?

Thanks again for your work

[KirillKornienko]

@drechema In the last update we made the automatic addition of assembly if they are known to .Net. In case of unknown assemblies, please add (do not replace) them in Report.ReferencedAssemblies before preparing the report (before Report.Prepare()).

[drechema]

Thanks, I think that the issue is closed !