Master Detail Slow Preview

ueden

Hi,

i have a problem with Preview feature in my application that is using FastReports .Net for generating reports.
Problem is, that it takes about 10 minutes to display results.

DB Query itself is fast enough - it takes about 1 minute, but after getting data status of Report generator display something about generating page 1.
And it takes for 10 minutes resulting into 90 pages.

I have 2 data tables in dataset, one is Master, second is Detail and also Relation between them. So i have created master-detail databand structure following demo application. It seems that problem is caused by this master-detail structure, specially Relation. If I generate report without master detail it is fast enough.

Database size is round 6GB, MSSQL Server 2000, WIN XP.

Simply, master-detail report is very slow.



Can you help, please?

Juraj

AlexTZ

Hello,

Try set the master databand's PrintIfDetailEmpty property to true.

ueden

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

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

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

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

Hi,

just sent.

Juraj