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

Search results for query: *

  1. nkshah

    Merge multiple PDF files into one PDF uisng Javascript - Help needs

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

    Oracle 10G - Dynamic Decode Function - how is it possible ?

    ...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)) DEPT10, sum(decode(deptno,20,sal)) DEPT20, sum(decode(deptno,30,sal)) DEPT30...
  3. nkshah

    can anyone explain below oracle Decode syntax ?

    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./
  4. nkshah

    can anyone explain below oracle Decode syntax ?

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

    Dynamic Decode function - is it possible ?

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

    can anyone explain below oracle Decode syntax ?

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

    can anyone explain below oracle Decode syntax ?

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

    when we need to create Temporary Table and UDF table for Crystal ?

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

    What is the use of Oralce Package for Crystal ?

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

    Need fundamental explanation of ORacle Package for Crystal

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

    Oracle 10 G - Procedure Package for Crystal Reports

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

    Oracle 10 G - Procedure Package for Crystal Reports

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

    Oracle 10 G - Procedure Package for Crystal Reports

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

    Oracle - how to display % sign in database column after number value

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

    Complex Decode Statement in Oracle

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

    Regarding Text Box Drop Shadow Property - Need Black lines

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

    Blank space between Detail and Reprots Footer section - how to remove?

    ...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 : If you have placed subreports in a page footer and conditionally suppressed the page footers, you will get blank...
  18. nkshah

    Blank space between Detail and Reprots Footer section - how to remove?

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

    Blank space between Detail and Reprots Footer section - how to remove?

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

    How ro remove empty space in Details section?

    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/

Part and Inventory Search

Back
Top