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

    First Occurence of a number

    I have a calculation (formula) in the details section, whose output looks like the following: @count -------------- 0 0 1 2 2 1 What I would like to do is perform a calculation such that if there is a first occurence of '2' then perform a calculation, else if it is a...
  2. pmk16

    Forcing to show output in next row

    I have a formula which is displaying 'A' or 'B' based on some criteria. But, I noticed that the output is getting displayed by 1 row. For example @form1, 1 A 2 B 3 A 4 B 5 B Output should have been @form2: 1 B 2 A 3 B 4 B 5 A Is there some way where I can force it to show in the next row...
  3. pmk16

    Struggling with YTD formula

    I have been trying to achieve the following. Considering Feb as the beginning of fiscal year, For i:= 1 to 12 do // i= month 1 - 12 if month=Feb then %age = Number of employees terminated % Total Headcount of employees for Feb else %age = current month %age +...
  4. pmk16

    Urgent: find data which does not exist in db

    I am not an Orcle expert and have been trying hard to come up with a solution for this. For eg: TaskId = 1 has A,B,D in it but not C whereas taskID = 2 has C,D,E in it then it shud display , taskID = 1 does not have E in it taskID = 2 does not have A,B in it and similarly check for all...
  5. pmk16

    Displaying Dates on the Y-Axis on Chart

    I followed the instructions given on: http://support.businessobjects.com/library/kbase/articles/c2006772.asp and although I can see the @Date set to "MMDDYYYY" format on the field as in setp 7, it does not change the number format on the Y-Axis of the chart :( It is displaying 100K, 200K etc...
  6. pmk16

    Chart Expert: How to display charts with dates on both X & Y axis

    I have this urgent requirement to display a Line graph with dates on both X-axis & Y-axis. Well, I know how to plot dates on X-axis, but since CR allows only numbers or summation operations on numbers for Y-axis, is there a work around to create a report with dates on Y-axis too? any help is...
  7. pmk16

    Urgent:Chart Expert: Date Field on X & Y Axis

    I would like to find out if there is any way to display a Chart (Line chart) using Crystal Reports ( 8.0 or 8.5 or above) using which we can plot dates on X- & Y- axis. This is possible using Microsoft Excel, but for some reason, Crystal Reports simply allows numbers to be plotted on Y-axis and...

Part and Inventory Search

Back
Top