Home » Developer & Programmer » Reports & Discoverer » Displaying Master Record having no detail records
Displaying Master Record having no detail records [message #183652] Fri, 21 July 2006 14:26 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would OUTER JOIN help?
Re: Displaying Master Record having no detail records [message #183866 is a reply to message #183825] Mon, 24 July 2006 03:38 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: Displaying Master Record having no detail records [message #183886 is a reply to message #183866] Mon, 24 July 2006 04:34 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: Displaying Master Record having no detail records [message #184181 is a reply to message #183886] Tue, 25 July 2006 11:32 Go to previous messageGo to next message
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.
Re: Displaying Master Record having no detail records [message #245419 is a reply to message #183652] Sat, 16 June 2007 21:33 Go to previous messageGo to next message
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. (+);
Re: Displaying Master Record having no detail records [message #245442 is a reply to message #245419] Sun, 17 June 2007 04:35 Go to previous message
Littlefoot
Messages: 20891
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!
Previous Topic: Navigation Controls in Reports
Next Topic: rep-0002
Goto Forum:
  


Current Time: Sun Dec 04 02:17:22 CST 2016

Total time taken to generate the page: 0.08910 seconds