Layout Question

[spam33]

Ok, I want to make a particular layout, but I'm kind of confused as to how I should design it. I guess the best way for me to describe my layout is to show you how I'd like it to look. First off, here are some of the main fields...

Song Title, Film Title, Status (can be one of three options...New, Researching, Complete).

And here is how I want my layout to look

___________New________Researching_________Complete______Totals

---------------------------------------------------------------

Film 1__|___2______________0__________________1_____|_____3

Film 2__|___0______________9__________________6_____|____15

Film 3__|___5______________1__________________3_____|_____9

---------------------------------------------------------------

Totals______7______________10_________________10_________27

The numbers represent the number of songs that have that status (for example, Film 1 has two songs that have a status of "New").

Can anyone give me advice as to how I can design this layout? Thanks so much for the help.

Cameron...

[Lee Smith]

Hi Cameron,

This looks like a list view, have you tried making a List View (Columnar list/report) layout?

To do that, go to Layout Mode and then to the Menu Item Layout, New Layout. Second choice is Columnar list/report. choose the fields you want to show and you are on your way.

HTH

Lee

[jasonwood]

The numbers represent the number of songs that have that status (for example, Film 1 has two songs that have a status of "New").

Sounds like this is a songs database where you have a record for every song, and possibly multiple records for every film (if there are more than one songs)... if this is correct, just go throught he new report assistant. You're going to want to sub-summarize by film, then have a trailing grand summary for the grand totals. Once you have your report, you can probably delete the body "part" so that it only shows the summaries (as your example shows).

I've never tried deleting the body part so I'm not sure if this will cause problems (if so, you can probably just remove the fields and shrink it right down).

[RussBaker]

Deleting the body part is fine.