Placing a set of columns next to each other

[helloemily]

Hello everyone,
I've been using the Oracle Report Builder 1.2.1 to create all my report through the wizard in Base. I'm curious if its possible in report building to place similar columns side-by-side from one another.

I'm trying to create a report from one of my survey forms for a reading program. This reading program is available at 4 different locations within the city. During the creation of my query for this report, I've used the "group by location" statement so that in my report, each location will have their own column. Right now, when I create a report using the wizard, it produces a single column listing all the outcomes and is repeated based on location. Instead of this, is it possible to have the outcomes and locations next to one another so its visibly easier to tell which location is doing better/worse than another? I hope that makes sense..

Thank you in advance again everyone

Emily

This is a report produced using the report builder:

Is this possible? I used photoshop to create this..haha:

[r4zoli]

The crosstab not supported in report builder, and this is what you want to use.

[helloemily]

Thanks a lot, r4zoll!!!

[eremmel]

If the number of locations is static you might do with SQL.
Create a view (or query) to list all the data for one location.
Join those 4 views, so you have one row with all the locations.

[helloemily]

If the number of locations is static you might do with SQL.
Create a view (or query) to list all the data for one location.
Join those 4 views, so you have one row with all the locations.

Thank you eremmel! I will see if i can do that

Hi eremmel,

The numbers for this for is static. So now, are you suggesting that I create 4 different queries (1 for each location)? I'm quite new to SQL and base for that matter so forgive me if I'm not understanding you correctly. I'm also not sure how to join views/ queries together...
My locations are all from one table, so I don't really understand what you mean when you say "join"..sorry about that

Thanks!
Emily

[eremmel]

Please supply your table layout and the grouping order of your report. You might also attach a Base document if you like with some sample data.
I understand that this approach goes beyond an ordinary user towards a some programming skills, but hitting your brains will result in only less capacity. Keep smiling and take the challenge to learn something.

[helloemily]

Please supply your table layout and the grouping order of your report. You might also attach a Base document if you like with some sample data.
I understand that this approach goes beyond an ordinary user towards a some programming skills, but hitting your brains will result in only less capacity. Keep smiling and take the challenge to learn something.

hi eremmel! I threw out my hammer and took the challenge and tried to make it work, but got stuck again.. Attached is a Base document with some sample data. There isn't really a specific order I'd like the locations to be in, but maybe "Other" should be at the end of the list if thats possible. Right now I have them in ascending order.

Thank you, again!

Emily