Search results for query: *

Ngolem, I discovered that if I change my gh1 formula from an older version (that used the reason_into_col as a group name determination) to one that uses my parameter ?CENTER as the group name, in the group header window, CR changed the field to group on to another field, it decides to use the...

Thanks for the hint. I went back and LOOKEd at my group header 1 definition. Somehow, (it wasnt ME, to coin a movie phrase) the field that it was trying to group had been changed to the reason_into_col field. Weird. Anyway, I deleted and started over, and it apparently works just fine now...

GH1:ReportSelect If {?Center} = 'HOPKINS' then 'HOPKINS' ELSE IF {?Center} = 'PORTLAND' THEN 'PORTLAND' ELSE IF {?Center} = 'ALL' THEN 'TOTAL SBLC' ELSE 'MILWAUKEE' with ?Center being a string of 4...

I get a message : GROUP SPECIFIED ON A NONRECURRING FIELD What did I do? lgb

Thanks for the ideas. lgb

My rpt has 4 headers. GH1:Site Name(formula based on a number value:ie,Milwaukee is 01 or 02 or 03, Portland is 04 or 05) GH2: Bank Number 1 GH3: ORG TYPE 1 GH4: RISK Rating 1 detail outstanding bal Risk Rating 2 detail outstanding bal ORG...

I have a report to which I added a subreport which gives me total outstandings by state. It works fine. I link to state in the main report and I get the subtotals correctly. I run the report , look at it, looks great. But, when I go to export the rpt, the whole data gathering runs again...

This has to be too simple...but it's friday afternoon... I have to select a memo field (I know...) based on the update date in the same table for every selected account on the report. I want the memo from the most recent date. How do I do that? Thanks.. lgb

Rosemary, I looked at the subreport tabs (and the online help). When I look at Main Rpt FORMAT;format subreport;subreport tab, the CHECK BOX for reimport is checked but it's grayed out. I can't change it. I looked also at the SUBREPORT file options menu;new report; that check box is blank for...

I have a report to which I added a subreport which gives me total outstandings by state. It works fine. I link to state in the main report and I get the subtotals correctly. I run the report , look at it, etc. When I go to export the rpt, the dang thing runs again. It doesn't matter if I have...

The user wants the STATE totals regardless of GROUP1. also, 'one more set'? of formulas? YOu mean, create a set of sum formulas for each state? thanks. lgb and oops I had a typo in the example: EX: ABC ACTIVE CA 1 2000 2 1000 Total Ca 3000 IA 1 3000 2 1000 Total IA 4000 Total...

I have 2 groups. Group1 is by Site and Type (ABC Active, ABC Matured). Group2 is by @state (alpha from a formula that converts from number). The report selection is all records and I have a group selection of greater than 31 days past due. So, I get 82000 records but only 2000 or so display. I...

Oh, I get it. But, what about the multiple groups and subtotals question? I still have that problem. lgb

I'm reading with interest this thread. I'm confused. In which formula does this go: If InRepeatedGroupHeader then x:=x else x:=0 I was looking for the exact problem solution but I have multiple groups. I set up 2 sets of 3 formulas as indicated.(I omit grand totals right now for...

I have a rpt that requires percentage of total. I have no stored procedure. My database report select is further modified by a group select, elimination of zero balances and some specific other things. I created running totals based on both the group1 and group2 balance and outstanding...