Search results for query: *

We have SQL 2008. We were supposed to go live with SQL 2016 at the end of March. That got put on hold when we started working from home the beginning of March. I am helping to fulfill a requirement for a dated ump. One of the fields requires that we show the results formatted as 999999999999...

Thank You! Combining the union suggested by johnherman and the trim by Olaf Doschke I got it to work.

Thanks Andrezjek - I have no control over that. The database was created by the vendor. The loan column has to be unique.

I'm bit confused with the query below. Here is an example of the data set. PURGE_ACTION LOAN CLOSEOUT_STATUS PREVIOUSLOANNUM PURGE 3610878 REFINANCED PURGE 3610887 REFINANCED KEEP 3728285 REFINANCED 3610878 3610887 Note, the...

DaveInIowa - Thank You very much! That worked nicely!

I have the following set of data. It is created using a sum of principal + interest to get the payment and it is grouped by the loan number, year of as of date, and quarter of as of date. The latter two are not shown. LOAN PAYMENT 3715142 252441 3715142 252441 3715142 252441 3715142 252441...

Two years ago I posted this - http://www.tek-tips.com/viewthread.cfm?qid=1636759 With the help provided, I was able to get the report working as requested. Today, two years later, an additional group was asked to be added to report. Unfortunately, because I do not completely understand what was...

I still have no clue what was wrong with that I was originally doing, but I got this to work by using the recorded version of the code. Instead of using PivotTable1 as the name of the table, I used the name that I created. Is the the code that is working. Sub CreateRBCTopLoans() Dim...

Oh I just realized what you suggested. I do not think that is going to work.

Hi Skip, The filer is doing the top 10 values. If I were doing it manually I do the following: Click the drop-down arrow on loan_xref From the value filter choices I select Top 10 From left to right the choices are Show Top 10 Items by Statement Value (because I changed the caption from...

To get an idea of what Excel would do, I started with selecting the objects to appear in the Pivot Table. Below is what is produced. In bold is the same area that is erroring for me, even after I change my code to use Statement Value instead of Sum of Carrying Value. With...

Thanks for the reply Skip, When I used the macro recorder I got the following code for the same place where I am receiving the error in my version. ActiveSheet.PivotTables("PivotTable1").PivotFields("loan_xref").ClearAllFilters...

I am using Excel 2007 The code in bold errors with the message "Run-time error '1004 Unable to get the PivotFields property fo the PivotTable Class". If I remove the filter code complete, the pivot table is created. What is causing the filter code to error? I have tried all types of things...

I am using Windows 2007 and Excel 2007 I used the Macro recorder for a pivot table. I cleaned up most of the code to not use what Microsoft generates, but I am not sure how to clean up the code for a top 10 filter and for sorting values in descending order. Below is what the recorder generated...

I solve the problem. I had the following code after the code above. That is what was causing the information to "disappear". 'calculate the pivot table PT.ManualUpdate = False PT.ManualUpdate = True

I change the above code to the following. When I did that the code ran without an error, but it still got rid of everything, leaving only the header.I replaced .PivotFields with .RowFields For Each pf In .RowFields pf.Subtotals(1) = True...

I am using Excel 2007 on Windows 7. The code below gets rid of everything, the row fields and the data fields, thus only leaving the header rows, eventually resulting in an error that reads "Unable to set the subtotal property of the pivot class". For Each pf In .PivotFields...

Tamar, Thad did it! Thank you

I am using SQL 2005. I have found how to get the last day of the year for a given date. select dateadd(year,datediff(year,0,getdate())+1,-1) I am trying to figure out how to, for a given date, get the end of the year for that same day. For example if the date provided is 01/10/2013, I want...

I found this and am wondering if this has something to do with the problem. I have to wait until tomorrow to see what my IT folks say.