Hello Folks,
                    I have this client report which has a subreport in it with parameters defined in it such as start date, end date, client code and Group name.
                   Now the problem is for a specific startdate,end date,client code and group name if the corresponding Client doesnt have files for specified month then the report comes back by displaying a blank page.
                   My requirement is that i have to atleast display the Client Name and Client Code in the header top part of the report which doesnt have data for that specific month. Why does the report comes as a blank? To my understanding it should atleast show the client name,client code, start date nd end date. Can anybody please throw some light on this.




Thanks

It's the outer join that will return what you want.  Outer joins return all of one side of the select and the matching part of the other...let's say you have a left outer join like this: