Recent content by gtb12314

Hello All, I have a crystal report which consists of total 8 pages. And on page 9 I want to show only the grand total without displaying anyother information. So my report will have 9 pages all together. When I am adding a summary field (distinct count) in the Report Footer its getting...

Hi All, I want to learn how to create crystal report off of SQL Server 2005 Stored Procedure. So anybody please let me know from where I can download the documentation on "Requirements of SQL Server 2005 Stored Procedures for crystal report. I am using Crystal Report XI. Any help is greatly...

Hi All, I want to learn how to create crystal report off of SQL Server 2005 Stored Procedure. So anybody please let me know from where I can download the documentation on "Requirements of SQL Server 2005 Stored Procedures for crystal report. I am using Crystal Report XI. Any help is...

Hello Everyone, Below is my package & procedure and the code to execute the procedure from SQL*PLUS. (I) create or replace package mypackage2 as type myrecord is record (myempno emp.empno%type, myename emp.ename%type, myjob emp.job%type, mydeptno dept.deptno%type, mydname...

Hi Everyone, How to determine the date difference between the current record and the next record? For example, for every employee in DEPTNO 10, I want to determine the number of days between the day they were hired and the day the next employee was hired. Below is a sample of...

Thanks a lot SantaMufasa.

Hi Guys, I want to learn about "Oracle WITH Clause" from scratch. Please anybody let me know where can I find good notes or documentation along with several good examples. Any help is greatly appreciated. Thanks!!!

Hi Everyone, I am getting the following error when I run my crystal report. Failed to retrieve data from the database. Details: HY000:[DataDirect][ODBC Oracle driver][Oracle]ORA-01830: date format picture ends before converting entire input string [Database Vendor Code: 1830] I am using...

Hi Everyone, I am getting the following error when I run my crystal report. Failed to retrieve data from the database. Details: HY000:[DataDirect][ODBC Oracle driver][Oracle]ORA-01830: date format picture ends before converting entire input string [Database Vendor Code: 1830] I am...

I tried both the below solutions but still I am getting the time along with date. CONVERT(DATETIME, receivedate, 112) CONVERT(DATETIME, receivedate, 101

I cannot convert just to date instead of datetime. e.g. CONVERT ( date , receiveddate, 101 )

my field name is receiveddate and its datatype is varchar2(10) and its value is 2008-08-01. So can I do like this as below: CONVERT ( date , receiveddate )

I am sorry my varchar2 field has only date in it. And it's stored as 2008-08-01. I want to convert this into date datatype. please help me out.

Hi All, I am using SQL SERVER 2005 and one of my table has varchar2 field whose value is date & time. I want to know how to convert varchar2 field into just date datatype. Any help is greatly appreciated. Thanks in advance

Hello Everyone, I have a group based on table.desc with customized group name as follows: if table.desc = "" then "...." else REPLACE({table.desc},"Total ","") Whenever there is no data for table.desc="Unrealized Gain/Loss"(I mean if the entire row is 0) then I am suppressing the Group...