Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a list in SharePoint i'm trying to generate a report out of in InfoPath 2010. I need the Work Location and the Job Cateogory fields. Work Location could have multiple occurrences as these are job postings. Same with Job Categories. What i would like is a unique list of all Work Locations and then beside them the breakdown of how many instances in each job category. Like this:

Work Location            Job Category 1            Job Category 2           Job Category 3
Edmonton                 2                         8                        2
Calgary                  1                         0                        3

The complications arise in that Job Category is a single column, I'll know what Job Categories to filter for in the report though. The other complication is that i will need to display unique Work Locations. Any ideas? I'm fearing there's no no-code solution for this and that i'll have to crack open Visual Studio.

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.