Recent content by PhilB2

For one set of data, January is in the right place; for another set, it appears after December. The field being reported on is a single selection field (drop-down).

I should have been clearer that the values are literal strings, not dates, and do not correspond directly to dates. For this purpose, they could be "apple, box, cat, dog, 2015, 2016, xylophone". Also, my record selection criteria include only one year.

My stacked bar graph Legend, for a row that is ordered specifically and consists mostly of month names, sorts nearly correctly for one set of data (only a straggler is out of order), but for another, January appears after December. I've read threads in Google and in Tek-Tips, to no avail.

I created a new summary field, based on the correct formula, removed the former field I had incorrectly selected, and it works now! Case closed. Thanks again.

This just in: This time, when I selected ascending order in Group Expert, Group Sort Expert became unavailable (grayed out). At least now I have my second choice working, but there seems to be no way now to enable Group Sort Expert! Strange.

Note that the Group Expert seems to require a sort to be selected (ascending, descending, specified order, original order). Wouldn't the Group Sort override that?

It didn't seem to work. I found the same item right under Report > Group Sort Expert, where I had been looking!

Thank you Charliy. There's no Group selection formula, if that's what you meant. (I've never written one). The formula for the field that is used for the group is below (I replaced actual names with "[names]". I would like the detail section to appear either in descending order by the count...

I can't get a Group to sort alphabetically, or by number of records per value. The Group is a formula field. The sort seemed random when the sort was Specific order, which I only did to try to exclude some values. When I set the sort to Descending, only 3 out of 12 values were not in correct...

I have a set of 3 groups that I need to keep together. If I select Keep Group Together for all 3 (though #3 doesn't appear to have any effect), it works unless there are more of #2 than fit on a page; in that case, it begins on the 2nd page even though there's plenty of room on the 1st page...

Similarly, I have some reports in which the chart appears at the end (footer), and I seem only to be able to place a summary in the footer. Since I print the footer separately (in color), I would like to have the sum at the end of the report as well as in the footer. Perhaps I need a second...

Perhaps if I move the chart from the header to a footer, the sum will be available? Since I'm going to print it separately anyway, that sounds like something I'll try.

I have numerous detail reports with a sum at the end (footer), but no sum in the chart, which is in the header section. I'd like to also show the sum just below the chart, since I print it separately. I would rather not make it a separate report, to avoid double-maintenance. I already have a...

My database records contain 3 date fields (call them date A, date B and date C) that may or may not contain data. If any of the dates equals a parameter date, the record is included in the Crystal9 report. I want to group the detail records in the report by Group A, Group B and Group C. If...

A Crystal 9 report uses a string parameter containing 5 digits. When I run the report and enter two values in response to the parameter prompt, the report works. The record selection formula is: not ({field name} in {?parameter}) When I run the report with a VB script (to which I...