Home » Developer & Programmer » Reports & Discoverer » master detail report
master detail report [message #454382] Wed, 05 May 2010 06:10 Go to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 345 times)
Re: master detail report [message #454410 is a reply to message #454389] Wed, 05 May 2010 07:16 Go to previous messageGo to next message
cookiemonster
Messages: 13894
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:29
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 "

Re: master detail report [message #454416 is a reply to message #454382] Wed, 05 May 2010 07:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
ahmed_samir wrote on Wed, 05 May 2010 13:54
2 ) 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 #454452 is a reply to message #454416] Wed, 05 May 2010 11:33 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ahmed_samir
can u help me my made for me a small report show me the idea of master and detail

Use report wizard; choose "Group above" (which will create master-detail layout).
Re: master detail report [message #454606 is a reply to message #454382] Thu, 06 May 2010 08:01 Go to previous messageGo to next message
ahmed_samir
Messages: 61
Registered: January 2009
Location: EGYPT
Member
thank 4 all ..

i made it like Littlefoot say ..

but i need the main idea&tips of the frame and repeated frame .. if u can

thank
Re: master detail report [message #454613 is a reply to message #454383] Thu, 06 May 2010 08:28 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
cookiemonster wrote on Wed, 05 May 2010 12:14
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 #454616 is a reply to message #454382] Thu, 06 May 2010 08:37 Go to previous messageGo to next message
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
Re: master detail report [message #454674 is a reply to message #454616] Thu, 06 May 2010 15:55 Go to previous message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Study design Wizard created, and then try to mimic it.
Previous Topic: Unable to display additional space in the parameter values (merged by CM)
Next Topic: XML Publisher Report (merged by CM)
Goto Forum:
  


Current Time: Sun Aug 09 04:04:22 CDT 2020