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

...= 'A' Then If isnull({aa_dch_PercentOfGrossCollections;1.AdjAmt}) then 0 else {aa_dch_PercentOfGrossCollections;1.AdjAmt} Else 0 //@Months **This one is a mess because we didn't go by a calendar month in 2005 but we do in 2006 //not required to go into 2004 if...

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.

...//@ChargeNotNull If isnull({aa_dch_PercentOfGrossCollections;1.ChgAmt}) or {aa_dch_PercentOfGrossCollections;1.ChgAmt} = 0 Then 1 //**I did this to avoid division by zero but maybe that's not right - when I make it zero I still get the division by zero error. Else...

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

...- but is datetime ok? Thank you - ALTER proc dbo.aa_dch_ChgDOS_To_ClmCreate_LagTime as --For chgDOS to ClmCreate Lag Time srb 3-14-06 /* Convert date strings to dates */ DECLARE @StartDate DATETIME DECLARE @strStartDate varchar(28) DECLARE @EndDate DATETIME DROP TABLE...

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