Aggregating Data by Row

javitta

Hello!<br />
<br />
This may be the case that the database was created improperly however, that cannot be changed and data is stored:<br />
<br />
<span class='bbc_underline'>Model</span> <span class='bbc_underline'>Year</span><br />
Mod1 1990<br />
Mod1 1991<br />
Mod1 1992<br />
Mod2 1991<br />
Mod2 1992<br />
<br />
Now each "customer" in the system can be assigned multiple variations of models and years, is it possible to aggregate the data by model for a user? e.g.:<br />
<br />
<span class='bbc_underline'>Model</span> <span class='bbc_underline'>Year</span><br />
Mod1 1990-1992 --or--<br />
Mod2 1991, 1992<br />
<br />
so that the number of rows can be minimized?<br />
<br />
Thanks in advance!<br />
<br />
Jacki

thuston

Create a Model Group and in the group header you can use an Aggregate control and CONCATENATE the ["year"] String.