subbie1268
Programmer
First off, I would like to thank all you guys out there that respond to peoples posts, I pretty much learned how to do subreports and other things in crystal just by reading other peoples questions they had and answers that were provided. So Thanks again, any help on this will be greatly appreciated, because I have been stressing trying to figure this out, I will try to be detailed as possible.
I have created a billing statement report, on the first group of the report I have billing contact information and total balance due, the second is a detail break down of the charges using the 0-30, 31-60, 61-90, 90+. The third group has running total fields of the 0-30, 31-60, 61-90, 90+ and also another field that says total balance(same forumla as the one in group 1). The original problem I had (which I still have) is that the total balance in the first group is not correct if a person has more than one charge, I have realized why because it is only grabbing the value of the first record, because the second group hasnt been run. However the 3rd groups total balance works great.
I have read the forms and I saw some similar questions, and peoples answers where to do subreports. So I started researching on here and in crystals help about subreports, and I created one. It came out nice, I checked all the data and it looks good. I did the shared variables, everything looks good. In the subreport I have 2 groups the customer number and 2nd group is a balance field. I have a running total occuring on the balance that breaks on change of customer number. My problem is now the shared variables I put on the main report are only grabbing the data from the first entries on the sub report. Here is an example and I will just build the first group since that is the problem area
Main Report Layout
Customer #
Customer Name Total Balance Due
Address1
Address2
City,State Zip
Subreport Layout
Customer #, Customer Bal, Running Total(customer bal)
Data Example (first 2 records from main report and sub report)
Main Report:
43311
John Smith
234 Main St Total Balace: $75.00
Suite: 101
Miami, Fl 33193
48970
Jack Dawson
544 Main St Total Balace: $75.00
Suite: 500
Miami, Fl 33193
Sub Report:
43311, 25.00, 75.00 (2 charges 1 is 50, 2nd is 25 so total is 75)
48970, 15.00, 50.00 (same as above jsut different amounts)
The problem is that the second bill still is carrying over the balance of the first guy even tho when I look at the subreport the correct balance for him is 50.00.
I have trie to due an array but what occurs on the print out is that only 1 person is getting a total balance printed on the top. Is it possible to get the correct balances from the subreport to appear on the main report rather than looping te first balance on to every one?
Perhaps what I am trying to do is not possible or I am approaching it in a way that is not logical, I am open to any idea and suggestions and anything will be appreciated. I hope I have provided enough information and at the same time havent caused you to fall asleep. Thanks again for your time.
I have created a billing statement report, on the first group of the report I have billing contact information and total balance due, the second is a detail break down of the charges using the 0-30, 31-60, 61-90, 90+. The third group has running total fields of the 0-30, 31-60, 61-90, 90+ and also another field that says total balance(same forumla as the one in group 1). The original problem I had (which I still have) is that the total balance in the first group is not correct if a person has more than one charge, I have realized why because it is only grabbing the value of the first record, because the second group hasnt been run. However the 3rd groups total balance works great.
I have read the forms and I saw some similar questions, and peoples answers where to do subreports. So I started researching on here and in crystals help about subreports, and I created one. It came out nice, I checked all the data and it looks good. I did the shared variables, everything looks good. In the subreport I have 2 groups the customer number and 2nd group is a balance field. I have a running total occuring on the balance that breaks on change of customer number. My problem is now the shared variables I put on the main report are only grabbing the data from the first entries on the sub report. Here is an example and I will just build the first group since that is the problem area
Main Report Layout
Customer #
Customer Name Total Balance Due
Address1
Address2
City,State Zip
Subreport Layout
Customer #, Customer Bal, Running Total(customer bal)
Data Example (first 2 records from main report and sub report)
Main Report:
43311
John Smith
234 Main St Total Balace: $75.00
Suite: 101
Miami, Fl 33193
48970
Jack Dawson
544 Main St Total Balace: $75.00
Suite: 500
Miami, Fl 33193
Sub Report:
43311, 25.00, 75.00 (2 charges 1 is 50, 2nd is 25 so total is 75)
48970, 15.00, 50.00 (same as above jsut different amounts)
The problem is that the second bill still is carrying over the balance of the first guy even tho when I look at the subreport the correct balance for him is 50.00.
I have trie to due an array but what occurs on the print out is that only 1 person is getting a total balance printed on the top. Is it possible to get the correct balances from the subreport to appear on the main report rather than looping te first balance on to every one?
Perhaps what I am trying to do is not possible or I am approaching it in a way that is not logical, I am open to any idea and suggestions and anything will be appreciated. I hope I have provided enough information and at the same time havent caused you to fall asleep. Thanks again for your time.