Dviding report into horizontal sections

[Buckaroo8]

I need a report that lists people accroding to a specific number of days, formatted in a vertical fashion:

7 days
John Abalone
John Whorfin

14 days
John Emdall
John SmallBerries

21 days
John YaYa
John O'Connor

So how do you do it? Create three groups according to the 'day' criteria? Is there one detail section or three? Is a show/suppress trick? Could it be done in a columnar format?
Please help.

 

[synapsevampire]

Create a formula for the day period to be used as a group (you were too vague with fields/version/database to help much here).

Place the fields in the details, it should be what you're after.

Example of a group formula:

if currentdate-{table.date} <= 7 then
&quot;7 Days&quot;
else
if currentdate-{table.date} <= 14 then
&quot;14 days&quot;
else
&quot;21 days or more&quot;

-k

 

[Buckaroo8]

Thanks for the help. Sorry about the incompleteness of my question(v8.5). However, I went with using SubReports for each specified time period. It may not be the most efficient, but it looks a though it may get the job done.

If anyone has a suggestion of how to achieve the same without subreports, I wouyld appreciate it!

Thanks.

 

[Ngolem]

synapsevampire just did and you are ignoring his advice.

Look....you have given us almost no information and expect us to solve your problem. SV suggested a formula for creating a group. In my opinion that is the simplest method and should work well.....BUT WE HAVE NO INFORMATION...so his approach is the best unless there are other problems that you are hiding.

Jim Broadbent