Creating reports and dashboards | Stimulsoft community forum

Hi All,

I am attemtping to create a report that summarizes two types of information. Essntially the report should list for each year,
a list and count of activities, and then for each activity a list and count of sub-tasks. Something like what is in the attached pdf
which shows for each year, the Enter Application Information activity and how many times it occurs each year. The problem with
the report is that for each activity, it is listing all of the sub-tasks for each occcurence of activity. What I'd like to see is a report that looks like WorkOrderTaskReportCorrect.pdf as opposed to WorkOrderTaskReportWrong.pdf.

The sub-tasks most of the time won't equal the activity count, because the sub-tasks may or may not have been completed.

The first part of summarizing/counting activities for a given year was reasonably straightforward, however, I'm having a hard time figuring out the logic for the sub-task part and expect it has to do with setting up proper relationships, but am not sure.

I've attached the report I'm working with along with a SQL Express database for testing.

I am using Stimulsoft Reports.Web 2014.3.0 and Flash Player 19.0 on a Windows 7 Pro machine.

Hopefully someone can point me in the right direction.

Hello.

You report is wrong and it could be much more simple.
Usually we don't create reports for our customers but we do this for this once.
Please, look at the attached report template. It has the same structure as yours.
You only need to add text components with count.

Thank you.

You are right Aleksey - I made that way too complicated. Thanks so much for the guidance!!

Hi,

We are always glad to help yuo!