Master - detail problem

Comments

• gpi

  September 2011 edited 2:09PM

  You should reopen detail dataset in MasterData OnBeforePrint event or use correct detail SQL like
  
  select * from detail_table where id = :id
• Petter S.

  September 2011 edited 2:09PM

  gpi wrote: »

  You should reopen detail dataset in MasterData OnBeforePrint event or use correct detail SQL like
  
  select * from detail_table where id = :id

  
  Thanks.
  
  My detail SQL looks basicly just like this...
  
  So I tried the OBP-event of Masterdata band (IBXQuery1):
  
  IBXQuery2.Close;
  IBXQuery2.Open;
  (also tried to add IBXQuery2.First)
  
  What then happens is that the report ends when it was supposed to print the second master's details. And the rest of the masterdata is not printed...
• gpi

  September 2011 edited 2:09PM

  Try

  IBXQuery2.Close;
  //set query parameter here
  IBXQuery2.Open;
  

  Create and attach demo report template based on employee.gdb database
• Petter S.

  September 2011 edited 2:09PM

  gpi wrote: »

  Try

  IBXQuery2.Close;
  //set query parameter here
  IBXQuery2.Open;
  

  Create and attach demo report template based on employee.gdb database

  
  Thanks again.
  
  Now it's working. The OBP-event open/close code actually solved my problem, without the need of resetting parameters there.
  
  The reason why the report ended after the second masterdata-print, was that this masterdata record had no details. So I checked the Masterdata.PrintIfDetailEmpty, and now it works like expected.
  
  Maybe is it a bug that causes the report to end instead of forwarding to next record in masterdata when Masterdata.PrintIfDetailEmpty=false?