Search results for query: *

It was our bad. The field name had been dropped into the group header rather than the group name. Thanks for the help!

We tried that. It doesn't work. The remaining groups are still being grouped under the heading others. We're going to try some other things to circumvent it, but this is definitely a problem in the software.

I have a Crystal 8.5 report which has part of it being grouped on a team field. I've had it sort this group to display in a specified order by named groups. In the Others tab of the group options window I've selected "Put All others in the group named:" and typed in "Other". In spite of...

You rock my world! That worked PERFECTLY! Thank you so much!

*gnaws on Mouse cord* Recently reintroduced to querying SQL, and at an absolute loss on how to get it to only feed me records for the 12 months prior to the current month (last 12 full months in other words)based on a datetime field in the database. I can get it to do this year and last year...

It was resolved with a tech support email to business objects. I had to make a duplicate datasource and repoint all the db and table connections to that. It was a lengthy process, but it worked.

It hasn't changed. I can open the report in 8.5 and it's fine. I also tried to verify and save, it chokes on the verify just like it does in preview.

We just installed Crystal Reports v 10. Upon opening a report created in 8.5 and trying to preview it, I get sent into a string of verify database messages like the following: Upon clicking through I eventually get to an updated message: Clicking through this starts the messages all over...

Ok, the problem with this is that the field being displayed in the report can't be totalled. It's a text field. I have a function which is stripping the text out of it and converting it to a number. So how do I do a running total based on that?

I'm very much a beginner, I have no idea how to do what you've just said. [bugeyed]

ShortyA: That option is unchecked. Madawc: How will that make charting it work? The big issue here is that the person requesting the report needs it charted in monthly increments for a rolling 12 months for each of 3 main survey responses. I've managed to set the report parameters to only pull...

*Blechs at the billion typos.* Should remember to preview before I submit.

Ok, removing the "while printing records" allowed me to do the sum stuff, but now my charts are going berserk. What I've got to chart these scores on a monthly basis, which I had working, except the values were skewed by the nulls prior. So Now I've writted a couple formulas, one called...

Ok, I guess I'm confused, because I can't do a sum on that formula. Crystal wont let me. (I'm in version 8.5)

Ok, will this work when I'm trying to chart it? I need to average the total scores in a field. Right now it's averaging the nulls in as well.

I need a means of counting only the number of records which do not have a null in a specific field. ie, there needs to be a value of 1-5 in Field X for the record to be counted. I then need the total number of these non-null records. Any idea how to accomplish this?

That appears to have worked! I'll continue testing it to be sure, but it looks correct!

Crystal reports 8.5 dilemma. I'm at my wits end here. I've tried to set up a record sort to only show records from the last 12 months, but although it worked the last time I had the report open, now whenever I refresh the data it goes back to drawing records from all the way back to April of...

Thank you shelby! There was no "This section will be printed" but when I changed to the date field from the table, there was an option for "Cart values shown for" and I selected "each month"! Thanks for the help!

It's still not sorting properly. Now I get this: It's sorting by month but not taking the year into consideration before sorting.