Need immediate Help Please (reporting layout)

  • Thread starter Thread starter ngreen
  • Start date Start date
N

ngreen

Hello,

I have a layout question?

I have a report that I want to change the layout but I
don't know how. My report only displays the info on one
column. To utilize more space, I would like to display an
extra columns on the right hand side of the report.

Please look at the before and after to get a visual.

My current report(before) look similar to this: Look
below...

Canned Vending (this is bold)

Outlet: 9800
Cash Difference: -8524.6
Cash 6771.65
Sales 15296.25
Sales at 7716.64

Gross Profit1(this is bold)

Outlet: 1
Cash Difference: 21.75
Cash 18416.45
Sales 18394.7
Sales at 15685.49

Gross Profit2 (this is bold)

Outlet: 9700
Cash Difference: -1757.95
Cash 2929.65
Sales 4687.6
Sales at 4005.34


**********************************************************
I want it to look at this....(after)


Canned Vending (this is bold) Gross Profit1

Outlet: 9800 Outlet: 1
Cash Difference: -8524.6 Cash Difference: 21.75
Cash 6771.65 Cash 18416.45
Sales 15296.25 Sales 18394.7
Sales at 7716.64 Sales at 15685.49



Gross Profit2 (this is bold)

Outlet: 9700
Cash Difference: -1757.95
Cash 2929.65
Sales 4687.6
Sales at 4005.34
 
I have a report that I want to change the layout but I
don't know how. My report only displays the info on one
column. To utilize more space, I would like to display an
extra columns on the right hand side of the report.

Please look at the before and after to get a visual.

My current report(before) look similar to this: Look
below...

Canned Vending (this is bold)

Outlet: 9800
Cash Difference: -8524.6
Cash 6771.65
Sales 15296.25
Sales at 7716.64

Gross Profit1(this is bold)

Outlet: 1
Cash Difference: 21.75
Cash 18416.45
Sales 18394.7
Sales at 15685.49

Gross Profit2 (this is bold)

Outlet: 9700
Cash Difference: -1757.95
Cash 2929.65
Sales 4687.6
Sales at 4005.34


**********************************************************
I want it to look at this....(after)


Canned Vending (this is bold) Gross Profit1

Outlet: 9800 Outlet: 1
Cash Difference: -8524.6 Cash Difference: 21.75
Cash 6771.65 Cash 18416.45
Sales 15296.25 Sales 18394.7
Sales at 7716.64 Sales at 15685.49



Gross Profit2 (this is bold)

Outlet: 9700
Cash Difference: -1757.95
Cash 2929.65
Sales 4687.6
Sales at 4005.34
Click to expand...


Open the report in design view, then use the File - Page
Setup menu item and select the Columns tab. Set the options
you want and save the report. Try it and adjust to suit you
needs.
 
Back
Top