Recent content by ramblinrose

SOLVED Since there were 3 possible outcomes for a Last Name search, I had to generate 3 sets of record filter possibilities which worked. A user can now search on any field or combination of fields and will get results for the prompts completed even using the soundex. if Not HasValue({?Is Last...

I changed the 'or' to 'and' and put parenthesis around the entire statement. Still does not work.

I am using Crystal Reports 2016 I have been tasked with developing a report that is based off a user performing several search options. They can search by 1 or multiple fields. I developed parameters for each field that can be searched on with the optional prompt set to true. I then added the...

We have column charts that are displaying percentage of value. The problem we are having is that not all of the charts do not total 100%. We are rounding the numbers and our customer only wants to see whole numbers. We are using Crystal Report 2016 and have CRChart. The are hundreds of carts...

Okay. There is still the issue with the original problem I posed today, but I will check this out and see where I am. Thank you again for so much of your time. This has truly been the most challenging report I have had in 15 years.

No, the only time I want to see a BAD record from a creamery driver is if it is the record that starts the sequence of a series. Most of the time this would be the way it would happen. Once a dairy is in a series they require that inspectors collect the milk for testing, until they are off the...

Very first group 647, shows 2 records before the first bad record. Dairy 101 shows 3 good records for Lab Pasteurization Count when in fact there is a bad record after the 7/9 date picked up by a creamery driver that should start them on the series and it is not shown on the report. The report...

First thing that I can see is with the removal of ({Command.drawnStamp} <= Minimum ({@Bad Record DrawnStamp}, {@Lab Test Description}) and {@Check if flagged for group} = 0) part of the suppression formula for the Details section I am getting records that are good and are before the first bad...

I had to change the suppression on the group header because what was happening was I would get results of a dairy under the previous dairy. This would happen if the group count was > 1. As far as this report goes. If you look at page 11 (District 3) Dairy 206, it only shows the group header and...

Sorry, that report is what I use to see the history. The report is attached.https://files.engineering.com/getfile.aspx?folder=46ad147c-0d32-4fe0-965d-8f3f85f8b954&file=Series_Test_Results_20181129_with_Data.rpt

Linda - I completely understand how you feel. I edited the {@cnt} and it does not work the way I need it to. That addition is counting a good record from a driver which is not what I want. See below. You can see the history of this particular dairy and see where they were on a series and than...

I heard back from our Environmental Health dept. They stated the report was exact with 1 exception. There is a dairy that had been in the series and then qualified to be out due to 3 good consecutive records and then back on again due to a bad test that was picked up by a creamery driver. I have...

I went through the validation and this report looks like it works. The difference I had with their report from another application were explained to them and it looks like the issues are on their end. I was showing this report to one of my peers and we are having a difficult time figuring out...

I have made the revision as you stated. It initially looks great! I am attaching the report for you to look at. I need to request a current listing of dairies on series from our Environmental Health dept for validation. I really do appreciate all of your efforts in helping me get this. If this...

Yes it is. I just have it commented out so I can see what is happening to the details.