Inherited reports and persistensein database

Comments

• AlexTZ

  July 2009 edited 6:09AM

  Hello,
  
  You need to implement the report.LoadBaseReport event.
  

  FReport.LoadBaseReport += new CustomLoadEventHandler(FReport_LoadBaseReport);
  
  private void FReport_LoadBaseReport(object sender, CustomLoadEventArgs e)
  {
    // e.FileName contains the name of base report. It may be the file name, or an ID in the database,
    // it depends on how you load the main report
    e.Report.Load(@"d:\fr.net\demos\reports\" + e.FileName);
  }
  
• danni Denmark

  July 2009 edited 6:09AM

  Hello
  
  I have implemented the environmentSettings_CustomOpenDialog and environmentSettings_CustomOpenReport evnet.
  
  This is where I add the event, but the event is never called when I press newInheritedReport.
  

  private void FrmReportdesigner_Load(object sender, EventArgs e)
  {
         SplashController.StartSplashLoadingData("Henter data til rapportdesigner...");            
  
         ResigerData(_currentReport);
         designerControl.Report = _currentReport;
         _currentReport.LoadBaseReport += new CustomLoadEventHandler(CurrentReport_LoadBaseReport);
         designerControl.RefreshLayout();
              
         SplashController.StopSplash();
  }
  

  
  
  

  AlexTZ wrote: »

  Hello,
  
  You need to implement the report.LoadBaseReport event.
  

  FReport.LoadBaseReport += new CustomLoadEventHandler(FReport_LoadBaseReport);
  
  private void FReport_LoadBaseReport(object sender, CustomLoadEventArgs e)
  {
    // e.FileName contains the name of base report. It may be the file name, or an ID in the database,
    // it depends on how you load the main report
    e.Report.Load(@"d:\fr.net\demos\reports\" + e.FileName);
  }
  
• AlexTZ

  July 2009 edited 6:09AM

  Try to use the LoadBaseReport event in your CustomLoadReport event handler:
  
  // wire up event
  e.Report.LoadBaseReport += new CustomLoadEventHandler(CurrentReport_LoadBaseReport);
  
  // load the main report
  e.Report.Load(...);
  
  // unwire event
  e.Report.LoadBaseReport -= new CustomLoadEventHandler(CurrentReport_LoadBaseReport);
  
• danni Denmark

  July 2009 edited July 2009

  It is not when im loading an existing inherited report. But I can see a challenge there aswell.
  
  It is when i want to create a new inherited report.
  
  when i create a new inherited report the only event thats beeing called is the event environmentSettings_CustomOpenDialog.
  
  
  the eventhandler environmentSettings_CustomOpenDialog, should know if its a basereport or just a normal report thats beeing opened. SO i can call loadReport or loadBaseReport. But I cannot see how its can done.
• AlexTZ

  July 2009 edited 6:09AM

  wrote:

  This is where I add the event, but the event is never called when I press newInheritedReport.

  
  I've tried to do the same, and the event is called. Could you make a simple demo for me?
• danni Denmark

  July 2009 edited 6:09AM

  I can attatch the CustomreportDesigner.cs file if that can help you?
  
  
  

  customDesigner.txt 5.8K
• AlexTZ

  July 2009 edited 6:09AM

  I need a simple demo that I can compile and debug.
  For example, if I modify the Demo.exe source in the following way:
  

      private void DesignReport()
      {
        FReport.LoadBaseReport += new CustomLoadEventHandler(FReport_LoadBaseReport);
        FReport.Design();
      }
  
      void FReport_LoadBaseReport(object sender, CustomLoadEventArgs e)
      {
        throw new Exception("The method or operation is not implemented.");
      }
  

  
  I see that the event handler is called when I do "New inherited report".
• danni Denmark

  July 2009 edited 6:09AM

  Hi again.
  
  I have made a fast example where I have done the following:
  
  1. added the designer control to a form.
  2. added environments to the designer and oimplemented the open/save methods with a simple messagebox only.
  3. added a loadbaseReport event to the designer.report in the Form.Load evnethandler
  
  
  The message "loadignbaseReport..." is never shown.
  
  

  FRTestDesigner.rar 2.7M
• AlexTZ

  July 2009 edited July 2009

  The reason is simple: your opendialog event handler is empty. You don't provide a report name in this event. Since the name is not provided (empty), the LoadBaseReport event is never gets called - because there is nothing to load.
  
  Modify the code in the following way, and the LoadBaseReport event will fired:
  

          private void environmentSettings1_CustomOpenDialog(object sender, FastReport.Design.OpenSaveDialogEventArgs e)
          {
              MessageBox.Show("OpenDialog...");
              e.FileName = @"d:\1.frx";
          }
  
• danni Denmark

  July 2009 edited 6:09AM

  Ahh, simple soultion :-)
  
  I use the e.Data Property in the openDialog handler to provide the reportID from the database into the custon openReport. But I will try using the filename insted ans see what happens.
  
  Thank you :-)
• danni Denmark

  July 2009 edited 6:09AM

  Okay... this means the designer does not support loading basereports other than from a file.
  
  1. If i specify a "dummy" filename. The designer throws a FileNotFoundException.
  2. if I specify the report ID from the database as filename I get an invalid fileformat
• AlexTZ

  July 2009 edited 6:09AM

  No, it does [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> - In the CustomOpenDialog event you return a "filename" in the e.FileName parameter. It may be either a file name, or something else (for example, database row ID). - In the CustomOpenReport or LoadBaseReport events, you handle loading a report from a location specified in the e.FileName parameter. It depends on what your CustomOpenDialog returns. If you work with database, treat e.FileName as a row ID.[/img]
• danni Denmark

  July 2009 edited July 2009

  if I add a rowID as filename i get the error in the attached file.
  
  I add the following: e.Filename = 14 + "";
  
  Then I get the error below.
  
  Is there a property I need to set to ignore true filenames in the "e.Filename"?
  

  FRError.png 401.6K
• AlexTZ

  July 2009 edited 6:09AM

  14 + "" would generate a compiler error [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Here is what I do and it works well for me:[/img]

      void DesignerSettings_CustomOpenDialog(object sender, OpenSaveDialogEventArgs e)
      {
        e.FileName = @"myfile:d:\1.frx";
      }
  
      void DesignerSettings_CustomOpenReport(object sender, OpenSaveReportEventArgs e)
      {
        if (e.FileName.StartsWith("myfile:"))
        {
          string fileName = e.FileName.Remove(0, "myfile:".Length);
          e.Report.Load(fileName);
        }
      }
  

  
  Looks like I need another test project from you
• danni Denmark

  July 2009 edited 6:09AM

  Yes, when using a real filename it works fine.
  
  BUT when i use id's to a database and save/load reports to a string it fails.
  
  Try use an id insted of a filename.
• AlexTZ

  July 2009 edited 6:09AM

  As you can see what I use is not a file name - it's a kind of ID. Yes, finally it becomes a file name, but this is just to demonstrate that the technique is working well.
• danni Denmark

  July 2009 edited July 2009

  I worked out some magic.
  
  I had this beautifull line except it looked like this (uncommented) he he
  //designerControl.Report.LoadBaseReport += new CustomLoadEventHandler(Report_LoadBaseReport);
  
  Now I can create a new inherited report.
  
  
  Next: [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> I cannot save the report. How do I do that? my report.BaseReport is "14" - the id of the baseReport, which is great. thank you for your patience with me[/img]
• AlexTZ

  July 2009 edited 6:09AM

  I will prepare a new demo under Demos\C# folder. I think it will be useful to others who want to store their reports in a database.
• danni Denmark

  July 2009 edited July 2009

  I think so too.
  
  please include the load/save with inheritance aswell. Thats the only problem I have left in the designer apart from a few restrictions in the designer :-)
  
  I have no problem saving the report but when i open it again i have no small locks on the fields from the inherited report. As if I loose the conenction with the basereport when I save it to the database.
• AlexTZ

  July 2009 edited 6:09AM

  I've added CustomOpenSaveDialogs demo (under Demos\C# folder). And fixed some errors in the fastreport.dll [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> The fixed version will be available in 6 hours.[/img]
• danni Denmark

  August 2009 edited 6:09AM

  Hi Alex
  
  Back from summer holidays.
  
  Can I pass an ID from a report in my database as e.Filename in report_LoadBaseReport now?
  
  I'm not too sure how to load the base and inherited report when storing reports in a database.
  
  Thanks
• AlexTZ

  August 2009 edited August 2009

  Hello,
  
  Please look at the C#\Demos\CustomOpenSaveDialogs demo. It does exactly what you need (in fact, this demo was written for you
• danni Denmark

  October 2009 edited 6:09AM

  Hi Alex
  
  I have used your example against the xml file. Iit works very well against databases now.
  
  Thanks! :-)