Grouping records with same parameters

[kbrown73]

Crystal 8.5, ODBC, Access Database

I have a client (charitable) that assists their clients by paying utility bills in time of hardship. They will pay several utility bills with one check. I have created a database for inputing clients and their assists. While creating a yearly report for FEMA I need to group the data based on the Date, then check number. The clients need to be grouped under their appropriate check num without printing the individual header info. Here is what I need:

Date Check1 Payee Total Amt
Voucher1 Client Name
Voucher2 Client Name
Voucher3 Client Name

Date Check2 Payee Total Amt
Voucher4 Client Name
Voucher5 Client Name

Above is two separate detail lines. Currently, I am getting this:

Date Check1 Payee Total Amt
Voucher1 Client Name
Date Check1 Payee Total Amt
Voucher2 Client Name
Date Check3 Payee Total Amt
Voucher3 Client Name

 

[lbass]

Make sure you have entered your groups in the right order. Go to report->change group expert and make sure your groups are:
date
check

If they are reversed, use the arrow key to toggle date into the topmost position.

-LB

 

[synapsevampire]

Does this " They will pay several utility bills with one check" mean that they pay several utility checks per person?

Try posting example data and the required output based on that data.

-k

 

[kskid]

If it's like our City, it's one check to a utility company covering several people so LB's solution should work

-LW

 

[synapsevampire]

Since LBs solution is exactly what they said they've tried, I'd guess there's more to the picture, Witchita.

They might need to also group by the individual and display rows in the group header of it.

-k

 

[kbrown73]

Thanks for your suggestions...I actually solved another way. Since the checks will be written in order, I grouped by Check first, then manuevering the fields into the proper headings gets me the results that I need.

Thanks again.

 

[copperkitten]

Good day.I just only want to know How will i display the contents of two 2 different tables which are not related to each other in a crystal report 8.5.Everytime i place the fields of two tables on the details section. It only displays the contents of one table but not the other.I would like to display the contents of two tables or more because these are needed in the report.Please help me how to do it.Thanks.ASAP please.

 

[kskid]

This post should be another thread since it is not even related to this post but you can create a subreport with the 2nd table and place it in the main report Report Footer.

-LW