Search results for query: *

the date - time should be 4/13/2006 20:34:21.80 first record date_add looks like 4/13/2006 time_add look like 20342180 second record date_add looks like 4/13/2006 time_add look like 20532132 i have date_add and time_add i want combine the two fields . sometimes a record may have the same...

i have date_add and time_add i want combine the two fields . sometimes a record may have the same date, so i need the time to determine the max. i would like to do it in my command , im using crystal xi and oracle9i the time should be 20:34:21.80 first record date_add looks like 4/13/2006...

i have date_add and time_add i want combine the two fields and do a max on both combined. sometimes a record may have the same date, so i need the time to determine the max. first record date_add looks like 4/13/2006 time_add look like 20342180 second record date_add looks like 4/13/2006...

i currently have INNER JOIN qad_table ON CSD_TABLE.SUP_PART = QAD_TABLE.PART AND CSD_TABLE.SUP_PROJECT = QAD_TABLE.PROJECT but if the qad_table.part is null , i want the first link to be csd_table.sup_ord_nbr = qad_table.wo_nbr thank you

can i do the report in crystal, instead of doing it in sql?

i have never come across this , i would appriciate some assistance. I am using crystal xi and oracel 9i i have two main fields wo_nbr and a lot_nbr (i am only looking at lot_nbr with a 'W' as the first character). wo_nbr will be a parameter. when i return my records with that wo_nbr, i want...

i have never come across this , i would appriciate some assistance. I am using crystal xi and oracel 9i i have two main fields wo_nbr and a lot_nbr (i am only looking at lot_nbr with a 'W' as the first character). wo_nbr will be a parameter. when i return my records with that wo_nbr, i want...

i have never come across this , i would appriciate some assistance. I am using crystal xi and oracel 9i i have two main fields wo_nbr and a lot_nbr (i am only looking at lot_nbr with a 'W' as the first character). wo_nbr will be a parameter. when i return my records with that wo_nbr, i want...

im using crystal xi and oracle xi this is my in my command QTY.PART ='{?PART}'AND QTY.LOT_NBR = '{?LOT}' instead of doing it im my record selection can i do it in my command? (if {?LOT #} <> 'ALL' then {Command.LOT_NBR} = {?LOT #} else if {?LOT #} ='ALL' then true) and (if {?PART #} <>...

i am doing a parameter on lot_nbr and part, they are both strings, in my command i have QTY.PART ={?PART} AND QTY.LOT_NBR = {?LOT} but the problem is when i enter the part and lot, it wont return any data unless i put ' ' at the beginning and end. Can i have it where the person doesnt need...

want to link my tables on two different criteria's. im getting an error with this, but you can see what im trying to do select a,qad.VENDOR,qad.PO_NBR,qad.PO_ITEM_NBR,qad.lot_nbr,qad.DATE_RCV,qad.PART,qad.ord_PART,qad.PROJECT_ONLY,qad.WO_NBR,qad.VDESC,qad.QTY_ORIG,qad.QTY_OPEN,qad.RCVR...

i want to link my tables on two different criteria's. im getting an error with this, but you can see what im trying to do select a,qad.VENDOR,qad.PO_NBR,qad.PO_ITEM_NBR,qad.lot_nbr,qad.DATE_RCV,qad.PART,qad.ord_PART,qad.PROJECT_ONLY,qad.WO_NBR,qad.VDESC,qad.QTY_ORIG,qad.QTY_OPEN,qad.RCVR...

I need to add a W to a field and i get an error case when qa.Wo_nbr is not null and ord.part is not null then 'W'+ qa.wo_nbr else 0 end as a i get an invalid number error, but part and wo_nbr are both strings

i want to display all the paramters that i was used for vender # to display on the report header. what would my formula be?

i have a forumla, if one fields is blank i do not want to see a comma after, if both are populated i want to see a comma to seperate. how do i do that {@display} +","+ {@display1} with this there is a comma regardless

i have a report that looks good when i export to excel from my crystal reports xi. but when the user exports from enterpise to excel, the export is doesnt look the same as before. Is there a way i can make the export cleaner?

when someone enters a parameter with no records , i get an error of error in formula <display> while printing records; string length is less than 0 or not an integer. i do have a formula with while printing records; in it can i change the error note to whatever i want?

query 1 select * from shipment where bol_no is not null and receive_date is null and status_code <> 'R' query 2 (select * where shipment.order_no = ordhead.order_no and status = 'A') i want to get all data from both queries. do i do a union or union all? i get an error

i am exporting a report that has about 20 different fields , when i export there are blank rows and columns. how can i export this without skipping rows or colums

instead of entering 0 or another number to get all the data for the parameter, is there a way i can use '%' or 'All'? (if {?Class} <> 0 then {Command.CLASS} = {?Class} else if {?Class}= 0 then true) and (if {?Department} <> 0 then {Command.DEPT} = {?Department} else if {?Department} = 0 then...