INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Group header

Group header

(OP)


Hi!

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

Thanks.

RE: Group header

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

RE: Group header

(OP)


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.

RE: Group header

(OP)


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

RE: Group header

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

RE: Group header

(OP)
Hi.

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

RE: Group header

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

-LB

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close