Search results for query: *

The report I ran yesterday never finished. It grayed out the screen and stayed that way. The program shut itself down by the time I got back in this morning. I changed the select slightly this morning: {Tran2.EffDate} = {Trans.EffDate}+7 and {Trans.Cusip} = "922038203" and {Trans.EffDate} >=...

I correct the field to show the following: {Tran2.EffDate} = {Trans.EffDate}+7 and {Trans.Cusip} = "922038203" and {Tran2.EffDate} >= Date(2003,09,04) and {Tran2.BuySell} = "S" and {Trans.BuySell} = "B" And reran it. I'm currently waiting for the results. The suggestion was made to me to...

To start out, I simplified the code that I was working with. The following is the SQL select code, but I'll explain what we're looking at: AC9 is a 9 digit account code. EffDate is the date of the trade. BuySell is if it is a Buy or Sell. SQLUser.Trans is the original database for...

I added the line and observed no change: {Tran.EffDate} >= Date(2004,01,01) and {Tran2.EffDate} <= {Tran.EffDate}+7 and {Tran2.ItemNo} in "025000000" to "025999999" and {Tran2.Code} = "R" //R means returns {Tran.Code} = "S" //S means sold I'm positive that I have data within those periods that...

Ok, I've made a little headway with this. It was suggested that I add the db twice to the report (giving the second an alias). I linked the account number and the Item numbers. Then I did a selection for the following: {Tran.EffDate} >= Date(2004,01,01) and {Tran2.EffDate} <=...

Ken's holiday array was placed into the header of the report with the correct holidays noted. ============ //Holiday Array Formula for the report Header: BeforeReadingRecords; DateVar Array Holidays := [ Date (2003,12,25), // you can put in as many lines for holidays as you want. Date...

The following is my @DatePlusOne: ==================== //Adding Business Days: WhileReadingRecords; DateVar Array Holidays; DateVar Target:={@Start Date} NumberVar Add:= 1; NumberVar Added := 0; WHILE Added < Add Do (target := target +1; if dayofweek (target) in 2 to 6 and not (target in...

I used the information I found here and on Ken Hamandy's site to create a report. The function of the report is to find all orders that filled on three consecutive business dates. I created a Parameter called {?Start Date} and three formulas--{@Holidays}, {@DatePlusOne} and {@DatePlusTwo}...

I've been given a project to develop. First of all, I don't know SQL, and I'm fairly new at CR. Using 8.5 on the desktop, and exporting it to 7.0 for users to run on an internal website. The project takes two databases, one that contains transactions, the other that contains product...