CrossTab without the GroupBY - Is it possible?

[txgeekgirl]

I have a small Table that needs to be set up LIKE a CT Query in that I need the Elements to become Field Headers so as to have 1 record with Caseno and Result(s) by Element.

Problem: I do not want them grouped as I really do need to see the result (not summed or counted) and the patient could have more than one record in the resulting TBL.

I need this to be dynamic for any set of elements so I do not want to write specific code per element as column headings.

Is there a way to get qround this? Also, some reports will have 10 Elements while others up to 120 - with either all or some of the Elements... so not real condusive to write specific code.

Case# Element1 Element2 Element3 Element6
Case# Y N N Y
Case# Y Y N N
Case# N Y Y Y

Thanks for any help.

 

[khawar]

You have to use group by

But you can get the appropriate results by grouping properly