Recent content by bhfmc

In 8.5 I just wrote my first 2 Formula Fields (FF) using a "For loop." The FF's work great EXCEPT when I try to concatenate them into another FF on which one of my Groups is (grouped and) sorted. The error message I get is "Group specified on a non-recurring field." Just printing these 2 FF's in...

In CR 8.5 a table has been altered after a somewhat extensive report was written. The table is joined to a number of other tables in the report. The new version of this table includes a new field which I want to include on the report, but that field and other new fields are not visible to me...

In Crystal Reports 8.5.0, somehow, in typing notes in Report Footer c, I managed to merge all of Report Footer c into Report Footer b, making the footer too long for CR, I imagine. This has rendered my report virtually useless. When I try to view the extra text in Report Footer b, I get this...

Turkbear and Synapsevampire, I reintalled CR 8.5 and re-recreated the shortcut. filling in the "Start in" blank with: "C:\Program Files\Seagate Software\Crystal Reports\crw32". This didn't do the trick. When right-clicking Group Header #2a and choosing Change Group... I get this prompt...

Thank you, Turkbear. I tried to do what you suggested, with the same poor results. I created a shortcut icon and in the shortcut tab of Properties, I filled in the previously blank "Start in" box with: c:\WINDOWS\Prefetch\CRW32.EXE-22A217D6.pf Was this what you intended? Any other suggestions?

When in the Design tab of CR 8.5.0, I right click and use "Change Group..." to choose a sort on a different formula field for either Group Header #1a and/or Group Header #2a. When I click on the Preview tab, Microsoft closes out CR with this message: "Crystal Reports has encountered a problem...

In CR 8.5, my database has names lists in a single NAME field, First Middle Last Suffix, e.g., John Q. Public II Eve Mary Ellen Smith Joe Blow John Carl Normal I want to create 3 formula fields that would parse this single string into LAST, FIRST & MIDDLE+SUFFIX. This would allow sorting on...

This formula field, Seq Number: If IsNull ({SEQ_NO}) then "n" else If {SEQ_NO} = 1 then "-" else ToText ({SEQ_NO}) returns a "2.00" if the value of {SEQ_NO} is "2". How can I alter this to return the integer format of "2"?

Sorry for being so vague. My field is in Group Header 1. The data actually contains over 200 names. I would like to see these names in one long "paragraph" in mircosoft word, without any paragraph "carriage returns" embedded, so that the number of names per line would be...

I have an 8.5 CR with a single field containing names: Joe Blow Jane Doe John Doe John Q. Public I want to print-- export that information into paragraph form with microsoft word: Joe Blow, Jane Doe, John Doe, John Q. Public How can I do that? Can I use excel in an intermediate step?

dave and k, Thank you for the quick response. I adapted Ken Hamady's formula with success. Thank you synapsevampire once again!

How do I calculate a parameter field, @Age, given a parameter field, @Date-on-which-age-is-calculated, and a data field, BIRTHDATE? CR 8.5.

In CR 8.5, I definded a formula field, {@Credit Hours Hold} as follows: "Sum ({SFRSTCR.SFRSTCR_CREDIT_HR_HOLD},{@CAPSName})" where {CAPSName} is the formula field by which the only group is sorted. After using {@Credit Hours Hold} in another formula field, {@Full-time Part-time Hrs}...

Is it possible to create, in effect, a system-wide set of formula and parameter fields? I'd like to have these defined in one report, then access them from a number of other reports. For example, I'd like to input term-value in a parameter field, then use the corresponding date value from the...

LB, I'd like to take the plunge from 8.5 to 9.0, but I don't want to drown in a flood of alterations that are necessary in order to maintain the format of existing .rpt files. I'd be a bit more courageous about this move if someone could assure me that percentages within cross-tab 9.0 is as...