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: *

  • Users: kv444
  • Content: Threads
  • Order by date
  1. kv444

    Show only Duplicate records in Webi Report

    Hi All, I am trying to develop a report in webi where i would like to show only duplicate records in the report and would like to drop the records that are unique from the report. For Example i have a column in the report: Item: Laptop Phone Phone Phone watch pen Here i want to see the...
  2. kv444

    Removing Non Duplicate Values from the Report

    Hi All, I am trying to develop a report in webi where i would like to see only duplicate records in the report and would like to drop the records that are unique from the report. For Example i have a column in the report: Item: Laptop Phone Phone Phone watch pen Here i want to see the...
  3. kv444

    Adding Null and Not Null Values in Crystal Reports 2013

    Hi All, I am facing issues while adding two numbers in crystal reports formula since one of the numbers is a null value,crystal reports is adding the null value and not null value and giving the output as a null value. Here is an example: I have 2 variables : Amounts and tax. Here are the 2...
  4. kv444

    Format the number in a webi graph

    Hi, I am trying to format the numbers in a graph in webi.for example i want to know the numbers 20,000..40,000 as 20k and 40k respectively on x-axis. Can some one please let me know if there is a way i could do this in BO webi. I appreciate your help in advance. Thanks a lot !
  5. kv444

    CLOB

    Hi, I need to modify a function,currently the coulmn here is set to return varchar 2 but i need to change it to CLOB so that i can store 10000 characters in this column. I tried changing the varchr2 to clob,i was able to compile it but the report is not retreiving the data like it used to...
  6. kv444

    Formula to format address

    Hi, I need to write a formual to format the address in crystal reports for example if the adress is john adams 123 ohio st apt 24 cincinati ohio i should be able to print the whole address in the reoprt and for the same report for a different recepient if tha address is quicny 123 ohio...
  7. kv444

    Convertvarchar2 to clob

    Hi, Could some one please tell me how i can convert VARCH2 to clob datatype in plsql. Thanks
  8. kv444

    Oracle Trigger Exception handling

    Hello, I am writing a after trigger for one of my tables on every insert update and delete for my dataware house staging area. The process here is when ever there is a change in the production database we need to capture this change in our changing area through triggers. I am able to create...
  9. kv444

    Lock

    Hi, How do i lock table in oracle, i tried LOCK TABLE Table_name IN EXCLUSIVE MODE and 3 other modes but still i was able to insert data in to the table. I want to lock the table so that the table would reject any data that is being inserted or updated in to this table. Thanks
  10. kv444

    Create Multiple table

    Hi, Could some one please tell me how to create a script in oracle to create multiple tables (more than 100 tables). I want to write a script because i will be re-using the script very often. Thanks for your help in advance.
  11. kv444

    Formula to always print

    Hi, Could some one please let me know how i can write a formula to always print a block of text in the report even though that block of text is not selected to print through the application Thanks
  12. kv444

    Form prints Boxes instead of apostrophes

    Hi, The crystal report form is printing boxes instead of apostrophes,but the format stored in the database is the correct one but for some reason the form cannot print the same. for example holiday's is stored as holidays.Could some one please help suggest me how i can fix this. Thanks for...
  13. kv444

    Show time zone

    Hi, I wanted to know how to display the time zone along with the time in the crystal reports.I want to generate a report based on the time zone they are in.If the user is in ET the report needs to say ET and vice versa for CT.Can some one please help me. Thanks a lot for your help in advance.
  14. kv444

    Formula to display records in one line

    Hi, I want to display the below address in one line. 248 liberty road Cincinnati Ohio I tried to insert a new text box to put this address and increased the width but it still displays the address in two line.Could some one please let me know how to write a formula to display the address in...

Part and Inventory Search

Back
Top