Getting Children's Class Years on 1 Line for Parent Report

Andrew Peterson · February 2018

It's been a while since I've done some intense formula writing in CR and I'm stuck on this issue. I'm creating a report that will list all parents based on who is assigned as their solicitor. It would be amazing to have a column/field that simply displays the class years for their children enrolled at the school, sort of like this:

Class Years '18,'20,'22 '18

Parent

John Smith

Jane Doe

Does anyone know what kind of formula I would write for the {CnRelInd_1PrAl.CnRelInd_1PrAl_Class_of} field to accomplish this?

Any help would be greatly appreciated!

John Heizer · February 2018

Andrew Peterson:

It's been a while since I've done some intense formula writing in CR and I'm stuck on this issue. I'm creating a report that will list all parents based on who is assigned as their solicitor. It would be amazing to have a column/field that simply displays the class years for their children enrolled at the school, sort of like this:

Class Years '18,'20,'22 '18
Parent
John Smith
Jane Doe

Does anyone know what kind of formula I would write for the {CnRelInd_1PrAl.CnRelInd_1PrAl_Class_of} field to accomplish this?

Any help would be greatly appreciated!

I've done something similar (Constituents that have multiple values of a particular Attribute that I wanted displayed in a single string) by having a subreport that for each record concatenates a text field with the value of your {CnRelInd_1PrAl.CnRelInd_1PrAl_Class_of} field then passes that text field back up to the main report.

Andrew Peterson · February 2018

John Heizer:

Andrew Peterson:

It's been a while since I've done some intense formula writing in CR and I'm stuck on this issue. I'm creating a report that will list all parents based on who is assigned as their solicitor. It would be amazing to have a column/field that simply displays the class years for their children enrolled at the school, sort of like this:

Class Years '18,'20,'22 '18
Parent
John Smith
Jane Doe

Does anyone know what kind of formula I would write for the {CnRelInd_1PrAl.CnRelInd_1PrAl_Class_of} field to accomplish this?

Any help would be greatly appreciated!

I've done something similar (Constituents that have multiple values of a particular Attribute that I wanted displayed in a single string) by having a subreport that for each record concatenates a text field with the value of your {CnRelInd_1PrAl.CnRelInd_1PrAl_Class_of} field then passes that text field back up to the main report.

Thanks John,

I was able to accomplish it doing that way. Took a little research, copy and paste and tweaking, but it works!

Getting Children's Class Years on 1 Line for Parent Report

Comments

Categories