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

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

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

Lbass, my Report Footer is blank and for Report footer, i did Checked box - Suppress Blank sectiona and Keep together property. i have two subreport in Page Footer. in property of Page Footer, Print at Bottom of Page property is uneditable and it is checked. ****** Below is your last Reply ...

Yes, report contain two Sub report in Page Footer section. Reports Footer section is empty and i checked suppress blank section option in section expert. Reprots does not contain any Group Footers. Report footers is formatted - Print at bottom option checked - but it is uneditable. if you...

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 same problem right now. i am getting blank space between Detail and Page footer section. in section expert, page footer - option print at bottom is checked and uneditable option. pls provide any sugggestion. Thanks/