Code

Re: Display a separate table/repeating table for each Quarter

Somebody — Mon, 10 Sep 2012 14:43:00 GMT

Hello,

Thanks for the response!

The quarter value is stored in the same dataset where I pull all other data which is the main dataset. How do I show a separate table for each of the quarter that is found in this main dataset?

Currently, my repeating table uses data from this main dataset and I have to create a separate table and hardcode the quarter value in the filter for each of the quarter that I'd like to show.

Is there a way to list these tables separatedly by each of the available quarter found in the main dataset?

Thanks!

Re: Display a separate table/repeating table for each Quarter

Gennady Vanin (Геннадий Ванин, Новосибирск) — Tue, 04 Sep 2012 15:27:08 GMT

And where is a dataset stored and how it is being changed?

If you store it in a list, create receive/secondary data connection, drag.n'drop data fields into a repeatin table, it would show exactly what you have specified, wouldn't it?

Display a separate table/repeating table for each Quarter

Somebody — Tue, 04 Sep 2012 12:31:35 GMT

Hello,

I'm creating a infopath form in 2010 and would like to show a table/repeating table for each of the quarter in the dataset. My datast has Revenue by country by quarter. I would like to show something similar as below for each of the quarter in the dataset. So if I have two quarters, two tables would show; but if I have only one quarter, there should only one table shown.

Thanks for your help!

Q1
Country	Revenue
USA	100
Europe	200
Asia	300


Q2
Country	Revenue
USA	100
Europe	200
Asia	300