Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to force a group with 0 records appear in the report?

Status
Not open for further replies.

Corres

Technical User
Jun 13, 2006
87
CA
CR2008, Oracle 10

The client wants to see the groups with 0 records appear in the report. I was trying to insert a query in the command line containing all values of the group and then link them. But it does not work.

Please give me idea how to do it.
Thank you very much!
 
You must have a table which contains data for all th groups you require, then left join fromthis new table to your existing data. Then group on a field from the new table.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top