Recent content by jarthi

Hi: I have created a running total field. field to summarize : is a formula field with some calculation type of summary is sum evaluate : for each record reset : on territory group. ( or I don't have even have to reset, becos that is the last group) Now I created a line chart. I used month...

Hi: I already have a report built. It is quite a complicated report. Now I want to build a chart out of it. I have no clue how to do it. Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Plan 5 6 7 8 9 9 1 2 2 4 5 3...

Hi Karluk: I have 20 odd processes to kill, it didsn't even complete one process. So I was desperate. I gave a 'shutdown immediate'. 'shutdown immediate' is also taking a long time and still not completed. Hopefully it will finish. Then I will start the killing process again, if the processes...

If we restart the database, will all the processes be killed and the locks removed? Thanks, Arthi

Hi Karluk: Thanks for the quick response. I am trying to kill the sessions one by one. It killed one. but hanging on the other. I am using the following: I logged in through svrmgrl/ connect internal alter system kill session '8,32314'; I got the sid,serial# from v$session. Is this right...

Hi: Please let me know , how to recover from this error. We are trying to update a table and it is hanging. When I tried to analyze with validate structure option, I got ORA-00054 error. That means this table is locked. How to unlock it? Thanks, Arthi

Hi: I would like to create a user and give access to only one view in the entire database. Is it possible to do it? If so how? Thanks, Arthi

Hi: I am using CR8. I created a report (around 300 pages) with a group. On the left side, it showed the navigation tree. When I exported to dhtml format, it generated 300seperate html pages. But how do I see the report in Netscape in the same way I see it in crystal report, with navigation...

Ido: Thanks for the information. Arthi

Hi Ido: But while exporting, I don't get an option to export to a PDF file. Should I install anything on my machine? I am using Crystal Report 8.0 Thanks, Arthi

We are distributing reports as crystal report itself. The problem is we don't want the reciever to refresh the report. we want them to see the same data that was there at the time we distributed it. how to suppress the refresh button or how to make the data in the report read-only? Saving...

sorry i logged it in the wrong thread. Please ignore this. I am creating a new thread. Arthi

We are distributing reports as crystal report itself. The problem is we don't want the reciever to refresh the report. we want them to see the same data that was there at the time we distributed it. how to suppress the refresh button or how to make the report read-only? Saving data with...

I am trying to use this formula to suppress blank lines. But it displays only if all 3 fields are not blank.even if one field is blank it doesn't display anything. Please can someone what is wrong with this formula? iif(length({CONTRACT_SITE_ITEM.PRIMARY_ADDRESS}) >...

Hi Ken: Thank you very much for the formulas. I am using Crystal 8.0 and I have this function listed in the formula editor. Thanks, Arthi