Search results for query: *

No Luck with this...for some reason i am not able to group the dimension column in webi 4.1...

Is there a way i could do it directly at the report level

I want to see phone phone phone Thanks!!!

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

Could you please explain it a little bit in detail...i am trying to show only the duplicate dimensions in the report...will i be able to use running total here..

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

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

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 !

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

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

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

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

Thanks for the reply. I am trying to lock the whole table,not allow any transcation to the table what so ever. Will SET TRANSACTION work? Thanks

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

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.

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

Hi,i tried this but i guess i explained it wrong earlier. This is a block of text that needs to be displayed in the report and there are words inside the text file with apostrophes that are being displayed as a box instead of the apostrophe symbol. sorry for the error.is there some thing i can...

Hi Thanks for your reply.The font i'm using is Arial 10 and this is the standard font i am supposed to use for this report.I tried changing the font but still see the error.Is there any other way you suggest i can try perhaps write a formula for this.Can you please let me know. Appreciate your...

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

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.