Reports with 2 queries + variable + Pb of displaying
Hello
I am new on this Forum and with Fastreport. However i'd like to submit you a problem, i have with Fastreport.
I develop a report based on 2 queries (Master/Slave).
When i execute my repport with one key defined (example : Number of order), the report displays data from both requests. I set up a parameter into slave which seems to works and corresponds to the key of MASTER query.
But when i execute with all order's number, i just i have the data from MASTER request and not SLAVE one [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> I use GROUPHeader and MasterData ... Does it someone who can help me ? Thanks in advance t.[/img]
I am new on this Forum and with Fastreport. However i'd like to submit you a problem, i have with Fastreport.
I develop a report based on 2 queries (Master/Slave).
When i execute my repport with one key defined (example : Number of order), the report displays data from both requests. I set up a parameter into slave which seems to works and corresponds to the key of MASTER query.
But when i execute with all order's number, i just i have the data from MASTER request and not SLAVE one [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> I use GROUPHeader and MasterData ... Does it someone who can help me ? Thanks in advance t.[/img]
Comments
See User's manual "2.22 Report with two data levels (master-detail)" chapter
Hej
thanks for reply. However it does not work because to use such bands, you need to have information in the same query. (at least it's what's is indicated to help manual)
Let's me explain my problem. I need to display specific information about table1 and for each element of T1, i need to display informations for table2 (1 to n and can exist of not ). So I organized my report in two requests. First about Table1, second based on table2 with parameter code from Table1.
I don't think my queries is the problem.
When i use such bands (Master and Detail) ... i had several situations.
1 - If i associated MASTER band to first request and DETAIL band to second request = No data displayed.
2 - If i associated both bands on first request = Only data for first request are displayed. Even if i placed fields of second request on DETAIL band.
3 - If i entered a code of supplier in my first request (Like code = 1234567), data of both requests were displayed ... as i whished
So i think i am close something that i would reach but i did so much tests that today i don't know where looking for ?
T.