I have 2 lists, one is a contact list (client, client title, address, etc.), the other is a list of meetings with these clients (client name, type of meeting, date, etc.). The 2nd list has multiple entries for the same client. I am trying to
create a report that combines the data in these lists and displays them like this:
In addition to combining the list data, I also need to break up the Type of Meeting field and sum the number of different types of meetings for each client. I added the 2 lists to a linked source, then inserted the data into a DVWP adding data from
the 2nd list as a joined subview.
I tried this: xsl:value-of select="count(/dsQueryResponse/Rows/Row[@TypeOfMeeting = 'MeetingType1'])" but it just returns 0. I'm not sure if that's the correct method though as I think it will return a count of ALL the rows, not the current
row. Any ideas would be appreciated!
View Complete Post