Creating Dummy Fields in a Report

[Whehir]

I have a Report that pulls an assortment of information from a query. In the first column of the Report I have a Variable that pulls from the parent query. In the second column I have another variable (one of three - call them x, y, and z).

The problem is that x, y, and z will only populate in the second column if they are in the data I am using.

Example (Problem)

Column1 Column2
Variable A y
z

Variable B x
z

Instead I need the report to have the following order

Column1 Column2
Variable A x


y
z

Variable B x
y
z


I thought of creating dummy variables in the data, but it becomes time consuming because the Report needs to be pulled quickly everyday and there are a number of Variables in Column1.

Any help on this issue would be greatly appreciated!!

[Robeen]

Have you tried grouping your Report by Column1 & then sorting by Column2?
Perhaps you could show us a screenshot of some of your data? You can use dummy data if you want.
I'm not sure I totally understood your scenario.

[Bdowns]

I believe i have the same problem as you. I am trying to group by fish species, then habitat they were observed in, then the count. Some fish were never observed in certain habitat types so the report does not have a consistent layout. I would like to see all habitat types repeated for each fish, even if the count was zero. If you figure this issue out, please let me know. I will do the same. thanks