Search results for query: *

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

I don't think I stated the problem clearly: I don't want white space the size of the page footer to appear when the report extends to multiple pages. Also, the subreports I mentioned are irrelevant: I have an identical report except that there are no subreports in it, and the behavior is the...

I've read many posts on this, but none seem to apply: My page header is suppressed unconditionally; the page footer is suppressed if pageNumber > 1, and Suppress if Blank is checked. (My page footer includes subreports, but there is no change when the subreports [as entries in the main report]...

I read a post from '04. All I had to do was, under the format subreport tab under format (for the subreport), check Suppress Blank Subreport.

The result of the non-suppression is a narrow (top-to-bottom) blank area. I've minimized the width, because the subreport can grow, so the extra space is barely noticeable, but I'd still like to figure out how to eliminate it entirely.

When my subreport group header (the only non-suppressed section in the subreport) is suppressed via a suppression formula, the main report footer containing the subreport is not suppressed, even though Suppress Blank Section is checked in the main report footer Section Expert. Evidently, the...