Report in Horizontal format

[Nidhisharma]

Hi Folks,
I need some help, I have Sales table,SalesRep1 table,productdetail table. Based on these three tables I made a query salesquery where I got the output as required.
In Sales table there are 20 fields such as storeno,Productno,agentno,month,Tot_sales etc etc.
Salesrep1table consist of fields such as storeno,storename,city,productname.
Fields of Productdetail tables are Productno., productname,size.
Now I have combined these tables in a query and got the output as Storeno,Storename,city,month,productno,productname ,Tot_sales.

eg:-1, Abc Store, xyz,11,111, P1, 50
2, Bcd Store, asd, 11,112,P2, 90.

My Problem is I want to display the data or report in Horizontal format.
i.e I want to create a report as
Storeno, Storename, city, month, P1, P2, P3...........................P20 Tot_sales

Eg:-

Storeno Storename City Month P1 P2 P3 P4 Tot_sales
1 ABC yyy 11 50 50 10 10 120
2 BCD zzz 11 10 20 12 40 82
3 SSD xxx 11 20 2 33 20 75
4 AAD sss 11 55 32 50 20 157
5 BBD ddd 11 40 30 40 40 150


I don't know how do I display it in horizontal fomat so that it fits in one page

instead of 20 pages.

Please help me out.
your help will be much appreciated.
Thanks

[kepston]

The usual methods to increase what you can print include:

1. Page setup - landscape
2. Page setup - reduce margins
3. Text box Format - reduce font size
4. Report Wizard - Adjust field width so all fields fit on a page
5. Reduce space between fields
6. Reduce field widths to show only data and no space
7. Change number format

Alternatively, consider changing report format
StoreNo, Store Name, ...
P1,P2,P3,....

or
StoreNo 1 2 3 ...
Store Name xyz uvw rst
P1 10 10 20
P2 20 20 30
P3 50 10 40
.
.
.

[missinglinq]

After doing the steps that kepston has pointed out, when dealing with a report where you just have to have everything on one line, I set up a dummy record, with each of the fields holding the maximum number of characters as defined in the underlying table(s) to insure that the field widths, as defined in the report, are adequet. Unless I'm using a monospace font (which I detest) I'll use all capital Ms with the final character being a capital W. These are the two widest characters in most non-monospace font sets; the different character at the end allows you to know that the field is wide enough to display all data without having to actually count the characters.

Good Luck and Welcome to TheScripts!

Linq ;0)>