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...
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)
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...
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...
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...
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)?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.