Recent content by gk17

I need this query modified to pull a different set of data. How do I change it so it only looks between two pipes for 8 digits/numbers exact? Here's an example of a field containing all the pipe symbols and the value I want to extract: |....|....|12345678|....|.... I want to pull 12345678. It...

Didn't know I can do that. Only come here occasionally for help. Consider it done. Star given [smile]

Many thanks for that DaveInIowa. It worked perfectly [thumbsup2]

Thanks for the reply. That seems to return the value from a static location. The value I'm looking for may not be in the same location. I was trying to find a way to match the pattern (XX-##-#######) and return that value only. I found PATINDEX but don't know how to use it. I know it looks for...

Hi, How can I extract values with a specific format from a field that has a lot of pipe "|" symbols? For example: Testing|some text here|AB-17-1234567|...|...|... The value I want is AB-17-1234567 where the first two characters (which won't always be the same) will always be a letter and the...

Hi, Tried searching here but couldn't find a solution to resolve this. I have two worksheets each with 4 columns. Most of the data are identical but we want to see what the differences are and have them highlighted on a third worksheet. If possible, anything that exists in production and not in...

Thanks LB. That did the trick. Had to repeat GH3 and then use that function in the suppression formulas for all the sections under GH3 that should not be repeated. Worked flawlessly.

Hi, We have a report that's currently displaying most of the data in Group Headers. There's 3 of them total with some split into multiple sections. GH1 has physician name, GH2 has patient name & medical record # combined, and GH3 has the patient exam #. The problem we're having is that two of...

Hi Dell, I want to give the user an option to enter in a value or values (comma separated) for the exam parameter but they may leave it blank as well (which is currently working with the way I have it set up). It's when they enter the exams or comma separated exams when the report fails to...

Yes, I set the setting to grow to see what it would look like. The examcodes are all grouped into that one field. I need it to be a separate field so I can add in the other fields. I have about 10 fields that should be on one line. Not sure if I can just add these other fields in the sholist...

I made the change for sholist and it still doesn't return any results. Just to make sure I'm on the right page, this is what I currently have: The suppression formula you provided originally is in GF 2B If I don't enter any examcode parameter, it does return data but it shows in as follows...

I updated the report and it's running now but with two problems: 1. It needs to show the details for each exam under the patient name. Since it's in the group, it's only showing the patient name. 2. If I enter a specific examcode, it shows me an error again saying the string length is less...

OK. Updated it from Group 1 to Group 2. Is it correct to say that Group 2b has the INIT formula, is suppressed and also uses the suppression formula you provided? Just want to confirm because I see from past experience that using both suppression formula and suppressing the section seems to...

Thanks for the reply. We still want to use a date range. There will be a lot of patients where they may have multiple exams in any given date range. The problem is that I don't know how to only select those patients who have a specific exam performed (with other exams on the same day) and show...

Hi, I'm trying to return patients with their exams if they have more than one exam performed on the same day. I seem to have that working but now the end user wants another modification where it only returns those patients and exams if they had a specific exam performed on that date. For...