Recent content by nkshah

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

Hi, thanks for the reply. is Cursor is solutions of this ? Cursor is coming in my thoughts. Let me know. i am newbie for CR and Oracle. Thanks./

Thanks for given me promt reply. based on my reporting req., i also need to convert all raws into column using decode() - for that i am using SQL Command. So anyways, Decode() comes into picture. your solutions is helpful - when we will used Tables for CR, but in my case i am using SQL...

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

Thanks for given me reply. Decode(productid,'1',product 1,'2', product 2,'3',product 3) i am using this above Decode() in my SQL Command of CR. Suppose, now in the future, in database table, they will add new productid in database. in that case, above Decode() will not display newly added...

HI Thanks for giving me reply. i implemented Max(Decode()) function in my SELECT statement. in the search part of DECODE function , i written manually each product name and it given me perfect output. Now, my question is that, if in the future they will add new productid and product name in...

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

Thanks for giving me reply. But, still my concept is not clear yet. i will developed oracle procedure and defined REF CURSOR inside oracle procedure. now, i will add this oracle procedure in crystal report. my assumption is that, is it working this way ? without declaring REF CURSOR in...

HI, is it mandatory to defined Ref Cursor in Stored Procedure and Package ? can i simplly developed Stored Procedure and add that Procedure in Crystal using Database Expert ? Thanks.

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