Search results for query: *

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

EDIT: Deleted prior reply... I was able to get this working perfectly now. Just wanted to mention the solution that resolved this. I used the method mentioned by the OP here and that worked with some tweaking in the suppression formula to exclude false return values. Thanks everyone.

Not yet. I took a look at it but didn't get to test it out yet. Still new to using shared variables or variables in general. Will see if I have some time to try this out next week at work. Thanks.

I have a report that has a group header and fields in the details section. There is also a sub-report in the footer. Currently, it's returning all the data for those fields. I want to suppress the details in the main report if the subreport has no records. I tried searching online on how to do...

Hi, I have a report with 4 groups: Physician Facility Exam Billing Code The columns for this report are broken down into "patient types" like Outpatient or Inpatient. In my original report, I did not have the Billing Code group (was added in recently) and I just used a formula to filter out...

Hi, I'm using SAP BI Platform to export reports that are in PDF format to a local folder that's shared. The problem is that these PDF reports/files are constantly locked and is preventing any overwriting. I have to use Share and Storage Management to remove those locks every time and I do see...