Master Detail Slow Preview

Comments

• AlexTZ

  April 2010 edited 4:58PM

  Hello,
  
  Try set the master databand's PrintIfDetailEmpty property to true.
• ueden

  April 2010 edited April 2010

  Now it takes 5 minutes instead of 10 minutes for 50 pages.
  Thanks, but still not good...
  
  Any other advice, please?
  
  Update:
  
  I tried filter out data in my application, than call FR and the result was 1 page .... but still 5 minutes :-(
  So it seems on some processing problem.
  
  I have also filter on 2 attributes on. As I have experienced, filtering out data in FR causes some more slowness.
  
  50 pages - 5 mins
  1 page - 5 mins
• AlexTZ

  April 2010 edited 4:58PM

  Looks like your detail datasource has large amount of rows. Do the following:
  - run the designer;
  - go to the Data window;
  - select your detail datasource;
  - press "View Data..." button on the toolbar;
  - at the bottom of the window, you will see the number of rows. How many rows do you see?
• ueden

  April 2010 edited 4:58PM

  Hi,
  
  following your steps, there is more than 600 000 rows, but after running report it displays only 1 page.
  
  I think the problem is in selectCommand property.
  
  My selectCommand property on Master table in FR is set to:
  select EVIDENCNE_CISLO,BEZNE_CISLO,DATUM_DODANIA,DATUM_REZERVA,PL_DATUM,VP_DATUM,DATUM_POSLEDNE_HLASENIE,CISLO_POLOZKY_VYR_PRIKAZU,TP_POSTUP_COUNTER,case when KOOPERACIA='T' then 1 else 0 end as KOOPERACIA,overt09.fn$get_popis_no_char(KOOPERANT_POPIS,255,' ') as KOOPERANT_POPIS,OP_TYP,overt09.fn$get_popis_no_char(OP_POPIS,255,' ') as OP_POPIS,MT_TYP,overt09.fn$get_popis_no_char(MT_POPIS,255,' ') as MT_POPIS,TP_PORADIE,overt09.fn$get_popis_no_char(SB_POPIS,255,' ') as SB_POPIS,SB_CISLO_STREDISKA_VP,PL_MNOZSTVO,PL_MNOZSTVO_SETUP,OP_KAPACITA_PL,PL_CENA_STROJA,SB_STREDISKO_VP,MNOZSTVO_KOOP_NA_VP,VP_MNOZSTVO,DELTA_MNOZSTVO_VP,OP_CAS,OP_CAS_JEDNOTKA,OP_CAS_MANIP,OP_KAPACITA_HL,OP_KAPACITA_VP,OB_POOL_ID,PLAN_ID,REST_KOOP_NA_VP,HL_CENA_STROJA,HL_MNOZSTVO,HL_MNOZSTVO_SETUP,DELTA_MNOZSTVO_HL,DELTA_MNOZSTVO_SETUP_HL,DELTA_MNOZSTVO_SETUP_VP,VP_MNOZSTVO_SETUP,VP_OP_CAS,VP_OP_CAS_CELKOM,VP_OP_CAS_MANIP,VP_OP_CAS_MANIP_CELKOM,VYR_POOL_ID,TP_NEXT_OP_PORADIE,TP_POSTUP_D_ID,TP_POSTUP_M_ID,TP_PREV_OP_PORADIE,TP_ZOZNAM_ID from OVERT09.VW$PL_PREHLAD_PLAN_VP_SINGLE where ARCHIVOVANE='F' and DELTA_MNOZSTVO_HL LIKE '%70%'
  
  In demo application I tried to edit this property for SIMPLE LIST report to: Select * from Employees Where LastName='Dodsworth'
  But it seems, that FR ignores this property and displays all rows, not only for Dodsworth.

  ---

  It seems that FR fills up all the tables with all data and after that calls selectCommand property.
  
  Juraj
  
  
  
• AlexTZ

  April 2010 edited 4:58PM

  Hello,
  
  Could you send me the report file? tz@fast-report.com
  In the demo app, changing SelectCommand property has no effect because the data is from xml file.
• ueden

  April 2010 edited 4:58PM

  Hi,
  
  just sent.
  
  Juraj