Search results for query: *

I have a report using BOOK table having an ID and NAME field. When I display ID and NAME fields in the report, all values are being displayed. I have a parameter - bookid (Value is ID and Description is NAME, prompt with Description only). When I use this parameter in the report some of the...

I have to create multiple copies of a label report. I am working on Crystal Reports XI and database is Oracle. There are no number fields in the report that controls the number of copies to be printed. User has to enter the number of copies to be printed at runtime (parameter). This report has...

I need help with a report. Patients are considered to be of a specific type say, XXX when they have an value of Yes in ObsID 999999(dummy). They will have Yes for a while. Then they can be a regular patient (Obs will be No). After sometime they can again have Yes in Obs. Sample values...

I have a field with the following possible values 1) -aaa- these are ... 2) -aaa- these are ... -bbb- these are ... 3) -bbb- these are ... 4) -aaa- these are ... -bbb- these are ... -ccc- these are ... I just need to extract the portion within the hyphens and...

I am trying to create a report of patients who did not have certain kinds of appointments in a given date range. I have a main report that lists patient name,patient id, DOB, physician and location. I have a subreport that lists needed appointments the patient had(date and type of appointment)...

I have a crystal report file that uses an excel file (it is used in place of a table which cannot be created in the database right now). It is linked it to the database tables and I was able to pull the necessary information when I work from within Crystal Reports. My problem is, this crystal...

I have a report that finds the latest office visit date of patients before a given(parameter) date. I also have another report (to be used probably as a subreport) that finds all the latest observations of the patient before a given (parameter) date. What I would need now is to pass the...

I created a report using Add Command. It uses a dynamic parameter.It runs perfectly inside Crystal Reports. But once I run it inside the application (Centricity EMR)it is missing parameter values. Can anyone offer suggestions? Thanks in advance.

I have an Excel sheet which contains two columns patient name and date. I need to read this data and pull other data from an Oracle database for only the patients listed in the Excel sheet. How can this be done? Thanks in advance.

I need to find the first (and last - I got last) exam date of patient. Office Visit Date Obs Value Exam Date 1/14/2012 2/24/2012 Normal 2/24/2012 3/20/2012 4/15/2012 5/17/2012 Normal 5/17/2012 6/18/2012 Can someone please...

I have come across a similar situation as in thread767-1550027(closed).I would like to know if I can use a shared variable as a parameter for the subreport. (If you come across this post, pto160, Did you find a solution?)

I am using subreports for the first time. I need some help. I have a main report that has a column (Latest Office Visit Date)which is a formula field calculated based on two date parameters. DateFrom DateTo It gives the Latest Office Visit the patient had between the dates supplied. I have...

I have a report which has to be grouped by Patient ID. But I want the report to be sorted by Patient Name. Without programming(formulas) can this be achieved. ie. I need to override the automatic sorting on Patient ID and have the report sorted on Patient Name. Can anyone give suggestions. Thank you

I have a column that pulls a patient's latest office visit date which is based on a formula evaluated at runtime based on a Date Range parameter given. For eg. ?StartDateFrom (for eg. 2012-8-1) ?StartDateTo (for eg. 2012-8-31) LastOfficeVisit pulls the last office visit...