BUG in preview

Comments

• ipong

  April 2018 edited 10:12PM

  google topic about MSChart (Microsoft Chart), learn how to use it
• Domi Belgium

  April 2018 edited April 2018

  
  It doesn't use any Chart, that's why I have posted this problem.
  
  here is the report.
  
  Sincerly,
  Domi
  
  

  Plan_des_comptes.frx 26.5K
• ipong

  April 2018 edited 10:12PM

  you didn't attach the msaccess database...
  
  you must debug it from designer.exe, open the frx file, at report start event, you can set 'dummy parameter value' with code.
  for instance: Report.SetParameterValue("@appli.copyright", "Test");
  
  then run it, is it working? error?
• Domi Belgium

  May 2018 edited 10:12PM

  Hi,
  
  I have put the code in the StartReport but it's never fired (MessageBox is never displayed) ! I have missed something maybe ?
  
  

  fr1.jpg 263.8K
• ipong

  May 2018 edited 10:12PM

  open frx file with notepad, make sure that event is registered:
  
  <Report ScriptLanguage="CSharp" StartReportEvent="_StartReport">
• Domi Belgium

  May 2018 edited May 2018

  I had already checked that, of course :
  
  

  fr2.jpg 179.6K
• Domi Belgium

  May 2018 edited 10:12PM

  Not yet solved
  
  here is the new report, can you indicate why the _StartReport & Page1_StartPage are never fired ? (if necessar, I can provide the .mdb but the problem occurs before)
  
  thanks in advance,
  Domi.
  
  

  Plan_des_comptes.frx 19.9K
• ipong

  May 2018 edited May 2018

  open frx file with notepad:
  
  1. DO NOT USE DOT SEPARATOR IN PARAMETER NAME, because dot separator is internally reserved by fastreport for [TABLENAME.FIELDNAME]
  
  change :
  @Appli.connstring to paramconnstring
  @Appli.copyright to paramcopyright
  @Societe.raisonsociale to paramraisonsociale
  @Societe.DateDebEx to paramDateDebEx
  @Societe.DateFinEx to paramDateFinEx
  
  or using underscore is fine too, @Appli_connstring, try it
  
  then make a correction to :
  - related textobject in the report
  - script for declaring dummy value
  
  2. LOOK AT PARAMETER SECTION

      <Parameter Name="@Appli.connstring" DataType="System.String">
        <Parameter Name="Parameter" DataType="System.String"/>
        <Parameter Name="Parameter1" DataType="System.String"/>
      </Parameter>
      <Parameter Name="@Societe.raisonsociale" DataType="System.String">
        <Parameter Name="Parameter" DataType="System.String"/>
      </Parameter>
  

  
  replace with :
  <Parameter Name="paramconnstring" DataType="System.String"/>
  <Parameter Name="paramraisonsociale" DataType="System.String"/>
• Domi Belgium

  May 2018 edited May 2018

  Hi,
  
  thanks for your fast reply.
  
  I have made the requested modifications (and the methods Form1_Load and _StartReport are now reached) and I get my first error back :
  
  Exception in Chart handling
  Failed to compare two elements in the array
  ....
  
  although, I don't use any chart in the report (as you can see in the .fpx you have)
  
  Any idea ?
  Tkx,
  Domi.
• ipong

  May 2018 edited May 2018

  I suspect 2 problems :
  
  1. open with notepad => relation between 2 tables : parent/child datasource IS NULL, here is the cause of error 'Failed to compare two elements in the array'
  
  Delete it :

      <Relation Name="Lign_Comptes" ParentDataSource="null" ChildDataSource="Comptes" ParentColumns="NUMC" ChildColumns="COMP" Enabled="true"/>
      <Relation Name="Comptes_Lign" ParentDataSource="Comptes" ChildDataSource="null" ParentColumns="COMP" ChildColumns="NUMC" Enabled="true"/>
  

  
  2. textobject with binary datasource, Cell33 is linked to field LETT => <Column Name="LETT" DataType="System.Byte"/>

  <TableCell Name="Cell33" Text="[Comptes.LETT]" VertAlign="Center" Font="Arial, 7pt"/>