How to Display a record set on a report (14 fields same table) horizontally?

[Kitchconsult]

I have 14 (num) fields that correspond to a category (25 character phrase). So, as of now I have the report set to list the fields by category vertically. The report is set to group by Year (Field) and by Month (Field).



I created a cross tab query that displays the data with the month and year on the left side and the category across the top, which is fine except you can't read the categories, but the fields are correct by date.

So, when the report runs, each record displays downward. What I need is the records to display in a columnar format across the page (Landscape) by year and by month. Any ideas? I haven't been able to crack this nut.

Thank you

[June7]

I don't understand data structure. You have 14 fields that hold the same kind of data? What do you mean by '25 character phrase'?

Sounds like non-normalized data structure and if that is the case, what you want won't be simple.

Provide example data. If you want to provide db for analysis, follow instructions at bottom of my post.

[Kitchconsult]

Sorry if I wasn't clear, the (labels) assigned to the 14 fields are a phrase, so they can't be read via a column. Ideally, at the top of the report should be the months of the year and showing the values of each of the 14 numbers in a column directly below it. When the report runs, it should display the record rows across the report lt. to Rt. not down the page, like a spreadsheet across.

Does that make sense?

[June7]

I still don't understand structure. What does it matter what the label captions are? Use field names. Provide example raw data.

[orange]

I think this is one of those --a picture is worth a 1000 words --situations.

[Kitchconsult]

So just imagine Description labels on the left of each row. So each column (Month) is a record containing 14 rows down of data. What I want the report to display is the columns left to right across the page of the report. Not vertically down the page, leaving basically 1 record per page. Sorry I can't show the labels the data is sensitive. Thanks,

[June7]

Still clear as mud. This is your raw data? So you have 12 columns (fields) - 1 for each month? If data is multi-year, where is year identifier? Data structure still is not normalized. Why do I see 21 rows and only 5 with data?

What did you mean by "can't read the categories" - why not?

What do you mean by "at the top of the report should be the months of the year and showing the values of each of the 14" - isn't this the example you posted? Asked for raw data, not desired output, although that may be helpful also.

Don't care about nor need your real category descriptions. We can use Cat1, Cat2, etc. if you like. But really need to understand actual table structure.

[Kitchconsult]

Good morning,

I guess I know what I want, but I am having a tough time explaining the issue, for that I apologize.

I think that I'm over complicating the problem. Table structure isn't really a factor. What you see below is 1 record. So in a nut shell, I want to have a report populate the records left to right across the page. As it stands now, the report shows each record below (Vertically) the first record. So, how can you get a report to take the month column and repeat the column (Month) across the page, or isn't that possible? Then total it at the end (Right). Sorry for being stupid about this. I'm just not seeing the answer. Thanks again,

Category Year Month
2015 Jan
1 The dog saw the cat 1
2 The cat saw the dog 0
3 The mouse saw the dog 7
4 The cat saw the mouse 0
5 The rat saw the dog 16
6 The pig saw the cat 0
7 The lizard saw the dog 6
8 The mouse saw the lizard 0
9 The cat saw the lizard 2
10 The pig saw the dog 0
11 The cow saw the cat 12
12 The cat saw the cow 0
13 The mouse saw the pig 0
14 The dog saw the cow 4

[Kitchconsult]

The number column removed all the spaces it should have been a month column to the right. Geez.

[June7]

Actually, table structure is a factor. If this is the raw data structure - technically, in a table those are 15 records, assuming the 2015 Jan line is also a row in the table. This is not a proper structure for database. The answer is to properly construct table and fix the data and then figure out how to achieve what you need.

If this is not the raw data structure, then I cannot help further because you are not providing the requested information needed to analyze the situation and offer relevant advice.

[Kitchconsult]

No, actually, as I said above that column of numbers (all 14) are fields in the table and are one record, not 15 records. So the categories or descriptions are just labels for the corresponding fields. The data is entered on a form; the user selects the year and the month via a pull down combo box, then completed the number of each of the categories, saves it and moves on to the next year and month accordingly.

Why does the table structure have anything to do with displaying a column of fields as a record and have it populate Left to right? To me it should have to do with the formatting of the report, not the table. The report doesn't care, does it?

I appreciate your time regardless,

Thanks

[June7]

The raw data structure determines the method needed to rearrange the data to the output structure you want - because it sounds like a rearrangement is needed. Still having a hard time visualizing what you describe as '1 record'.

RecDate

Cat1

Cat2

Cat3

Cat4

Cat5

Cat6

Cat7

Cat8

Cat9

Cat10

Cat11

Cat12

Cat13

Cat14

1/1/2015

abc

def

ghi

jkl

mno

pqr

stu

vwx

yza

bcd

efg

hij

klm

nop

1/2/2015

qrs

tuv

wxy

zab

cde

fgh

ijk

lmn

opq

rst

uvw

xyz

bac

edf

If that is the raw data then it is not normalized. And I don't understand how you achieved report output described in post 8.

So again, provide requested info or can't help.