Re: Anyway to make rows as columns

Alec Pojidaev — Thu, 26 Feb 2009 16:32:33 GMT

I believe that operation is called pivoting. And probably Infopath isn't a good tool to do that. I suggest you should to task your SQL admin guy to create the view you could consume in InfoPath. Another way would be to use analytic tools like SQL Analysis Services where the data already is aggregated in desired fashion.

Anyway to make rows as columns

pablavo — Thu, 26 Feb 2009 15:56:30 GMT

Hi There,

OK, I believe there probably wont be a way to do this. I have a database with a table and two of the columns have only a set amount of data. one row has 4 consistant values (for Brevity, I'll just make them fruit - Oranges, Apples, Pears and Berries) the other column, again, has a consistant amont of values (SuperMart, JollyGrocers, FruitMans)

There is another column that holds costs so the table would look like this in the db

Fruit-----------Market---------Cost
Apples--------SuperMart---------$1
Bananas-----SuperMart---------$2
Oranges------SuperMart---------$3
Pears----------SuperMart---------$1
Apples--------JollyGrocers------$3
Bananas-----JollyGrocers------$2
Oranges-----JollyGrocers------$2

I want to produce a repeating table in Infopath forms that will use the database table as the data connection. However, I want to know if there's a way where I can display the repeating table like so:

Fruit------SuperMart-----JollyGrocers-----FruitMans
Apples--------$1----------------$2-----------------$3
Banans-------$2----------------$3-----------------$3
Oranges------$3----------------$1-----------------$7
Pears----------$1----------------$3-----------------£2

This would also have to be a submitting table, meaning I'd have to be able to add info to the table. Slightly strange question, however, this is incase there are more supermarkets or fruit added to the table. If I new there wouldn't be any more Markets, I'd make them columns. (of course, I'm only using markets and fruite as an example)

Hope that makes sense.

Thanks for any help that I recieve.

Controls

Re: Anyway to make rows as columns

Anyway to make rows as columns