[Facility] Produce list report with duartion of classes for each day in date range

[EmmatheDancer]

I am looking to produce a report which would have a column for Tutor name, a column for class code (i.e. the name of the class) and then a column for each day in the date range specified through variables when the report is generated. I need the columns for each day to contain the sum of the duration (in minutes) for that class on that day. I don't know if we could have the columns dynamically generated but having blank columns on the end is fine. I thought perhaps an if based on the start date variable + so many days unless greater than the end date? I currently have a report which will give me the total minutes for the entire date range, the code looks like this:

 

a:=Event.Weeks.List.Date; b:=Event.Duration.Mins; sumlist(apply(a,v,if((date(v) >= Date(Var('StartDate'))) and (date(v) <= Date(Var('EndDate'))),intplus(getat(b,applyposn)),0)))

 

I myself don't really understand what's going on here, I'm not sure what 'apply' does in the code nor where the 'v' comes from, 'inplus' is also a mystery along with 'applyposn'. Unfortunately, I can't get hold of the person who originally wrote the code above.

 

Does anyone have any ideas how I might achieve this?

 

Many thanks.

 

Emma

[john]

@michael2k6 maybe able to give you some clues he's fairly clued up on these things

[michael2k6]

Hi all,

 

I did see this thread and unfortunately, I can't help, as I never had much experience with reporting in Facility, but I have emailed the URL to the support team in case someone can help.

Mic

[EmmatheDancer]

@john @michael2k6

 

Thank you both for your efforts. My hopes lie with the support team then.

 

Emma