By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,673 Members | 1,716 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,673 IT Pros & Developers. It's quick & easy.

Quick Report Question

n8kindt
100+
P: 221
my current format (for my report) is

Date | Total1 | Total2 | Total3
Date | Total1 | Total2 | Total3

how can i change it so that it reads like this:

Date__|__Date
Total1_|_Total1
Total2_|_Total2
Total3_|_Total3

(i want columns instead of rows)

i even tried organizing it through a pivot form but hit a dead end. it seems to me that this would be a question that would have been gone over before but i guess i'm not searching the right keywords or something.

Thank you!!
Mar 17 '08 #1
Share this Question
Share on Google+
4 Replies


n8kindt
100+
P: 221
fwiw, if i change the layout of the fields from tabbed to stacked, it displays it exactly how i would like it. however, the next recordset starts on the next page.

so
a) how do i make the data start a new column instead of a page
and
b) once this is accomplished, rather than having the header repeat itself for every column, how do i make the "header" only display once?
Mar 18 '08 #2

n8kindt
100+
P: 221
fwiw, if i change the layout of the fields from tabbed to stacked, it displays it exactly how i would like it. however, the next recordset starts on the next page.

so
a) how do i make the data start a new column instead of a page
and
b) once this is accomplished, rather than having the header repeat itself for every column, how do i make the "header" only display once?
ok, i solved problem A.... now for Problem B... how do i get the header from repeating continuously??? i need help FAST
Mar 18 '08 #3

n8kindt
100+
P: 221
here is what i have so far.



once again, how do i show the label for the controls only once when in the detail section? or is there a way to make it appear once per page? i'm stuck.
Mar 18 '08 #4

n8kindt
100+
P: 221
if someone would please reply, i would very much appreciate it.

i have now tried to change the vertical property to "no" on the textboxes in the report. this displays everything great in the report view. it's not a perfect solution but it is acceptable. now, for a new problem. when i go into print preview, the text is displayed properly, but every number shows up as ######. i widened the field and that did nothing. i thought it might be a printer error so i exported it into pdf but i received the same result.

here are illustrations of my headaches:

this is report view



this is print preview




can somebody please help? i have tried 3 different ways to do this (explained above), and everytime one minor thing is keeping me from completing it :-(
Mar 18 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.