Recent content by kthacher

No, I did not change any requirements. I did not ask to accumulate 2 rows of a group. I want to display Account footers (GF2) for the first two Customer_Types (GF1) but not for the last two Customer_Types, as I stated in my original post above and my second post. I want to do this while still...

Thanks for the help on aggregating, but I think my problem is that the order of my data changes in the section where I have suppressed the Account grouping so things aren't aggregating correctly. Here is how the report is organized. These are all Group Footers. Details are hidden. This is for...

Using CR 8.5 I have a report with several groups: Accounting_Period, Sub-Account, Account, and Customer_Type. Accounting_Period and Sub-Account are hidden. For presentation purposes, the report needs to show Accounts within Customer_Type for the first two Customer_Types but hide the Accounts...

I am resurrecting this thread because I have a new problem. Thank you llbass for your previous help. It worked perfectly for my monthly report. New problem is that I need a year-to-date version. Also there is an additional grouping: Sub-account, account, and now Customer Type which would be the...

Sorry, I answered my own question through trial and error. The above did work after some tweaking.

Thanks. So far so good. Now I've discovered a new problem with the Maximum formulas. Some of the Account/sub-account combinations have a negative budget (credits to the customer). So the Maximum returns 0 instead of (21) for example. I think I can create a new formula for the group footers...

You are correct, I don't know how to sum the maximums. And I don't know how to use variables very well either. So I'm guessing I'd make the three new formulas you show (creating them in the regular formula window?) And then just place them on the report as new fields? Will try that tomorrow...

Using Crystal 8.5 I'm attempting to get rid of some running totals (per a previous thread). I have two tables, Revenue and Budget. The report is to show total Revenue $, total Budget $, and variance for each account/sub-account combination. The problem is that there are many revenue records per...

No, I'm not trying to show multiple sub-accounts. Just one sub-account but multiple accounts. Also, each account/sub-account combination could have multiple transactions so I don't want to show detail lines of each transaction. The result for my above sample data would be: Account Sub Rev...

I apologize for not detailing the whole report. I'm using running totals to pick up a budget amount from a second table. Since there are multiple revenue transaction records per account but only one budget record, the budget amounts were being duplicated for each transaction record. The running...

satinsilhouette--No, I don't want the 10,000 to show up when I am reporting on sub-account 0550 only. lbass--I took the Sub-Account out of Select Expert, changed the price formula as you stated, and put {table.subaccount} = "0550" in the group expert. Now I am getting the entire $10,500 as...

Using CR8, I am reporting sales in $ and units, then calculating an average sales price. Each sales account represents a class of customers--residential, commercial, etc. There are sub-accounts within the $ sales accounts that represent various types of revenue--accruals for unbilled...

Thank you for the suggestion but I don't actually know how to use Access; I just dumped the Budget there so Crystal could pull data from it. I did have the problem of not being able to link the Lawson and Access data within Crystal, that's why I went to subreports. These Crystal reports will...

Using CR 8.5 I have created two subreports. One has Account Numbers and Actual Amounts from our Lawson software database. The other has Account Numbers and Budget Amounts from an Access database. Now I want the main report to show Account Number, Actual, Budget,and Variance by obtaining all...

Thank you LB and Lisa. This makes sense. I didn't know I could put the subreport in the group header. I thought it had to be next to the main report fields which are in the group footer. Kathy