Search results for query: *

I desire listbox to display this format: 2016A(Base) 2016B(Adj) 2016C(2016A(Base)+2016B(Adj)) 2017D(Base) 2017E(Adj) 2017F(2017D(Base)+2017E(Adj)) 2017G(Base) 2017H(Adj) 2017I(2017G(Base)+2017H(Adj)) How do I get code to build query to recognize 2016C, 2017F and 2017I and feed query as...

I have a table that is over 2 million records froem a text file and I think, but not sure that the best way to relate fields is to create column and insert the relating paramters in a row in a new column A. I am able to sort the file so that everything Below the FY20XX relates to the column...

Greetings, I'm having trouble using the running sum code in a query. It errors out on the code on Select Case rst.Fields(idName).Type and error is ITEM NOT FOUND IN THIS COLLECTION. My query SELECT t1.ACCEPTANCE_DT, t1.EXPDTR_AMT, t1.OBJ_CD, t1.TRANS_LINE_NBR, t1.TRANS_NBR...

Crystal 8.5 and DataSource Type SQL I would like to resolve without sub-reporting, if possible. Two tables (1. Sal Projection & 2. Exp Budget) at different agregation levels and want to sum both up by Field A : Dept Budget (CF3 linking tables by this field) Field B : Account (linking tables...

This is in the SQL Expression editor Crystal 8.5. Works for grabbing everything with a max effect date of as of now. Is there a way to write this based on fiscal year like listed below? I think I will have a parameter field that feeds it like {fiscal Year} If Fiscal Year is 2012, then max...

SELECT t.CHARTFIELD_VALUE, t.W_CF_ATTRIBUTE, t.W_CF_ATTRIB_VALUE, t.EFFDT, t.EFF_STATUS FROM SYSADM_PS_X_S_M_CFATTRIB AS t WHERE (((t.W_CF_ATTRIBUTE)="BUD_PROG" Or (t.W_CF_ATTRIBUTE)="BUD_ACT") AND ((t.EFFDT)=(SELECT Max(m.EFFDT) FROM SYSADM_PS_X_S_M_CFATTRIB AS m WHERE...

I am really struggling with the oracle tree that we are working with. Everything is one member and working with different levels is difficult. I like to breakout levels from this "tree" so that working with will be easier to sort/link etc. I am using CUBE like reporting in excel to pull the...

Greetings, I would like to modify on one of the working max effective date sqls below or come up with new sql to capture the max effect date <7/1/2012. Ideally, I would like the sql to grab the max effective date for each year and have it classify year like: <#7/1/2012# is FY12...

I would like to grab the other side of the Trans Type="TR" and ignore the Trans Type= "R" if possible. The trans type ="R" appears to double up when I do a self join on the table. Is it possible to self join and grab only the trans type ="TR"? and pull in the R without it selfjoining or...

I'm using crystal 8.5 and within the SQL Expression Editor I want to prevent pulling in future date if it is 7/1/2013 or greater. Other than that I want the max effective date. My current formula is: (SELECT MAX(EFFDT) FROM TABLE TABLE2 WHERE TABLE2.CT_VALUE = TABLE.CT_VALUE and...

I have a scenerio where I'm trying to separate out depid's that have an ET attribute. In addition, I need to ensure that for that Depid it has a "A" active status for it's max effective date. I am linking an expenditure table to an CFAttrib table by depid to find those depid's that have the ET...

CTValue 1 14224 2 14224 3 14224 4 14224 5 14224 6 14225.... CFATTRIB 1 PROG 2 PROG 3 ACT 4 LLC 5 APT CFATTVAL 1 1010 2 1020 3 101010 4 4 5 22 EFFDT 1 3/1/2004 2 3/2/2004 3 3/5/2004 4 3/1/2004 5 2/1/2005 I want the CFATTVAL value for the max effect date for CFATTRIB PROG for the...

Is it possible to link two tables that have similiar data except that one is more detailed? I want to "crunch" the data and then link. In microsoft access I would run a table against a query that agreggated the similiar data at the level in the table and the link worked fine. Can you do...

Can you see the issue? Not sure why I am getting the error. Select TABLE1.CTRRBVALUE, TABLE1.CFATTRB, TABLE1.DESCR, TABLE1_1.CFATTRB, TABLE1_1.CTRRBVALUE, TABLE1_1.DESCR from TABLE1 inner join TABLE1_1 where 0=1 UNION ALL Select TABLE1.CTRRBVALUE, TABLE1.CFATTRB, TABLE1.DESCR...

Hopefully, I can explain myself better then I did in a previous post. tABLE CTAttrib CTAttribValue Description Program 01 Accounting Services Activity 01011 Financial Reporting Activity 01012 Budget Activity 01013 General Ledger Program 02 Human Resources Activity 02010...

Hi all, I cannot seem to get the max effect date formula to work on my self joined table. My formula: (SELECT MAX(EFFDT) FROM TABLE1_1 TABLE1_12 WHERE TABLE1_12.CHRTFIELD_VALUE = TABLE1_1.CHRTFIELD_VALUE and TABLE1_12.W_CF_ATTRBUTE = TABLE1_1.W_CF_ATTRBUTE) Error Received is ODBC...

I have two tables and I am linking by CT Value. In Table 2 for each CT Value there can be multiple values per effective date. I want to pull in data without it doubling up into the detail of the report. Table 2: CT Value effectdate CT Attrib CT ATTrib Value 292635 7/1/2005 CITE2 007 003...

I would like to grab the Nickname off of Table 1 where the EFFDT is the greatest - (ie. Sue was the nickname on 7/1/2012.) I want to show the fields Person nickname and effdt. I'm thinking this is fairly simple but can't seem to figure out. Person NickName Status EFFDT Susan Susie...

I think this might be simple to solve. I have a dbase in which I am trying to append tbl2 to tbl1 and at the same time setting all of tbl1 type fields that are null to D. The assigning D is ok but the problem lies in trying to append based on the CheckNo. tbl1 has check numbers that go from...

Hi all, Just curious if there is a function that can predict and filter out or ignore anything that is a nondate. I'm downloading mainframe dates and within a text field A: MMDDYY I'm using the parsing command to give the format MM/DD/YYYY in field b: The command for field b...