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!

  • Congratulations bkrike 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: jarthi
  • Content: Threads
  • Order by date
  1. jarthi

    chart using running total

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

    Build a Chart

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

    ORA-0054

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

    create user with access to only one view

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

    exporting to html format

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

    creating a report with read-only data

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

    Formula to calcuate Lower Quartile,Upper Quartile

    Hi: Does anybody know what a quartile is ? If so can you provide a formula for calculating quartile , just like calculating averages and medians? Thanks, Arthi
  8. jarthi

    rename an instance

    Hi: Can someone let me know how to know rename an already existing instance? Is it possible to do it? Thanks, Arthi
  9. jarthi

    Crystal SQL Designer

    Below is the query I am creating in SQL Designer. It works fine except it is not showing the description field. Description field is a memo field. It's datatype is long. Moreover if I change 'union all' to 'union' (which is what I want), query is not returning any row. select...
  10. jarthi

    Help need to create a Formula

    I have the following data Territory TargetName QtrTarget Opportunity Qtr Month MonthTarget --------- ------------- ------------ ------------- --- ------- --------------- Aero AeroQ1 90000 Opp1 Qtr1 Jan 30000 Aero...
  11. jarthi

    Crosstab

    Hi: I want to show the differnce between two summarised fields in a crosstab report. How can I accomplish this? Thanks, Arthi
  12. jarthi

    concatenate two files within an awk script

    Hi: This is my script so far(except the last statement): { res = sprintf ("%d_%d",$1,$2) printf "test\n" > res cat /home/testart >> res #I can't do this } How do I accomplish the last statement in awk? I know 'cat' cannot be used. Thanks, Arthi.

Part and Inventory Search

Back
Top