Jump to content

Subsummary reports


This topic is 7795 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need some layout help for a script/subsummary report....

I have 6 fields each with a popup menu that has dates for the next month (these dates correspond to tasks). I also have a calculation field that calculates total hours.

Heres my issue...

If I have records which have six tasks with assigned dates (some tasks have the same dates) how can I create a report which will (1) combined the dates in six different popus so that I can create a report based on a single date and inlcude records/tasks under (2) show a record in more than one date in the summary if tasks spread over multiple dates...

Link to comment
Share on other sites

I would modify your data a little different.

A record can not show up in two places on a sub summary report.

I would sugguest you create a transaction file for dates of tasks

and enter this data via a portal from your main file.

In this new file you can have date and task. Then when you want to print a report you can navigate to this file and generate the sub summary you wish Each Record is a Task and a Date, therefore if you can sub summarize both ways by date then task or by task then date.

Link to comment
Share on other sites

This topic is 7795 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.