Search results for query: *

i am using sql server select cs_id,net_ben_amt,max(upd_dtm) a from cis.dbo.ag_elig_rslt ager where pay_mnth = '200610' and cur_elig_ind in ('a','p') and ager.delt_rcrd_sw = 'N' and ager.elig_sts_cd = 'PS' and ager.pgm_typ_cd = 'CW' and cs_id = 'BA43183' group by cs_id,net_ben_amt this is...

on my mouse, when i use the roller ( i dont know what its balled its in between the right click and left click, lol). if i go down it goes to the next record and when i go up it goes to the previous record, is there away to stop that. i only want the to go up and down records on the form by...

in my form i have many check boxes and when i check the boxes and click on next record, the checks dont got away how would i do this, im not very strong at access Private Sub chkReason_not_Aided_AfterUpdate() If chkReason_not_Aided = True Then Me.Reason_not_Aided =...

i have downloaded release 2 on my pc. does enterpise need to be xi release 2 , for the bursting option to work or can i just have my pc on release 2 and have enterprise on xi release 1?

i have a field dis_end_dt (disablity end dt) i want to get the dates that will expire in 30 days or less , prior to the run date of my report i done this before , just cant remember sorry, and thanks

i want to do a ranking this is what i have select bi.cs_id,bi.ben_bgn_dt,bsts.ben_sts_cd, ( select count(*) from cis.dbo.bi_dtl b where b.cs_id=bi.cs_id and b.ben_bgn_dt <= bi.ben_bgn_dt and b.pgm_aid_cd = '0f' ) as Rank --into #tmp99 from cis.dbo.bi_dtl bi inner join...

sorry brain freeze this is a formula in crystal, how can i do the same forumla as a code in my sql server query truncate ((today - {mc_AgeChange.DOB})/365.25)

i am using a access table and a table that is in our database. when i like the two tables it is crazy slow. is there a way to optomize the access table so it runs faster

i want to export my crystal report into excel, i am going to automate this process with crystal enterprise and export into excel. does anyone know here how i can have the auto_filter tabs to show up, without having to go into the report and setting it everytime i asked in the crystal forum and...

im using crystal xi i have a cross tab report, i want to schedule it in enterprise to export to excel is there a way to have the cross tab import into excel nicely. im getting alot of blank colums .

i tried this in the crystal enterprise forum, but didnt get a response i am using crystal xi i have a crystal report that is scheduled in crystal enterpise to run every month and export to excel. is there away i can have it , that the excel spreadsheet has an auto_filter on each column that...

i am using crystal xi i have a crystal report that is scheduled in crystal enterpise to run every month and export to excel. is there away i can have it , that the excel spreadsheet has an auto_filter on each column that has data?

using access 2003 i am creating a form, that has some data that is already in our database that will populate. i know there is a way , when the form is opened, that all the data is available on the form that we can provide, other data will be manually entered. so for when a person enters a...

im using sql sever, would this work if i want to get sts_dt from last month to now? pgm.sts_dt >=dateadd(month, datediff(month, 0, getdate()) + 1, 0))

im using sql sever, would this work if i want to get sts_dt from last month to now? pgm.sts_dt >=dateadd(month, datediff(month, 0, getdate()) + 1, 0))

i am using crystal xi and enterprise not sure if this is possible, but its worth a try to ask i have a report that has worker # it is group by worker # can i automate this report so it will generate a seperate report for each worker number. so if there are 5 workers in the report there...

sorry i posted this on sql server reporting solutions, not sure which forum is better to post this question i am doing a report. i have two tables es_sts and INDV_TM_LIM_CLK. both tables have a cwin field , both are have cwin populated. that is one link i need to do. but on the other link, i...

i am doing a report. i have two tables es_sts and INDV_TM_LIM_CLK. both tables have a cwin field , both are have cwin populated. that is one link i need to do. but on the other link, i have cs_id in both tables also. but sometimes the INDV_TM_LIM_CLK is populated , sometimes it is. so i...

using sql server basically i want to link these two tables P.Program_type_Code = cp.PGM_TYP_CD but when i link the tables i need tell it that p.Program_type_Code (cw,rc to change to CR) the rest of the values are fine

i am gettting some extracts that are uploaded to our database problem is in the extract a program type code is (cw, rc) and others but they are fine but my main table CR is used instead of cw or rc. so how can i change the codes taht come in my extract (cw,rc) to change to CR. can i do this...