Search results for query: *

Hi, String which is a database field is yyyy-mm-dd hh24:mi:ss is to be compared against a parameter(date) datatype. In select expert it is showing error statign that for database field expecting datetime Plz help me in this regard.Step by step

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

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

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

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

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.

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

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

Hi, Thanks for your quick response, I am check for start prompt against column start_timestamp And End prompt against End_ time stamp I need to display default value for start prompt as currentdate-1 noon End date prompt default as Current date noon.Other wise user can select their date.

Hi , In this requirement 2 prompt(StartDate & Enddate) need to be created as for record selection I am going to use Column start_timestamp for start prompt and Column End_tiemstamp for end prompt . So, Above formulae may not work because same { table.datetime } we are going to use in both...

Hi, In requirement they need prompt for this report to take what user gives as well report must dispaly defult value as current date.

Hi, According to specification they need prompt in there report with functionality like default with current date (start date) & current date-1 (end date) and also user must be able to select any date with start noon and enddate 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...

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?

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

How to optimize reports and universes in business objects