Search results for query: *

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

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

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

Hi All, I want to write a query to find out which employees have multiple PTO plans and also who has multiple employee groups (database.employee_group) I am writing a query against one table which has field (database.plan) for plan names and (database.employee_group )for employee...

Hi All, I have a sql command with temporary tables, but whenever I am trying to create a view with temporary tables I am getting an error as below: "Views or functions are not allowed on temporary tables. Table names that begin with ‘#’ denote temporary tables." Please anybody let...

Hi All, In my SQL I am having temporary tables. And in Microsoft SQL Server Management Studio (Microsoft SQL Server 2005) whenever I execute sql statement its working fine & I am getting the records. My SQL statement is using 2 databases as follows: 1. PerformanceDeficiencyNotice 2...

Hi there, Please help me out, I want to know what will be the code in oracle 9i for the following line of code, I tried several ways but not yet solved. I mean I want to transform the following code into oracle 9i SQL. dateadd('yyyy',-1,(date(year(datadate)-1,month(datadate),1))) Any...

Hi there, Please help me out, I want to know what will be the code in oracle 9i for the following line of code, I tried several ways but not yet solved. I mean I want to transform the following code into oracle 9i SQL. dateadd('yyyy',-1,(date(year(datadate)-1,month(datadate),1))) Any...

Hi Everyone, When I am running the below code I am getting syntax error pointing at “with”, Any suggestions. with pdninfo(transactionid, employeenbr) as (SELECT pdn.transactionid, pdn.employeenbr FROM [xyz].[dbo].[PDNMain] pdn) SELECT transactionid, employeenbr FROM pdninfo I am...

Hi Everyone, Here are my two formulas in the report: 1. WHILEREADINGRECORDS; {0199_Budget_By_Month.SUMMARYLVL1} = "" OR uppercase({0199_Budget_By_Month.SUMMARYLVL1}) = "BLANK" OR {@Group 2: Heading} = "...." 2. WHILEREADINGRECORDS; STRINGVAR ARRAY L2; STRINGVAR ARRAY L3b...

Hi Everyone, In my report I want to include a group based on employee age,I mean group those employees who are already turned 50 years of age OR going to turn 50 years of age in this calendar year OR greather than 50 years of age. And in my report I have a datetime database field called...

Hi All, I tried the following code, am getting an error as "missing keyword". Please suggest. AND (CASE WHEN to_char(sysdate,'Q') = 1 THEN v.next_perf_review = TO_DATE('03/31/2008','MM/DD/YYYY') ELSE v.next_perf_review = TO_DATE('03/31/2009','MM/DD/YYYY') END) I greatly...

Hello All, Below is my command, I want to know how to have the distinct count of per_end_date for each pay_sum_grp(i.e; for FLP,PTS &PTU) for each employee. please see the last two lines of my command to have an idea, please help me out. WITH eelist AS ( SELECT assoc.company...