My data looks like this:
Inventory ID, Product Name, Product ID, Price, Store Location, Store Category
1, Shirt Cotton, 1, 10, Dallas, Mid
2, Pant Demin, 2, 25, Dallas, Mid
3,Pant Cotton, 5, 20, Dallas, Sml
4,Pant Cotton, 5, 20, Chicago, Mid
5,Pant Demin, 2, 25, Chicago, Mid
Using XSL, I need my report to display the unique pairs Store Location and Store Category on individual pages in the same document. So with this sample data I should have three pages -- the first one with Dallas, Mid data, the second one with Dallas, Small data, and the last one with Chicago Mid data.
I am stumped as to do this. I could filter my dataset first but how could I append all my datasets in xsl?
Could I do a page break in a loop?