Search results for query: *

I added a column to a table like this: alter table MyTable Add ColumnX varchar(12) Then I tried to delete that column: alter table MyTable Drop ColumnX But it says: 'ColumnX' is not a constraint Could not drop constraint This is the first time I have added or tried to delete a column. I...

I've been given an Excel spreadsheet with the city, state zip in one column and I need 3 columns. One with city(no comma) one with state and one with zip. It looks like most of the zip codes are 5 rather than 9 digits. So I can get those with the Left function, but I don't know how to get the...

SQL database, CR 11 I need to add and divide a couple of numbers in a group footer but can't even get the first step done. In the report I group by year and then by month. I use a running total to get the total charges for the month in group footer 2. Then I tried creating this formula...

I'm using a stored procedure, SQL database, CR 11. What I want to do: In the last column get a 3 month rolling Net percent based on the dates the user picks. It doesn't have to start until the 3rd month displayed. See example below. How can I make that happen? What I have now: a report that...

Bottom line: In group footer 2 I want to do some addition and division on the totals. Getting the info from a stored proc (union query one side getting charges, the other getting payments and adjustments) & using Crystal 11. Detail: I have two groups: The first is by Year and the second is...

I have a report that lists customer charges and payments. It is grouped by a financial code and then whether it is a new or existing customer. In the second group I'd like to show an average charge per customer. The problem is that sometimes there is a payment and no charge yet. So I only...

My report is grouped by Employee and then by day and then by appointment Type. The detail after that is appointment times in 5 minute increments like this. Employee1 03-20-2006 NewAppointments 8:00 8:05 8:10 10:00...

When I execute the stored procedure below I get the following error: Server: Msg 241, Level 16, State 1, Procedure aa_dch_ChgDOS_To_ClmCreate_LagTime, Line 19 Syntax error converting datetime from character string. I'm sure it has to do with this bit of code that I used from another stored...

I have a stored procedure that creates table A and fills it with data each month so that my reports can run from table A. Now they would like to see this month's reports start out with last months ending balance (one of the fields in table A). That is a calculated field and not stored in the...

I'm using a crosstab whose columns go by months and I have two formulas in the Summarized Field. One is called //CrosstabGrossCollections WhileReadingRecords;.001 and the other is called //PercentOfGrossCollections ABS(Sum ({aa_dch_PercentOfGrossCollections;1.PaidAmt}) % Sum...

I've been reading thread149-1001035 because it sounds very similar to my issue but I must have something wrong because I'm getting a zero in the main report. I have a main report of employees tasks. It is grouped on their last name, then the task description. It is based on a stored procedure...

What I need is a total charges.amt figure for each patient visit (I said distinct because there can be several payments to one charge which causes the charge to appear on multiple rows but I only want it added one time). In thread767-1169148 I asked for help with a total for my charge figure...

I have a report that groups by month and then by financial class then by payer, etc.. Sometimes they want to see the data by financial class as the first group. I know how to suppress the month with a parameter but the group is still there so if a certain financial class appears in more than...

I'm using CR11 and MS SQL. My report has 5 groups. 1. Month and year 2. Formula that uses the financial class of the charge unless there's been a payment then uses the payers financial class. 3. Formula that uses the Primary payer name unless there's been a payment made and then it uses the...

There is one crosstab for each employee. For some employees all the cells are populated whether with a zero or other figure. For some employees the detail cells are blank but the total lines at the bottom of the last group and in the last column are populated. I am using the formula below for...

In one of the case statements below I enter a "Y" if it is a new patient. However, I really only want to count them one time per date (c.begin_date_of_service). I wasn't sure how to do that so I tried to do a distinct count in another case statement but it probably isn't allowed (I got an...

Here's the query I have: Select c.charge_id, td.trans_id, pe.enc_Timestamp as EncDate, pe.enc_nbr, c.amt, ( SELECT [payer_name] FROM [payer_mstr] WHERE [payer_ID] = [ep].[payer_id] and cob = 1 --cob = 1 means they are the primary payer if it was cob=2 then that is a secondary...

I have a union query that was working fine until I added one field. That's all I'll show here to simplify: Select Null as RenderHere From Where Union All Select ppm.attending_ind as RenderHere From Where I get the error: Syntax error converting the varchar value 'Y' to a column of data...

I have tried the formula below with and without the WhilePrintingRecords and the result is the same. Example: Payment is null and Adjustment is 138.00. Instead of getting a total of 138.00 I am getting 0. I want get a total of both fields for the enc_nbr group. From reading the other posts I...

I have a report that is grouped: By month, Doctor, department, and procedure code. In the detail is units and charge amount. Sample: October Dr. Smith Cardiology 1042 10 100.00 5 50.00 What they want is to see...