Search results for query: *

I have ONE table where there are 3 independent name fields: name (lastname, first name) lname (last name) fname (first name) I am looking for ALL mismatches whatever they are. Using Crytal Reports XI will the following work (research for a friend)? {TABLE1.NAME} <> {table1.lname} + " , " +...

CRXI and SQL database I have similar reports with varying lengths of detail pages but the last 2 pages are filled with summary crosstabs where I do not want a specific field in the page header to display. I have tried suppressing with the following formula: OnLastRecord and...

MonoSpaced Text CRXI and SQL I have read various threads on this but my brain can never figure out what to do with my crosstab to make this work. My report is an insurance profile that runs each month and shows the type of insurances, the number of clients with that insurance and the percent...

CRXI with SQL I have a report that is grouped by ConsumerID and EpisodeEndDate that shows the number of times a person was discharge within a Fiscal Year and some detail about types and number of services provided. I have a formula for the LOS (length of stay) for each episode of care for each...

CRXI and SQL I have a report that is group by supervisors and report specific data for employees under them. I have the employee name visible in the header with their data displaying on their own page. Sometimes there would be an extra page at the end of the group so I put in a formula to...

CRXI with SQL database I have no experience with parameters but I am trying to create a simple report and I am lost. Using one table with client information I would like to create a simple report that will display the clients case number and date of birth after the user has specified the...

CRXI and SQL Server I have a report that I want to select records by the appointment dates in our scheduler tables. I want to automate it to run on a wednesday but choose all the clients who are scheduled for Dr. appts for the next week (M-F). It is run now by a person manually selecting the...

SQL and CRXI A current report shows a variety of demographic data by client that is used for verification and updating at our "fornt window." The only problem is a particular grouping of information re: contact information repeats out of order and I dont know how to make it stay together. It's...

CRXI and SQL I am using the Hamady Case Flow report that shows for a given time period the number of open cases at the start and at the end of the report time period. It also shows cases opened and closed during the report time period. There are also parameters for the user to define the...

CRXI and SQL My question is about being able to shorten report processing time. I have a report that has 7 groupings and displays a current case load per provider. It is 63 pages long and sorts by "team" and "provider." It has 10 coumns of information pertaining to each person listed on the...

CRXI and SQL 2000 I have the following stored procedure which works fine except for a small detail I need. I did not write this nor have I worked with SPs much. Any help is appreciated! This currently creates 12 months of data that I display in a crosstab. However the column heading only...

CRXI and SQL I have a report that shows various providers and the services they perform. It is currently sorted ascending by the average # of days to service documentation 0 days to 14 days. there are additional columns of data one which shows the total number of services during the same time...

CRXI using SQL database This report shows certain types of appointments for the day with the Provider, appt type, client name, time, anc various associate fields related to authorizations (auth ID number, name of auth cluster, start date, end date, units authorized, units left. Currently all...

CRXI with SQL I have a crosstab that displays a productivity percentage for each employee. It has 12 monthly columns. When staff are hired or leave there may be 0.0 for several months as their productivity percentage. Since they were not employed those months 0.0 would not be correct. Is there...

Using CRXI - SQL I have created a crosstab that shows 5 colums of data and subtotals by group. The first four columns totals SUM the respective column data. The 5th column is a productivity percentage created by embedding a formula from the report data into the text header of the crosstab...

CRXI and SQL I have two reports with same table in both. One field start_date is datetime in one report and just date in the second report. I tried changing it to datetime for the second report but it does not give me the option to do this. How is this possible? I need datetime for both reports.

CRXI - SQL server I currently us the above as a formula that displays in the report header. However, I need it to be the actual date range selected for the report. With my formula it shows the min and max of data within the date range. My current forumla is @DateRange: "For the Period " +...

CRXI with SQL Svr I have a report that shows a graph of all initial assessments per month. All consumers have a unique ID but may have several episodes of care. Each episode of care includes an initial assessment. Each episode also has a unique ID. This first report is just fine for its purpose...

I received help with this previously but that thread is now closed. I needed to underline all annual assessment dates in a report that were in due during the next month. The report is run at the first of the month (such as November) but the annual assessment dates that occur during December...

Crystal XI with SQL database I have the formula below in a report to act as a prompt to a provider to close a consumer based on various lapse times from a last service. I now want to count how many records have been flagged as a total count and also to show what percentage of all of the...