Summary in Detail Section?

[Sandman83]

I am trying to do something a little weird. I have been requested to build a report that gives sign on/sign off detail. When the user signs off, they are required to enter a reason code. In the report, they want a summary of each reason code next to the detail. I know I can get it summed up underneath the detail, but don't think it can be put next to the detail. Something like this. Any ideas?

Signon  Signoff  Reason  Dur On  Dur Off Times Reason Dur Off

12:00   13:45    Break   1:45    :15     2     Break  :30
14:00   16:00    Lunch   2:00    1:00    1     Lunch  1:00
17:00   18:45    Break   1:45    :15

Thanks,

Tim

 

[lbass]

You could do the summary in a subreport which is placed in a group header section for employee and linked to the main report on the employee field. Then go to the section expert->group header->underlay following sections. This will align the group header with the details section.

-LB

 

[Sandman83]

The details of the report are currently in a subreport. Could I still create a second subreport for the summary and try using underlay section? Sorry for the weak question, but I have never used underlay and always wondered what it was for and how to us it. Thanks.

 

[lbass]

If the details are already in a subreport then you could just add a second subreport next to the first in the same section.

-LB

 

[Sandman83]

Thanks, I'll give it a try tomorrow.

 

[Sandman83]

Hi LB,

I must not be doing something correctly. I tried checking the 'Underlay...' box on several different sections and it doesn't change anything at all.

 

[lbass]

If you are using two subreports side by side, you don't really need to use underlay--you can place them in the same section. Please explain where you are placing the subreports (what sections).

-LB

 

[Sandman83]

I'm placing them side by side in the Report Footer of a container report. Just doing that won't line them up though. The second subreport is almost identical to the first except I have to add an additional group to sum up the data I need. Unfortunately, I can't add the same group to the first subreport since some of the formulas need the specific grouping.

 

[lbass]

I can't really help unless you provide a lot more information. Lining up the information from the two reports is really a matter of suppressing all unused sections and playing around with section heights, etc.

Are these subreports part of a larger report? If these are the ONLY parts of the report, then one could be the main report, and the summary could be a subreport.

I should have suggested this earlier, but you could also insert summaries to get the summary fields and then drag them into a group header where you would then use "Underlay following sections" to get the required alignment.

-LB

 

[Sandman83]

I appriciate the help, but I don't think either approach is going to work. Some of the items that need to be summarized have to be done within formulas since Crystal will not allow me to summarize them with the summary tool. Aligning them by hand does not seem possible since the first sub report has a detail section that could have an unlimited amount of detail records and the second sub report does not.

 

[lbass]

What exactly do you want aligned? Why don't you provide a larger sample of data so we can see? Also you should explain the group structure of the first report and how the summary relates to that.

There is a way to do this, but you have to convey your exact requirements.

Also, you can insert summaries on formulas. If the issue is the time format, you would do the calculation in seconds, insert a summary, and then convert the summary to the time format for display purposes.

-LB