Group header

[ejastia]

Hi!

I would like to group numbers 1 to 10 only. Not a field. What formula will I use?

Thanks.

 

[lbass]

You need to explain more about what you are trying to do. What is the purpose of grouping on numbers 1 to 10? Would you be adding any other groups? Would the 1-10 group be Group #1?

-LB

 

[ejastia]

I want the report to be like this:

voucher no. payee
1 Mary
2 John
3
4
5 Allan
6 May
7 Lori
8 Pam
9
10 Eman


I want to see in report if there are missing voucher nos. If payee appears blank, it means that the voucher no. is not yet entered. And I also want voucher no to be a parameter.

Thank you.

 

[ejastia]

I want to display voucher numbers that is not in database. Thanks.

 

[lbass]

First create a number parameter {?Max} and then create a formula {@cnt} and insert a group on it:

whilereadingrecords;
numbervar cnt;

if cnt <= {?Max}-1 then
cnt := cnt + 1;
cnt

Next insert a subreport with the voucher and payee fields into the {@cnt} group header. Then go to edit->subreport links and link {@cnt} to the voucher # in the subreport.

Another solution would be to allow only the paid vouchers to display, but create a formula that would appear in the report footer that shows the missing voucher numbers. Let me know if you want to try that solution.

-LB

 

[ejastia]

Hi.

It didn't work. I prefer your post in other thread. Thank you so much.

 

[lbass]

It worked when I tested it, so I wonder how you implemented it.

-LB