Search results for query: *

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...

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"?

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?

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...

In spite of some effort in reading FAQs, I haven't figured out how to add a percentage column to a cross-tab report. The (simplified) report looks like this now: Female Male Total Black 4 6 10 White 16 14 30 Total 20 20 40 I'd like it to look like...

After logging on to Crystal Reports and successfully opening a previously-saved report, I opened a report that had the Database -- Show SQL Query grayed out; I can't select that option. What gives?

It appears that there is a size limitation on Insert -- Field Object -- Special Field -- Record Selection Formula. Is this true and can it be increased? E.g., although I successfully created a record selection statement of 6 lines, almost all of the 6th line is truncated when printing the report.

I have inserted this statement in my Group Formula Editor, but it doesn't have the desired results: Maximum ({SIBINST.SIBINST_TERM_CODE_EFF}, {@NameLastFirstID}) = {SIBINST.SIBINST_TERM_CODE_EFF} AND {SIBINST.SIBINST_FCST_CODE} = "AC" I am trying to identify the row in SIBINST...

This code in the Record Selection Formula editor (embedded in other selection criteria) does NOT return rows with null values, as I would expect: ({SARAPPD.SARAPPD_APDC_CODE} = '01' OR {SARAPPD.SARAPPD_APDC_CODE} = '05' OR IsNull ({SARAPPD.SARAPPD_APDC_CODE})) When I place the IsNull condition...

When I print ID and address code I get this output: 198621755 PR @00004399 MA @00004399 PR I want my output to be: 198621755 PR @00004399 MA In other words, how can I instruct crystal reports to print ID & address code IF a row with that ID has a code of MA; however, if the ID has no row...

In the Record Selection Formula Editor of my Crystal Report, Prospective Students by Major v5, the formula ends with: ((IsNull ({SARAPPD.SARAPPD_APDC_CODE}) OR {SARAPPD.SARAPPD_APDC_CODE} = '01' OR {SARAPPD.SARAPPD_APDC_CODE} = '05') AND Next ({SPRIDEN.SPRIDEN_ID}) <> {SPRIDEN.SPRIDEN_ID}) -----...

My Crystal Report, Prospective Students by Major v5, truncates the Special Field, Record Selection Formula or “Rec Slct Formula:” after “…1.00 AND”. Why? Are there too many characters? ----- Before truncation: ----- {SARADAP.SARADAP_TERM_CODE_ENTRY} = {?Entry Term} AND...