Hi on my report I have Secretary and Executive fields which is mapped to the same DB field but I distinguish between the two with an ID field (0 = Secreaty, 1 = Director). My problem is that for a company with both my report looks like this:
CompanyName    Secretary     Director
Test                    ABC           
                                              DEF
                                              123

how can I remove the blank space from the first row on list of Directors?


Edited by paulmcm - 26 Mar 2012 at 12:01am

Thanks for the advice, I will try what you have suggested.

lockwelle I've created my SubReport which is only returning the 1 record that I want, I've added this subreport into the details section of my main report and I'm getting the record return on each row.
You have said above "The only option that I can see is to use a subreport for the field, and to change this from a detail line to a group header or footer (so that it only appears once on the report). The subreport would print the data, and each one would be separate from the other, so they would not have a blank space at the top."
Do i create a group in my Main report and put all the fields into the header/footer of this group? Or should the group e created in the SubReport?

This is no longer an issue - I've used the RecordNumber special field to count the records in my Main report details section and added the following suppression formula to my SubReport: If RecordNumber > 1 Then True this seems to be working like i want.

Edited by paulmcm - 27 Mar 2012 at 3:19am