How to transpose data during display?

B

_Bob

I'm using InfoPath 2007. I have a DataTable with the data coming in in a
list format:

SalesPerson Year Revenue
Joe 2004 $10000
Joe 2005 $20000
Mary 2004 $50000

How can I design the form so the display for input has the Year in columns
and still have the correct data binding, that is:

SalesPerson 2004Rev 2005Rev
Joe $10000 $20000
Mary $50000

Does this require some coding to achieve or just some more advanced binding
configuration?

Thanks
Bob
 
G

Greg Collins [InfoPath MVP]

Probably the cleanest way to do it would be to create a secondary data source (xml file) in the format you want the data that makes it easy to display it according to your requirements. Then write code (or a transform) that take the input data and converts it to the format you created.

Then you just display from your secondary data source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Secondary Y-Axis -- Positioning of Plotted Data 0
Presentation vs. data analysis - two or three hypotheticalprojections 1
Populate based on drop-down - HOW? 1
creating a table for accessing data via Access forms 5
Rich Text Binding to Secondary Data Source? 1
Sum Cells Based on Condition (2 problems) 3
2 different types of data sets displayed on 1 graph 0
how to output data in report using macro??? 0

Top