I have a problem exporting specific solicitors for a Crystal report, which I need to group the report on. There's a glitch exporting just 1 solicitor and basing it on the "Date To" field and sorting by descending; I want to export only those with a data value of "12/31/02" and RE support tells me it's been suggested as a future solution. (That doesn't help me at all) In RE version 6 you could export multiple solicitors and each was subscripted, which you could then use in a Crystal formula. Anyway, I have a report, which has a subreport of the multiple solicitors. I need to group the report by those solicitors with a "Date To" of 12/31/02. Has anyone created a formula to subscript a field, in this case the solicitor name or Date To field. Once I get this I should be able to create another formula to group by the solicitor I want). RE won't fix the export glitch and they also told me they don't support that feature of Crystal, even though we pay for Crystal Support (what are we paying the maintenance for then?). Any help would be greatly appreciated.

What is subscripting? I use crystal rather extensively and would like to help but am not sure what you need to do.Do you want your main report based on the subreport?

What I'm trying to do is group the report on the most recent solicitor, which in this case is the solicitor with the Date To field equal to 12/31/02 (last years). RE support said I need to create a shared variable. I think the following subscripting is what they mean by a shared variable, but I could be wrong. With RE version 6, when you exported multiple solicitor names & dates, the SOLICITOR NAME & DATE TO fields exported with the field name, subscripted with 01, 02, 03, such as: Assigned Solicitor Name 01 & Assigned Solicitor Date To01 Assigned Solicitor Name 02 & Assigned Solicitor Date To02 Assigned Solicitor Name 03 & Assigned Solicitor Date To03 That being the case I was able to use the following formula and it linked the correct SOLICITOR NAME with the corresponding DATE TO field, and thus was able to group on the most current solicitor: if {Constituent.Assigned Solicitor Date To01}=Date (2002, 12, 31) then "Solicitor: "+{Constituent.Assigned Solicitor Name01} else if {Constituent.Assigned Solicitor Date To02}=Date (2002, 12, 31) then "Solicitor: "+{Constituent.Assigned Solicitor Name02} else if {Constituent.Assigned Solicitor Date To03}=Date (2002, 12, 31) then "Solicitor: The fields do not export the same way in RE 7.5, and basically I cannot define something like the most current solicitor; the formula groups the report on all the solicitors, old ones too. For example: A donor record has the following solicitors: Jane Doe, DATE FROM: 1/1/02 DATE TO: 12/31/02 Mary Smith, DATE FROM: 1/1/01 DATE TO: 12/31/01 When I group the report, the above donor is grouped under both Jane Doe and Mary Smith, because the Crystal formula cannot associate a solicitor name with a specific row in the table; it groups on all the solicitors. I've even tried modifying the formula various ways and it still doesn't work. Are you familiar with creating shared variables?

You could create a formula that concatonates solicitor name with date-to and link your subreport based on that. Or you can create group header (or footer) B, sort your solicitors by date to and place that info in the header line. Call me or better yet- can you send me a sample of what you have so far? Kate Sklodowska -------------------- Collegiate School Development Office Database Manager [Email Removed] T: 212-812-8597 F: 212-812-8514