Search results for query: *

Hello lbass, Your instructions and code worked perfectly (as always)! Super job. Would never have come up with this on my own in 100 years. Thanks again, Rooski

Hi lbass, Thank you for the quick response. I will set this up, try it out, and let you know the outcome. Regards, Rooski

Hello to All, I am using Crystal Reports Version 10. I have created a conventional crosstab with employee serial number in the rows and with unit of assignment in the columns. There are about 20 units of assignment in total. I am counting issued traffic tickets in the summary field. It is...

I just tried kray4660's suggestion of sorting on Len(Remarks). I sorted in descending order and placed the remarks field in the group header. That displayed the output I was seeking in my last response. Good suggestion. So please do not look further into this issue as it has been resolved...

There is only one group in the report and, no, the results don't have to be in a group header section. All I want is for the longest remark (and its length) for each officer in the database to appear on the report. I only said they should appear in the group header as it seemed the most...

Hi, I am using CR10 against an MS 2010 Access Database. This is a project database and for each project number in the database, the project officer will enter remarks that are stored in a Remarks table. The relationship is a one to many between the project number and the associated remarks...

Hi LB, Adding the owner to the sql expression made all the difference. I was then able to make everything else work using your other formulas and produce a crosstab. Once I got that far, I knew how to make the percentage appear in the crosstab by simply adding the {@summaryformula} to the...

Hi LB, Once again, I am running into the same compile error message as yesterday. I first added the code exactly as you indicated: ( select max("Related_Offense") from "INPER6_VIEW" A where A."Report_No" = "INPER6_VIEW"."Report_No" ) I then changed max("Related_Offense") to...

Hi LB, I apologize for not getting back sooner, but I had a higher priority project cross my desk. First, to answer your question about: That was my error. I had changed the evaluation formula in the running totals, but did so incorrectly. They are now working fine and I can generate...

To simplify things, I produced a sample report for just white and black. Eventually, I would like to produce the report grouped by patrol division of which there are six. Incidents % of Total Incidents Total 1000...

Hi LB, Thank you for the help. You were right, as long as I didn't supress any records in the running total formulas, counts were produced. As soon as I changed the formulas to count only records in the groups where the person was a SUSPECT or an ARRESTEE, then the counts became zeroes...

Thanks for the reply. Your suggestion worked quite well. In fact, before I had submitted my question, I had included your very same concept in my report except my group selection formula lacked {table.incident#}. Having gotten this far, what I am really after is summarizing these incidents...

I am running Crystal V10 using an Oracle database. What I am trying to do is include all detail records in a group based on the value of a field that may be present in only one of the detail records. Think of this as the opposite of suppression. I found many threads regarding how to...

Thank you for your very quick response. This looks like the breakthrough I needed. I'll let you know how it works after a test. Based on a walk-through of the 00 hour formula using the 01:45 - 03:45 example, I believe time is being added to the 00 hour formula when it shouldn't. But I...

I am using Crystal 10 with an Oracle database for a law enforcement 9-1-1 report. The report needs to accumulate committed time of all officers for area by hour-of-day for a three month period. The chart below shows what the report should look like, except there will be 24 hours going across...

LB, My SQL skills are limited at best and I didn't even know the Command feature existed in Crystal. But I followed your instructions and, after some tinkering and verification testing, managed to create a working version of your suggested SQL solution. That is a very valuable piece of code...

I have looked extensively through the Crystal forums, but could find nothing that relates to the situation below. I am using Crystal 10 against an Oracle database. The report I am trying to create will look, by way of example, like this: Hour # of # of of One-Officer...

HOA, Thanks for responding to my request for help. I just returned to the office this morning after the long holiday weekend. Your assumption about the data type of TDateRevised is correct. (Actually, the data type is date/time.) I used you coding suggestions and that made all the...

I am using Microsoft Access 2000. The code below resides in a subform. Using the DMax command, strRevisionDate is loaded with the largest TDateRevised value that can be found in tblTDateRevision for a given Project Number. The SQL statement then updates the field SupervisorTDateRevised (found...

PH, The information found in the support link you provided solved my problems. I was guilty of using the subform name rather than the subform control name when attempting to reference the combobox. What tripped me up for awhile in applying the solution was remembering how to find the value of...