Search results for query: *

Hello all... I am using Crystal reports 2011. I have a range of string values for example C00* to C43* that I need to capture. "IN" alone does not seem to get them all(ie. Table.field IN 'C00*' to 'C43*'). It seems to stop at C43 with out picking up any values such as C43110. IS there any way to...

Good day to all, I am using Crystal 2011 with SQL database. I have historical visit data on patients. I want to pull patients that have a patient type of "ONC" if they came to the ER (patient type "ED") within 30 days following their "ONC" visit. I was thinking I might have to do a main and a...

Hello all, I am using Crystal 2011 with an Access 2010 database. I would like to know if there is a way that I can take a list of people and break them up easily from top to bottom into 10 even classes. The problem is that the total number of people is not known until registration is done, so...

Good day all, I am using Crystal 2011 with a SQL2008 DB. I will try to explain my problem. I am pulling insurance info on patient accounts using shared string variables to extract the Primary payor ({@primary}) and the secondary payor ({@secondary}). The report is grouped on invoice number and...

Hello all... Using Crystal Reports 2011 and SQL2008 DB. I have built a report that prompts for Fiscal year(?FiscalYr) and Period(?FiscalPd). Fiscal periods are 1 through 12. Based on the period selected the select formula({FISCAL_PERIOD.ped_no} <= {?Fiscal Period}) grabs the balance for each...

Using Crystal 2011 Thanks for your assistance in advance... I am trying to select the height based on the highest encounter id for the account. The data (simplified for example)looks like this: Account[tab]Encounter_ID[tab]Ht_In 116284[tab][tab][tab]2[tab][tab][tab][tab]60...

Hi all and thanks in advance for your help. I am using CR 2011 having trouble supressing duplicates or row inflation. I'm puling allergies on patients by allergy type id (ie. Med allergy type = 4714, Food = 4715, etc.).I am using formula fields in the detail section to pull the allergies for the...

Good day all, Thanks for your help in advance! I need some advice on how I might construct a query from the following information. I have table of accounts and names, etc. that looks like this: AcctNum Name 234567 Joe Cool 567891 Jane Doe I am going to join it to an Insurance table that...

Hello all, I have an IIF statement on a form that inserts different fees based on the type of account chosen in another field on the form. The IIf statement looks like this... =IIf([6th Week]="C",175,IIf([6th Week]="D",90,IIf([6th Week]="W",45,IIf([6th Week]="WD",45,IIf([6th...

I have received a data request that I think will require 2 queries to complete. I have been asked to provide a list of accounts and insurance payments. The list will be limited to accounts that have SC Medicaid as a secondary insurance. That part is easy and the pertinent criteria and data...

Good day all, I have a database of accounts. Each account has a unique number. Multiple transactions are stored for each account and the transactions have unique codes to identify them. So if I query an account I may see 10 records for that one account showing each transaction. What I need to...

Hello, As an example let's say I have query that produces these results for one person: Name Days Money Bill 0 10 Bill 2 20 Bill 0 50 Bill 1 30 Bill 3 40 The report is sorted and grouped by Name with a...

I have a "like" operator in a parameter query that allows the user to specify a partial name that then returns all like names. For example, when prompted for a name if the user types Smith* he gets all records of all Smiths. My question is what would be the easiest way at that point to allow the...

Hello all, I wil try to explain this as best as I can. I need to show the different results in a field (HCPCS) as 1 record instead of multiple records without duplications. Here is example of the query returning single records with the criteria based on the HCPCS Type field: Procedure Desc...

I have a table with a concatenated name field that I need to separate into First, Last, and MI in a query. The problem is one of inconsistent data entry. Here are some samples: Name BELL,FRED J BLACK,MATTHEW PLUMBERG, ANDY BEALS IV,JOHN C Here are the strings I am using: Last Name...

I am producing a departmental report that looks like the below example. If the Total Dept calculation is 0 for both amounts I would like to skip or supress the detail for that department to reduce the size of the report. If the calculation produces a total for either or both amounts the detail...

After using Datepart on a date field to isolate the month is there a function or simple way to display the number's text equivalent?(Ie. 7 is "July" or 1 is "January") Thanks in advance!

Hello all, I have a field of names that may or may not contain middle names and/or initials. Field content example is as follows: Ramsey,Jonathan David Smith,Elizabeth No space before or after the comma... always a space between first and middle name/initial if there is one.I am trying to...

Hi all, I need to take a column of numbers (for example use 1-20) and find the numbers that are (for example sake)>10 and <15 and then give me the average of that extract. The answer in this example would be 12.5 ... I can't seem to get the formula right. Thanks in advance...

I have a query that involves several tables and fields but the problem at hand involves a date field (TrxSerDate), a type field (TrxType), and a procedure field (TrxProcedure). The date field stores dates for various different Types and procedures. The query currently extracts the records if the...