Search results for query: *

Hi friends, Below is my detail explanation. Every Morning, we are getting multiple PDF files and our Executive needs to see in one PDF files. Right, now I am diong manually PDF Merge process using Acrobate Profetional. But Now, my client asking to convert this into automated process every...

I will rephrase my question with a better example, then aks my question:- In the example below, we take the employee name (ename) and the department number (deptno) and display the salary of the employee by their department. SELECT * FROM (SELECT ename, sum(decode(deptno,10,sal))...

thread186-1236075 i have exactly same problem of above Thread but it did not mention answer.

Hi experts, i have one question in my mind. in which scenario and situation , we need to use Temporary table and UDF table for Crystal Reports ? Thanks.

Experts, i already developed one Storec Procedure with Ref Cursor in that. and i defined packages and package body with PRocedrue and Ref Cursor. Everything Works Perfect. I added procedure in Crystal Reports and Working Excellent. I want to know that, Why we need to defined package with...

experts, i already developed one Storec Procedure with Ref Cursor in that. and i defined packages and package body with PRocedrue and Ref Cursor. Everything Works Perfect. I added procedure in Crystal Reports and Working Excellent. I want to know that, Why we need to defined package with...

Hi friends, i developed one complex query with parameters that satisfy my business requirments. Now, i want to convert this query with parameter into Oracle 10 G Procedure. i want to use this Procedure's result sets into Crystal Reprots. i did googling, most of people suggesting, to declare...

Hi, friends, i have very simple problem. i want to display % sign in my database column value after calculation. i tryied To_char() with formate $ is working and displaying . but i want to display % sign. thanks.

I have one complex Decode statement that i can not able to understand it. in the parameter it contains--> 1142009 <- as mmqyyyy formate. Below is the code. to_char(decode(substr('1142009',4,4),(to_char(sysdate,'yyyy')-2), decode(substr('1142009',0,2),0...

HI, i have Text box in CR. i chossen Drop Shadow Prooerty with Border Grey. so it shows Grey Shadow at the bottom of Text Box. I am looking for Shadow White, when i did border White then it is disappears because of while background. My requirment is to display Shadow with Black Borders and...

below is the problem. We make report as follows page header Section details Employee Information Report Footer Page Footer Other Information whenever we run this crystal report it leaves space in between after employee information and before...

Hi friends, i have Report Page Set up Letter 8.5 * 11. when i did change it into Legal and run reports with exact configuration , it giving blank space between Detail section and Page footer. It is obly one page reports but giving blank space btween Details and page footer section. Thanks.

Hi friends, i have one already developed reports. now based on some requirments changes, i need to add YTD sales in reports. i have already built Command for this reports. Command also used one of tables which contain each month sales data. Now, i need to add YTD calculation in reports. so...

Hi friends, i have one formula in page Header section. if inside formula, condition satisfy then it returns and shows TEXT message on page Header section. if inside formula, condition not satisy , then nothing to show on page header section. MY Problem is that, even though condision not...

can anyone pls explain me below Oracle Decode parameter and syntax ? DECODE(trim('{?Entity}'),NULL,table.entity,'{?Entity}') Thanks.