Search results for query: *

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

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

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

Hi, I have a two part problem: I'm using Crystal Reports 2013 and having some problems setting up the printer for this report. I'm getting the following error whenever I open up the report: "This report uses an invalid printer. The default printer will be used instead." I searched online and...

I have two formulas which are used to concatenate the name and value fields. They will show all the values in their own fields separated by commas. These two fields are in my group footer #3 along with a bunch of other fields (IntID, Interval, etc.). The issue I'm having is that if I have more...

I want my report to return the most recent data for various lab test & dates. For example: Patient|LabTest|Value|Date Test,AB|Test123|23|1/12/2015 7:00AM Test,AB|Test234|28|1/9/2015 6:15AM Test,AB|Test123|30|1/9/2015 6:15AM Test,AB|Test567|6.5|1/2/2015 5:48PM Test,AB|Test123|28|12/30/2014...

Hi, I know there is a printer log where we can get from the Event Viewer > System but I need the description themselves. I found a script to do this here but seems to need some tweaking. Const ForWriting = 2 strComputer = "." strLogfile = "C:\print.CSV" Set objFSO =...

Hi, I have a field that contains patient reports in them. I want to search for the word "Summary" in the report (which is usually in the end of these reports) and then do a search within that paragraph or two for specific keywords (which will be entered by the user). Here's what I need for this...

I have two fields (VNUM and ANUM) which may either have duplicate values between them or one of them is a null field. I'm using isnull so it will definitely return one of the values in a single column instead of two separate columns. SELECT DISTINCT PI.PIID, PI.SSN, PI.LastName, PI.FirstName...

I'm using CR XI. I have a field that contains many pipe characters in it. I want to look for a specific pattern in that field but can't figure out how to search for this properly. This is most likely due to it being a special character (bit operator?). For example, I want to search for |A|...

Hi, I have the following groups: Site Dept Resource Details section: acct # How do I display the percentage for each "resouce group" based on the number of acct # in each resource compared with the total of the other remaining resources? So as a very basic example, if we have the following...

I can't figure out what the problem is. Using SQL Server 2005 to run the below query: SELECT * FROM Explorer E JOIN ReportEvent RE ON E.ReportID = RE.ReportID JOIN Report R ON E.ReportID = R.ReportID JOIN "Order" O ON E.OrderID = O.OrderID WHERE convert(varchar(10), O.CompleteDate, 101) BETWEEN...

Hi, I want to have a parameter that will accept multiple values entered by a user separated by semi-colons. Currently, I'm using the following selection formula for sites: ({?sites}='' or ','+{table.sites}+',' in ','+Replace({?sites}," ","")+',') That works out well but now I want to do...

Hi, I can't figure out where to start on this report. We have an exams view where we want the Patient Name, medical record number, exam code, date of exam returned. The criteria is that we don't want any results returned for patients who have exams in more than one dept done on the same day. So...

I'm working on a report that will do the following: - display a specific exam code for a date range that the user will specify in the report parameter - take the resulting scheduled date and do another search for xx amount of days before and after that scheduled date - return ALL exams for that...

We have a patient view that has the following fields: Last Name & First Name which will be concatenated via a formula Medical Record Number – unique for each patient Exam Code Date of Exam Trying to put together a report that will do the following: - If a patient has an MARPT exam done, check...