Search results for query: *

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

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

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

thread766-998445 We have been able to read the first 3820 characters of a clob field using the SQL view statement below, to avoid the clob data type error and also a buffer error (when we used 4000 characters). This allows us to run a Crystal report and an application called DARTS. However...

A Subreport section suppress formula was not working with the first record, although the formula did work for a record further down. Someone suggested checking the Suppress checkbox, and that worked. Is there an explanation?

I'm attempting to create a global string variable in a formula that I place in a group section, assigning it a meaningless value such as space, and then in the detail section, assign it a value of itself followed by an itemID, then comma. The idea is to create a comma-delimited string of values...

Just in case someone has assigned more than one value to a multi-selection field in our database, I need to parse the values and treat the values as a group. To clarify: if the field were a single-selection field, I could simply make a group out of it and I'd be done, but I can't because...

A field contains values such as: , ,98, ,115,1023, --in other words, ,[number,][,number,][etc.] I tried using "split" with a count of 1 to retrieve the first number (if any), but got an error message that a formula field can't be an array. I also seemed to get an error related to...

I have a script that will pass parameters from an application to a .bat file and run it. Can a .bat file run a Crystal 9.2 report, and what is an example?

My report has Group Header 1 followed by a detail section. Each group begins on a new page. A total line containing a running total appears in Group Footer 1. About a dozen groups appear in the report. Each page has a header, detail section and total line. I have a chart in the report...

I am suppressing detail records when the numeric id of the next record is the same as the current record and the current record contains a field with a particular value. In the group section preceding the detail section, there is a summary count, but the count includes the suppressed records...

Is there a way within CR 9 of capturing the windows login id of the user running a report, instead of relying on a parameter field?

My two-part detail section, that is positioned after two groups, extends beyond the end of the page. How might I prevent this?

In a Crystal 9.2 report, there are sections whose lowest-position fields are 'Can Grow' types. When I export to Word, the lower border of the text box created from the report section is too tight, cutting off about half of the bottom edge of the bottom line of text. In order to have the text...

I have four detail sections that work together as one using overlay and suppression. Can I keep all four sections together on page breaks?