| master detail report [message #454382] |
Wed, 05 May 2010 06:10  |
ahmed_samir
Messages: 61
Registered: January 2009
Location: EGYPT
|
Member |
|
|
i made master detail report ..
and it's structure is :
i made 2 frames .. one for the master table and second to the detail table ..
inside each of the two frames there is 2 repeated frames .. to put the data fields on it ..
but the problem is i need to made one papers only at the top there is the master table data and bottom will be the detail table data ..
the problem is the master table repeat more than one time .. and this is wrong !!
- how to solve this case ... ??
- is it right "" any data get it from DB u must put it in field inside repeated frame .. only coz if this field out side repeated frame it doesn't work .. "" is this idea is right ??
thanks
|
|
|
|
| Re: master detail report [message #454383 is a reply to message #454382] |
Wed, 05 May 2010 06:14  |
cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
Why have you got 4 repeating frames? You should only need 2 - one for each table. The repeating frame for detail table should be inside the repeating frame for the master table.
|
|
|
|
| Re: master detail report [message #454384 is a reply to message #454382] |
Wed, 05 May 2010 06:19 |
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
|
Senior Member |
|
|
I think you are placing the Master and Detail Repeating frames separately. The Detail Repeating frame must enclosed by the Master. So place the Detail Repeating frame with in Master Repeating frame.
And you are not correct - If we define a column by the field inside repeating frame, then it should be repeated for all values..otherwise not.
Please post the layout design of your report, then we will understand..what the problem is..
|
|
|
|
| Re: master detail report [message #454389 is a reply to message #454382] |
Wed, 05 May 2010 06:29 |
ahmed_samir
Messages: 61
Registered: January 2009
Location: EGYPT
|
Member |
|
|
this a pic of the report
the frame " 1 " is the master table
frame " 2 " is detail table ..
when i try to watch the report i found the master table repeat more than one time but i need to say some thing ..
am using sql statment to get data from 4 tables .. is mean some thing ... !! coz the is 4 or 5 fields the same data "" i mean the master table = 1 " and the othere data is changed "" i mean the detail table "
this is my sql code :
/* Formatted on 2010/05/05 12:59 (Formatter Plus v4.8.8) */
SELECT wh_ezen_info.ezen_id, wh_ezen_info.ezen_store_from,
wh_ezen_info.ezen_store_to, wh_request_info.request_id,
wh_ezen_info.ezen_date, wh_ezen_items.item_id, wh_ezen_items.ezen_id,
wh_ezen_items.ei_amount, wh_items_info.item_name,
wh_unit_info.unit_name
FROM wh_ezen_info,
wh_ezen_items,
wh_request_info,
wh_items_info,
wh_unit_info
WHERE ( (wh_ezen_info.ezen_id = wh_ezen_items.ezen_id)
AND (wh_request_info.request_id = wh_ezen_info.ezen_request_id)
AND (wh_items_info.item_id = wh_ezen_items.item_id)
AND (wh_unit_info.unit_id = wh_items_info.unit_id)
) and wh_ezen_info.ezen_id = 2
thanks for fast help
thanks
-
Attachment: 1.GIF
(Size: 5.80KB, Downloaded 858 times)
|
|
|
|
| Re: master detail report [message #454410 is a reply to message #454389] |
Wed, 05 May 2010 07:16 |
cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
1) I can't tell anything from that picture.
2) Did you put the detail repeating frame inside the master repeating frame?
3) I have no idea what this means:
ahmed_samir wrote on Wed, 05 May 2010 12:29am using sql statment to get data from 4 tables .. is mean some thing ... !! coz the is 4 or 5 fields the same data "" i mean the master table = 1 " and the othere data is changed "" i mean the detail table "
|
|
|
|
| Re: master detail report [message #454416 is a reply to message #454382] |
Wed, 05 May 2010 07:54 |
ahmed_samir
Messages: 61
Registered: January 2009
Location: EGYPT
|
Member |
|
|
2 ) i didn't
3 ) mean that the data come from more than one table .. using the listed sql statment ..
can u help me my made for me a small report show me the idea of master and detail ( no need for design just data) .. sorry for that but i really need this today ..
|
|
|
|
| Re: master detail report [message #454422 is a reply to message #454416] |
Wed, 05 May 2010 08:30 |
cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
ahmed_samir wrote on Wed, 05 May 2010 13:542 ) i didn't
Well you need to. Do that, see what happens.
Quote:
3 ) mean that the data come from more than one table .. using the listed sql statment ..
Number of tables is irrelevant.
[EDITED by LF: fixed [quote] tags]
[Updated on: Wed, 05 May 2010 11:31] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: master detail report [message #454613 is a reply to message #454383] |
Thu, 06 May 2010 08:28 |
cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
cookiemonster wrote on Wed, 05 May 2010 12:14Why have you got 4 repeating frames? You should only need 2 - one for each table. The repeating frame for detail table should be inside the repeating frame for the master table.
|
|
|
|
| Re: master detail report [message #454616 is a reply to message #454382] |
Thu, 06 May 2010 08:37 |
ahmed_samir
Messages: 61
Registered: January 2009
Location: EGYPT
|
Member |
|
|
yes .. cookiemonster
like u say before .. after i made this tip .. about using the builder ti made this case .. i find that u say right but the problem on me coz i don't know how to made it ..
thanks cookiemonster
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
