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?
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...
Thank you, lb. I think I can do that. I'm a bit surprised and disappointed that percentage doesn't just fall out of the insert cross-tab feature. I was beginning to like it so well.
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?
IdoMillet,
Thanks for the help; I'll use the suppress attribute option in another report. It turns out that my Group Selection Formula DOES work. When I eliminated a conflicting Record Selection Formula criterion which evidently messed me up on the "1st pass," the Group Formula did...
Budbeth,
Thanks for the "can grow" tip; I'll use it elsewhere. In this case, I've got plenty of space for characters, but the special field isn't passing all of them to the report.
Synapsevampire,
I quickly counted 244 characters, including end-of-line returns. The field name that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.