I am trying to create a template to generate session reports.
I have a table called “Sessions”
These record goals that were worked on during the session
Goals are grouped into domains.
Goals and Domains each have their own tables where information about them is stored.
Goals has a column referencing the domain that the goal belongs to.
Each session may only use a subset of goals from a subset of domains.
Within my session table I added two virtual columns
One for the Goals that were used for the session referencing the original goals table
One for the Domains that those goals that were used belong to referencing the original Domains table
In my template I used a <Start:> statement to select all the domains.
For each of the domains returned I added a sub <Start:> statement to only return the goals that belong to that domain.
When I generate the report I successfully only get the domains that were used, but below them are all the possible goals that belong to that domain and not just the goals that were used during the session.
I added some extra lines below the chart just to ensure that my statements should be working.
One referencing the Virtual “UsedGoals” column directly
One using a select statement instead.
You see these below the table in the template
Here is my template
This is what it produces
Here it is in word with what I am trying to achieve
I am currently using
to guide me though this creation process but have not found anything there that explains this.
Any ideas as to what I am doing wrong?
Thanks in advance