Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ss7415
  • Content: Threads
  • Order by date
  1. ss7415

    date time help

    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...
  2. ss7415

    need to combind date and time field

    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...
  3. ss7415

    combing date and time to do max

    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...
  4. ss7415

    need help linking tables please

    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
  5. ss7415

    can i do a hiearchy in crystal

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

    pulling data , and the hiearcy

    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...
  7. ss7415

    Pulling data and data associated with record

    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...
  8. ss7415

    PULLING DATA AND DATA ASSOCIATED WITH RECORD

    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...
  9. ss7415

    can i do 'ALL' for parameter in command

    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 #} <>...
  10. ss7415

    Using parameter in command error

    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...
  11. ss7415

    need to link tables with different criteria

    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...
  12. ss7415

    sql query help on linking tables

    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...
  13. ss7415

    help on case statement please

    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
  14. ss7415

    Want to display Parameters on report header

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

    linking two forumla with a comma

    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
  16. ss7415

    CR Export to excel different from enterpise export to excel

    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?
  17. ss7415

    When i get error i get message, can i change message?

    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?
  18. ss7415

    I have 2 queries that i want to include without linking

    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
  19. ss7415

    exporting to excel

    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
  20. ss7415

    paramater (number field) , can i use non-number field as an 'ALL'

    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...

Part and Inventory Search

Back
Top