How to return data on report that is not included in a group

77 Views Last edit Oct 24, 2016 at 05:37 PM 3 rev

Hi All,

I am currently using Crystal reports 2013 SP5 to build my report. Here is how the design of the report goes:

There is a SQL Server database in the backend with tables such as a Groups, Activities, Users and Main.

Each user has access to a front-end MS Access database to enter their data on a daily basis. A user enters data by selecting an activity and entering the Quantity against it.

Activities are tied to Groups but not all of them have an associated Group. On my crosstab report, I have Activities in columns while the username, Quantities and a field called as "Today's Productive Hours" in rows.

The users make only 1 entry for "Today's Productive Hours" that is recorded as a single transaction corresponding to an activity and quantity.

The problem is that sometimes the users record their "Today's Productive Hours" against an activity that is not assigned to any Group on the report.

Hence, I cannot display their productive hours on the cross tab report due to this issue.

Is there any way to display their "Today's Productive Hours" field on the same row where I am displaying the Sum of Quantities for each Group even though the data entered for this field is not attached to any activity that falls within a specific group on the displayed columns?

Any help will be greatly appreciated.

Thanks!

Nick