OraFAQ Forum: Reports & Discoverer » Displaying Master Record having no detail records

Home » Developer & Programmer » Reports & Discoverer » Displaying Master Record having no detail records

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Displaying Master Record having no detail records [message #183652]

Fri, 21 July 2006 14:26

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

In a report type group above or group left, if there is no data in the detail table the report builder does not display the group/master data e.g Mr. X has no transaction between the given dates then Mr. X master data will not be displayed by the group above or group left report. How we can cop with such type of problem. Would you please help me.

[Updated on: Sat, 22 July 2006 12:22]

Report message to a moderator

Re: Displaying Master Record having no detail records [message #183825 is a reply to message #183652]

Mon, 24 July 2006 01:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would OUTER JOIN help?

Report message to a moderator

Re: Displaying Master Record having no detail records [message #183866 is a reply to message #183825]

Mon, 24 July 2006 03:38

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I'm confused. Can you confirm that I have read your question correctly:
You want to hide the master if there are no detail records.

MHE

Report message to a moderator

Re: Displaying Master Record having no detail records [message #183886 is a reply to message #183866]

Mon, 24 July 2006 04:34

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There is a master record, but no detail records. Report shows nothing in this case, but OP would like to show master record -> that's what I've understood here.

Report message to a moderator

Re: Displaying Master Record having no detail records [message #184181 is a reply to message #183886]

Tue, 25 July 2006 11:32

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

Ok i am goating an example such as the customer id and customer name exist in the master record but he has not purchased any thing in given date range but the user's requirement is that when we enter the customer id and date range then customer id, customer name, his opening balance and closing balance must be displayed in the report. So i have develop a report using format group above on the table of customer and sales. Now if there is no any sales between the given dates then report does not display the customer id, customer name, opening balance, closing balance. I have tried to further clarify my problem. Would you please help me.

Report message to a moderator

Re: Displaying Master Record having no detail records [message #245419 is a reply to message #183652]

Sat, 16 June 2007 21:33

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

Now i have found the solution from a book. The solution is outer Join Marker i.e. (+);

Report message to a moderator

Re: Displaying Master Record having no detail records [message #245442 is a reply to message #245419]

Sun, 17 June 2007 04:35

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

No kidding! It took you the whole year to find the solution which I GAVE YOU in my first reply to the question ... unbelieveable!

Report message to a moderator

Previous Topic:	Navigation Controls in Reports
Next Topic:	rep-0002

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 18:29:39 CDT 2025