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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gtb12314

  1. gtb12314

    Help with Summary field in Report Footer

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

    Requirements of SQL Server 2005 Stored Procedures for Crystal Report

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

    Requirements of SQL Server 2005 Stored Procedures for Crystal Report

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

    Help With Executing Stored Procedure

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

    Determine the difference in days between two dates ?

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

    ORACLE WITH CLAUSE HELP

    Thanks a lot SantaMufasa.
  7. gtb12314

    ORACLE WITH CLAUSE HELP

    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!!!
  8. gtb12314

    Pls Help with Date format picture ends.....error

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

    Pls Help with Date format picture ends.....error

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

    DataType conversion help

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

    DataType conversion help

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

    DataType conversion help

    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 )
  13. gtb12314

    DataType conversion help

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

    DataType conversion help

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

    Help with Grouping

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

Part and Inventory Search

Back
Top