December 4, 2014 at 4:32 am
I'm returning two columns from a dataset, Full_Name and Time_Taken. I want to set up a report, grouping on a Row and Column, the report column should take Time from the dataset and give me Total_Time, Min_Time, Max_Time and Average_Time as Columns Names as well as it's values for every row. Total_Time being the count for every Full_name.
Please help
December 4, 2014 at 4:53 am
Do you want Total_Time, Min_Time, Max_Time and Average_Time shown on each detail line or on a single total line
Far away is close at hand in the images of elsewhere.
Anon.
December 4, 2014 at 5:19 am
I want them to be independent columns, next to each other.
December 4, 2014 at 5:34 am
Add a parent group (grouping on Full_Name) to the details and give it a name (eg NameGroup)
Add a column to the right of Time_Taken and set the expression to
=Sum(Fields!Time_Taken.Value,"NameGroup")
set the heading to Total_Time
Repeat this using Min, Max and Avg for Min_Time, Max_Time and Average_Time respectively
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply