MJ wrote:
> I have a data set with some info - PK, Field1, Field2, Field3 etc.
>
> I need to dynamically display columns base don Field1, with Field 2 and
> Field 3 displaying once for each Field 1. The PK is the row. I figured
> this out easily enough with column groupings.
>
> My next step is to organize it in such a way that two of the values for
> Field 1 require static positions (first column group and last column
> group). Let's call these values "#1" and "#100". Now I can do this in
> the stored proc, ordering it a certain way, but circumstance dictates
> that I handle this on the front end.
>
> Now I can add a filter to my column group for the Field 1 value to show
> first. No problem. But I can't seem to figure out how to add a second
> column group (exactly like the first) where I don't filter, then a
> third column group (exactly like the first two) where I statically
> filter on another value.
>
> I guess in summary my problem is I can't figure out how to have the
> same fields as column groupings multiple times. Is this possible?
>
> Eg.
> Field 1 ('#1") Field 1 (dynamic, #2 -
> #45, etc) Field 1 ("#100"
> Field 2 Field 3 Field 2
> Field 3 Field 2 Field 3
> PK (row)
>
> Thanks