Hi,

I'm busy creating a report in SQL. Now usually you will have something like this:

Name
Surname
Number
ID

If the user doesn't have a Number he will leave it blank. In the report you put each of those in their own section and suppress blank sections. I know that part

My problem is what if you have something like this (Like I have now) :

Risk:-----------------Control:

Risk 1__________IRM Control
_______________IRM Control 2

_______________Application Control




Risk 2

_______________Application Control 2


That is what my report looks like now. Risk 2 and IRM control is in the same section so I can't suppress it.

I want "Application Control 2" to move into the place where IRM Control is IF it is blank. Is this at all possible?

Thanks

ps: Just ignore the underline. It's just for presentation purposes.