Search results for query: *

Hi, I have got the solution as follows if currenttime >= time(12,00,00) then {TBL_PMNS_SC_PROBLEM.OPEN_DT} >= datetime(currentdate ,currenttime-43200) else {TBL_PMNS_SC_PROBLEM.OPEN_DT} >= DateTime (CURRENTDATE-1,CURRENTTIME-43200) but is there a direct way to subtract 12 hours from...

Hi, I have field that includes date and time , If i want to select records for previous 12 hrs. what will be the records selection formula. Using CR 10 version Thanks

Hi, I have noticed that there are couple of entries that also have other charcters behind the numeric field e.g rsh 102.45.67 , due to IOP and in result i am getting rsh , due to IOP how can ignore those... I tried using Exit while but its not working Thanks

Thanks This formula works fine. Only thing is along with string severval "." are also attached for eg rsh ... how can i exit loop as soon as it finds a numeric value.. Thanks

I have column that has follwing values e.g rsh 102.33.45 login 103.44.55 AGIY 123.4.66 JIG PI 23.45.666 in result i want only show only part of string before numeric example rsh login AGIY JIG PI Is it possible with crystal Report 10 Thanks

Hi, Why can't i see VIEWS in the the database explorer, I can see only tables and Stored procedure. I have checked File-->Option-->Database--> Views are checked. even then i am not able to VIEWS. Any idea.... Using crystal version 10 & oracle 10g database. Thanks

Hi, is it a way to join a main table to secondary table. like this WITHOUT using COMMAND feature. select * from table_A A left join table_B B on A.field1 = B.Field1 and B.field2 = 'ABC' so my objective is to get all records from table A and I want to show only those fields from table B...

I can't use COMMAND option because I am using multivalue parameters in the record selection formula any other way....besides using Command

Hi, is it a way to join a main table to secondary table. like this without using command select * from table_A A left join table_B B on A.field1 = B.Field1 where B.field2 = 'ABC' so my objective is to get all records from table A and I want to show only those fields from table B where...

Thanks for your reply, I am using crystal version 10 and oracle 10g database. yes, i can use union query in the command. but how can i incorporate parameters in the report. for example whether user wants to display LOCATION only or LABEL only or BOTH.

Hi, I have 3 tables. Main table , secondary_loction table and secondary_label table. Now Main table and Secondary_location has one to many relation. e.g NAME LOCATION trip245 New York trip245 Ohio Main Table and Secondary_label also have one to many...

Thanks.. worked perfectly

Hi, I am using MultiValue Parameter in a report. Is it possible to restrict the max. no of values user can enter. For example. If I want user can add 1 to 5 values only. not more than 5 values are allowed Thanks

Hi LB, I try to find solution on Bussiness Objects Site. According to them first convert null to default value to do so A) STEPS TO CONVERT NULL FIELD VALUES TO DEFAULT VALUE FOR ALL FIELDS IN CR 1. Click File > Report Options 2. Select the 'Convert NULL Field Values to Default' check box...

HI LB, I am also not able to figure out when i use only this in record selection formula not isnull({OPERATING_SYSTEM_DEF.OS_NAME}) then i don't get any null values but when i include below formula whilereadingrecords; numbervar i; numbervar j := ubound({?OS}); stringvar x; for i...

I am trying this formula whilereadingrecords; numbervar i; numbervar j := ubound({?OS}); stringvar x; for i := 1 to j do( if NOT ISNULL({OPERATING_SYSTEM_DEF.OS_NAME}) AND {OPERATING_SYSTEM_DEF.OS_NAME} like "*"+" " +{?OS}[i]+"*" then x := x +{OPERATING_SYSTEM_DEF.OS_NAME}+ ", " )...

Hi LB, I tried the above selction formula but its still not able to filter NULL values. Means i am still geting null values in the final result.

Hi LB, I am using formula suggested by you as follows whilereadingrecords; numbervar i; numbervar j := ubound({?country}; stringvar x; for i := 1 to j do( if {table.address} like "*"+" "+{?country}[i]+"*" then x := x + {table.address} + ", " ); {table.address} in x but alongwith the...

Hi, Is it possible to suppress a Field name already ina report while scheduling a report e.g if we have 3 fields in a report and i want to show only 2 fields on the output while scheduling. Thanks in Advance

Thanks LB, The above method did work for me. As you said this record selection would not pass to the database. Its greatly affecting the data because i have abot 200,000 records to filter so above method is taking a while to run. I was trying something like that i am not sure...