Designer : preview errors when using parameters

Comments

• ipong

  March 2018 edited 9:52PM

  you didnt read documentation: section "Passing own connection string"
  

    public class ReportScript
    {
  
      private void _StartReport(object sender, EventArgs e)
      {
        String connection = Report.GetParameterValue("Connection").ToString();
        Report.Dictionary.Connections[0].ConnectionString = connection;
      }
    }
  
• Domi Belgium

  March 2018 edited March 2018

  Hi ipong,
  
  thanks for your fast reply, very appreciated.
  
  but this doesn't solve the problem (in designer/preview, works fine directly from the app) :
  
  

  preview3.jpg 282.5K

  preview4.jpg 78.9K
• ipong

  March 2018 edited 9:52PM

  because you send connection string via parameter, therefore, you must open with code, not designer
• Domi Belgium

  March 2018 edited 9:52PM

  the designer is called via my application therefore the parameters are sended, it could be fine that the designer takes care of the parameters in the preview mode when it's called from the appli.
• ipong

  March 2018 edited 9:52PM

  i think the documentation quite clear, do not change the connection string via parameter.
  

  // in my application
  FastReport.Report report = new FastReport.Report();
  report.Preview = previewControl1;            
  report.Load(@"d:\untitled.frx");
  report.Dictionary.Connections[0].ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\data.mdb";
  
  // run designer
  report.Design();
  
  // show in previewcontrol
  report.Show();