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

  1. ajoyp2

    Top N Report

    I have a Report in Crystal XI where there are 3 groups , Category, Type and Item for all incidents closed in a date range.Since the requirement is for 25 most frequent CTI, I have suppressed first 2 groups, Category and Type and kept only the summarized group footer of , Item , this would get...
  2. ajoyp2

    WeektoDate and Last Year WeektoDate

    Thanks for your help , I got the date range I was looking for through this formula : {CHG_Change.Actual_End_Date})in Dateserial( (Year (CurrentDate)-1 ), Month (CurrentDate),day (Currentdate)) to Dateserial( (Year (CurrentDate)-1 ), Month (CurrentDate),day (Currentdate) -7)
  3. ajoyp2

    WeektoDate and Last Year WeektoDate

    I need help with a formula for WeektoDate and Last Year weektoDate.The Weektodate in fact is last 7 days data depending on which day the Report is run.I need to do a comparison with same date range for last year in a subreport . I tried Dateadd formula but couldn't the correct data for Last...
  4. ajoyp2

    Running Totals in a Cross-Tab

    Thanks a lot , this works !!!
  5. ajoyp2

    Running Totals in a Cross-Tab

    Ok , The version is Crystal XI The Cross Tab Structure is as follows : Rows: - Different Support Teams ( database field) Column 1 : Tickets Due ( Running Total ) Column 2 : Tickets within Commit Date ( Running Total) Column 3 : Ontime % ( Column 2/Column 1 * 100 ) I can't include Column 3...
  6. ajoyp2

    Running Totals in a Cross-Tab

    I have a problem which may be a common problem while summarizing Reports .I have Running Totals which I use in a Cross Tab.However when I am trying to calculate percentage from these 2 Running Totals I get an error message ,"A Print Time formula that modifies variables is used in a cart or a map...
  7. ajoyp2

    YeartoDate formula

    Thanks but I couldn't this formula to work , Can there be a record selection for 4 different dates ( or 2 date ranges ) for eg records between (July05- Currentdate-365 ) and ( July06- Currentdate)?
  8. ajoyp2

    YeartoDate formula

    I want to create a chart which will compare the Last 3 years records to current month yearwise, eg FY05,FY06 and FY07 . FY05 should be July04 to April06 (current month) and so on .Further we also need a comparison month wise and weekwise . How can the YeartoDate or MonthtoDate function be used...

Part and Inventory Search

Back
Top