Search results for query: *

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

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

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

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

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

Hi, Is it possible to create a report that runs based on multiple wild card words used as parameter. for example if i create one parameter say country. and with that parameter , i can look for anthing like that starts with IN or AS or US ... means it should select countries like INDIA...

Hi, Is there any easy way for selecting all fields EXCEPT one field from table. Thanks In Advance

Hi, I am pretty new to Perl. So I don't know whether it can be done or not. so your reponse will be really appreciated. I have two tables 1) Changes & 2) Contact Now In changes Table, i have couple of columns including old value & New value coloumns. In these two columns one contains Old...

Hi, i have a table with various columns but i need to Grouping on two columns...1) Group Name 2) Priority. Moreover I have to choose only certain Groups from Group Name List. The Problem I am facing is When i Do grouping only on Group Name , it takes only couple of seconds but when i do...