Search results for query: *

I have a DOB field, but i want to make sure that it pulls any kids under 6 what would the formula be if i want to do that. i want to make sure the current date changes daily so it doesnt need to be done manually

sql server and crystal xi have a DOB field ex. 5/18/1947. i need to subract the DOB from today (would change daily by it self,not a hard coded today date). just the age would be fine. but if i can get example 60 and 9 months that would be better

im using sql server and crystal xi i have a DOB field ex. 5/18/1947. i need to subract the DOB from today (would change daily by it self,not a hard coded today date). just the age would be fine. but if i can get example 60 and 9 months that would be better.

INDV_PREG"."EXPCT_DUE_DT">={ts '2007-05-04 00:00:00'} i want to change it so i dont have to change it everday. is there a functions like today or something so i can do a a filter on it

I have a DOB field i need to filter the dob field to look at 18-50 only how can i put this in my where statement, so when a person runs this report in crystal they dont need to change the DOB to reflect 18-50 but will change the by it self daily so it reflects the right age the field is DOB

i have sql server and crystal xi i am going to automate a report "BI_DTL"."BEN_BGN_DT">= dateadd(day, 14, dateadd(month, datediff(month, 0, getdate()), 0) ) how do i change this to month to date so if the report is ran on may 25th it would be may 1st to may 25th

im using sql server and crystal reports and crystal enterprise i want to put in my where the begin date to be the first of every month. for instance i have set this report to run may 29th, but i want the begin start date to be june 1, then next month i want the begin start datre to be july 1...

im using sql server and crystal reports and crystal enterprise i want to put in my where i want the begin date to be the first of every month. for instance i have set this report to run may 29th, but i want the begin start date to be june 1, then next month i want the begin start datre to be...

does the bar codes need to be uploaded to enterprise?

i see in the schedule tab for monthly . it asks me for what day on the month. but is there a way to say 2nd business day of the month

Do i have the ability to give people access to the BusinessObjects Enterprise Central Management

if i want to send a report on a schedule and send it via email , can i have parameters

i have used crystal reports for years , but a slight newbie on enterprise is it possible to have the report to send via email in excel format.

here is my query, when i run it the second time , it says #tmp1 is there already and i get an error. is there a way to drop the table after the report is run . SELECT CS_ID, PGM_TYP_CD, MAX(UPD_DTM) AS selectedUPD_DTM INTO #TMP1 FROM cis.dbo.CS_PGM WHERE (EFF_END_DT IS NULL)...

i have ms sql server and crystal reports xi i have created temp tables before but i was using oracle below is my temp table, when i add this to my sql i get an error. how would i add this into my query using ms sql server with qry1 as ( SELECT cis.dbo.CS.CS_ID...

I have 3 formulas //{@reset} to be placed in GH#2: whileprintingrecords; stringvar x; if not inrepeatedgroupheader then x := ""; //{@accum} to be placed in the detail section: whileprintingrecords; stringvar x := x + {SNF_TABLE.DATA}; //{@display} to be placed in the GF#2...

i have this in my where statement. i only want to see lot_numbers that start with R or W but i want to be sure that the next character after the R or W is a number so if its W34322 i want it if its WQ2321 i dont want it where (wod.lot_nbr like 'R%' or wod.lot_nbr like 'W%') thanks

SELECT substr(lot_nbr,2) from <table>; i did this . so for example i have a new field old field R92484 new field 92484 well when i link int_table.rvcr = substr(lot_nbr,2) i dont get any records back from the int.table when i look in the int_table i know there is a record of 92484 in the...

I know this is easy, but the search is down, sorry just cant remember how to do it in sql i have a field called lot_nbr the field examples is R92414 how do i take out the first character so the result is 92414

i want to do a parameter in my sql where ord_table.project like {?Project}% i but its not working, so bascially if the person enters the first 5 digits of the project number , it doesnt matter what appears after the 5 numbers on project number