FR3 to FRX

Comments

• ipong

  February 2019 edited February 2019

  push dataset from .net winforms/wpf => report.RegisterData(dataSet);
  
  and the frx file will automatically add :

    <Dictionary>
      <TableDataSource Name="Employees" ReferenceName="Data.Employees" DataType="System.Int32" Enabled="true">
        <Column Name="ID" DataType="System.Int32"/>
        <Column Name="Name" DataType="System.String"/>
      </TableDataSource>
    </Dictionary>
  

  
  fr.net internally process :
  1. TableDataSource => push datatable/dataset to fastreport, or
  2. BusinessObjectDataSource => push bussiness object or array to fastreport
• dpedrelli

  February 2019 edited 7:39AM

  The original FR3 report has a dataset call "fsData"
  If I call report.RegisterData(dataSet); or report.RegisterData(dataSet, "fsData");
  I get errors that "(fsDataBillCity): Error CS0103: The name 'fsData' does not exist in the current context." The same thing happens if I manually add the dictionary to the FRX file. Do I need to change something else?
  
  Thanks.
  
  

  ipong wrote: »

  push dataset from .net winforms/wpf => report.RegisterData(dataSet);
  
  and the frx file will automatically add :

    <Dictionary>
      <TableDataSource Name="Employees" ReferenceName="Data.Employees" DataType="System.Int32" Enabled="true">
        <Column Name="ID" DataType="System.Int32"/>
        <Column Name="Name" DataType="System.String"/>
      </TableDataSource>
    </Dictionary>
  

  
  fr.net internally process :
  1. TableDataSource => push datatable/dataset to fastreport, or
  2. BusinessObjectDataSource => push bussiness object or array to fastreport
• ipong

  February 2019 edited 7:39AM

  you have to match between
  1. in data source : TableName.FieldName, and
  2. in textobject : [Employees.ID] => tablename = Employees and fieldname = ID
  
• dpedrelli

  February 2019 edited 7:39AM

  My FR3 looks like this:

  <Datasets>
      <item DataSet="fsData" DataSetName="fsData"/>
    </Datasets>
  
  <TfrxMemoView Name="fsDataInvoiceNumber" Left="105.6" Top="0" Width="86.4" Height="19.2" DataField="InvoiceNumber" DataSet="fsData" DataSetName="fsData" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[fsData."InvoiceNumber"]"/>
  

  
  How should I rewrite that for FRX?

  <Dictionary>
      <TableDataSource Name="fsData" ReferenceName="fsData" DataType="System.Int32" Enabled="true">
        <Column Name="InvoiceNumber" DataType="System.String"/>
      </TableDataSource>
    </Dictionary>
  
  <TextObject Name="fsDataInvoiceNumber" Left="105.60" Top="0" Width="86.40" Height="19.20" Font="Arial, 9pt" Text="[fsData.InvoiceNumber]" Padding="2, 1, 2, 1" HorzAlign="Left" VertAlign="Top" TextFill.Color="0, 0, 0"/>
  

  
  Is that correct for the DataSource? Do I need to changed the properties on the TextObject?
  
  Thanks,
  
  David
  
  
  

  ipong wrote: »

  you have to match between
  1. in data source : TableName.FieldName, and
  2. in textobject : [Employees.ID] => tablename = Employees and fieldname = ID
• ipong

  February 2019 edited 7:39AM

  correct, take a look at fr.net demo
  

        // create simple dataset with one table
        FDataSet = new DataSet();
  
        DataTable table = new DataTable();
        table.TableName = "Employees";
        FDataSet.Tables.Add(table);
  
        table.Columns.Add("ID", typeof(int));
        table.Columns.Add("Name", typeof(string));
  
        table.Rows.Add(1, "Andrew Fuller");
        table.Rows.Add(2, "Nancy Davolio");
        table.Rows.Add(3, "Margaret Peacock");
  
        // create report instance
        Report report = new Report();
  
        // register the dataset
        report.RegisterData(FDataSet);
  
        // enable the "Employees" datasource programmatically. 
        // You can also do this in the "Report|Choose Report Data..." menu.
        report.GetDataSource("Employees").Enabled = true;
  
        // design the report
        report.Design();
  

  
  and the frx file

    <Dictionary>
      <TableDataSource Name="Employees" ReferenceName="Data.Employees" DataType="System.Int32" Enabled="true">
        <Column Name="ID" DataType="System.Int32"/>
        <Column Name="Name" DataType="System.String"/>
      </TableDataSource>
    </Dictionary>
    <ReportPage Name="Page1">
      <DataBand Name="Data1" Top="74.15" Width="718.2" Height="18.9" DataSource="Employees">
        <TextObject Name="Text1" Width="94.5" Height="18.9" Text="[Employees.ID]"/>
        <TextObject Name="Text3" Left="103.95" Width="198.45" Height="18.9" Text="[Employees.Name]"/>
      </DataBand>
    </ReportPage>
  
• ces_jc

  February 2020

  Where can I Download fr3tofrx.exe, could you help me please.
• gpi

  February 2020

  http://www.fast-report.com/pbc_download/files/fr3tofrx.exe
• pcordero

  May 2020

  I cannot download that please help me! :)
• Anatoly

  May 2020

  https://www.fast-report.com/pbc_download/fr3tofrx.exe