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

Thanks to you both!! as people keep asking me - are you done yet? :-)

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

The example was Start:March 1, 2005 End: Mar 30, 2006 They would choose whole months. Whatever dates they choose the 3 months are inside of that. If they choose May 1 to July 31 they will only have one 3 month total. 2006 ChargeAmt 3 months of Charges May 200.00 nothing...

Oh my goodness, I sure did. I decided to change it to make it more clear that calendar quarters may not always be appropriate. Sorry. Output: Charges 3 months of charges 2005 March 100.00 Nothing since Jan and Feb not chosen April 50.00 Nothing since Feb not...

Dates the user might enter (any dates they want): Start: March 1, 2005 End: April 1, 2006 Output: Charges 3 months of charges 2005 March 100.00 Nothing since Feb and Mar not chosen April 50.00 Nothing since March not chosen May 200.00 350.00...

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 haven't gotten any further on this. I've been reading articles and was hoping the Previous function might help me so I tried this: if isnull(Previous(ABS({aa_dch_PercentOfGrossCollections;1.ChgAmt}))) or isnull(Previous(Previous(ABS({aa_dch_PercentOfGrossCollections;1.ChgAmt})))) then 0...

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

oops - I think I found it: ABS(Sum ({aa_dch_PercentOfGrossCollections;1.PaidAmt}, MonthsGroupFooter2}) % ({RunningTotalCharges}) ) Any ideas on how to do the rolling 3 month average? Thank you.

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

Not sure if this is enough technical info but here goes: In group header 3: @resetTime whileprintingrecords; numbervar time := 0; In Detail: @AccumTime whileprintingrecords; numbervar time; ( time := time + {@ThisTimeMinusPrevious} ); In Group footer 3: whileprintingrecords; numbervar time...

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

George and mongr1| that is fabulous that certainly saved me a lot of work from what I was planning. thanks so much

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

This is what I have in the formula. if abs({aa_dch_PercentOfGrossCollections;1.PaidAmt}) > 0 then abs({aa_dch_PercentOfGrossCollections;1.PaidAmt} % {aa_dch_PercentOfGrossCollections;1.ChgAmt}) after inserting it in the crosstab I clicked on change summary, picked "weighted with" and chgamt...

The total % is still right but now the other one is zero. I'd still like to know how to do it even though I changed it to a regular grouping report instead of a crosstab. I changed it to weighted with and picked chgamt. Thank you

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