Re: crosstab for durations

I'm not sure how you can do this in a cross tab. I don't believe you
can format the summary value in the manner you want to. However, you
don't really need a cross tab for this report as you only have one
column. It would work if you did the following:

1. Get rid of the cross tab.
2. Create a group for the time interval you want (month, year, etc.)
3. Create another group for the person.
4. Create another group for the project.
5. Place the integer field representing the number of minutes in the
details section and summarize it in the group footer for the project
(using the sum aggregation).
6. Use the follwing formula in the group footer for the project, to
display the time in the format you specified.

numbervar Minutes := 1000; //NOTE: This should refer to the summarized
value from step 5.

NumberVar TotHours;
NumberVar TotMinutes;

TotMinutes := remainder(minutes,60);
TotHours := (Minutes - TotMinutes)/60;

ToText(TotHours, 0) + ":" + ToText(TotMinutes, 0);

In this case, the variable "Minutes" would be replaced with your
summarized value.

I know that isn't exactly what you wanted, but it should work.

yves wrote:
Hello everybody,

I'm working currently on a time accounting application for my company.

Therefore I would like to produce with crystal reports a crosstab report
containg for a period (month, week...) :
- for each person in the organization (column) ;
- for each project (row) ;
- the duration for the period (summarized field).

The 'summarized field' duration is an integer data with the duration in
minute.

In the report I would like to display durations in hours and minutes
(for example : 39:30 for 39 hours and 30 minutes).

All I'm able to do is to display the duration in hours (39.5 for 39
hours and 30 minutes).


I unsucessfully tried some workaround solutions like storing duration in
days (ex. 0,5 for 12 hours...) or storing duration in date format in
order to cheat with Crystal reports or play with the function
whileprintingrecords.

Could someone give me an advice or an idea to produce such a report ?
Thanks in advance.


Yves

.

Relevant Pages

  • Re: Software metering data not showing up in reports
    ... summarize data 12 hours old or older. ... > About to generate report head]Log]!><time... ... > Pacific Daylight Time> ... > New usage processing thread started, ...
    (microsoft.public.sms.inventory)
  • Re: Arithmetic sum of subtasks
    ... If you don't have any resources assigned, then in a very real sense you don't have any man-days to summarize anyway. ... Summing duration days and arbitrarily calling the sum "total man-days" is mathematically incorrect and functionally completely meaningless until you know how many resources are working on each task and at what level they're working for each duration day. ... excepted when all the assignments are one person full time ...
    (microsoft.public.project)
  • Re: How do I count individual records in the Detailed section of a
    ... By sub report do you mean detailed summary? ... By class I mean Class/Section for instance Acc220 002. ... attributes I mean Class average GPA, class minimum GPA, class maximum GPA, ... I am able to summarize most of the attributes I am looking for in the Detail ...
    (microsoft.public.access.reports)
  • help with report
    ... It's been a while since I have done programming work in FMP, ... I'm a little rusty. ... I made a summary report that shows the number of hours logged for each ... and the summary part is set up to summarize on the field "Job#". ...
    (comp.databases.filemaker)
  • Re: numerating pages, and summarize fields
    ... Summaries in the report footer will appear only at the end of the ... If you want to summarize the information on the page, ... > report header section1 ...
    (microsoft.public.vb.crystal)