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 TouchToneTommy 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: syedmca
  • Content: Threads
  • Order by date
  1. syedmca

    Converting string date datatype to date datatype

    Hi, In select expert i need to put condition that database field which is of string dataypt >= date data type . How can i do this plz explain me step by step Thanks Syed
  2. syedmca

    Count on the column

    Hi, I need to count the number of times AAAAA,BBBB AAAAA BBBBB CCCCCC AAAAA BBBBB BBBBB count ---- AAAA= 2 BBBB=3 CCCC=1 Regards syed
  3. syedmca

    Number field with ALL as default value in parameter

    Hi I need to create one parameter on a cloumn which is having number datatype with ALL as default value.When i am trying to insert default value as ALL it is not taking.How to get this fuctionlity. Thanks in advance, Syed
  4. syedmca

    Condition with NOT EXIST

    Hi, I need to generate report with condition like Select Distinct Emp_number,Emp_hiredate,Division_id from Employee E where designation=' sales representative' AND ( NOT EXISTS ( Select address from address A where A.emp_hiredate= E.emp_hiredate AND (...
  5. syedmca

    Logon failed error

    Hi, When I am running the report .I am getting logn failed DEtails:08001[cli driver] attempt to establsih connection failed with security reason SQL State=08001. Db vendor code = 30082 What can be the reason .How to resolve tgis. Thanks in advance, Syed.
  6. syedmca

    Formulae for total form processed per hour

    How do I need to create a formula in Crystal Reports (CR) to get the TotForm HR Calculation to be performed is Totformhr= total processed*3600/timetaken Kindly help me by guiding steps need to be taken to get this formula in crystal reports.How many variables need to be created.How to do calc...
  7. syedmca

    Count formulae

    Hi, I am beginner in crystal reports I want to calcultate a total timetaken by formtype by suing the formule total timetaken formtype= count(TOtalformtype)* (max(endtime)-min(starttime))/100 .How can I do this in crystal reports .I mean to say how to write formule for this Form_ type Tota...
  8. syedmca

    Urgent Parameter dispaly current date noon to yesterday noon

    Hi, I need to create 2 parameter 1) start date @) end date The above two parameter must display default date in start date as yesterday noon to enddate current date noon & if uer selects any date then it must display that date noon to one day before noon . Kindly help me in this regard...
  9. syedmca

    webi

    1)I want to hide a column country in a report ,How to do in a report ? 2) How to apply report filters in a reports?
  10. syedmca

    excel restrictions

    what are the restrictions of using MS Excel in inlist oeprator in business objects
  11. syedmca

    performace of report

    How to optimize reports and universes in business objects

Part and Inventory Search

Back
Top