How to Print horizonatally

sunnyk
sunnyk Member Posts: 280
edited 2008-06-06 in NAV/Navision Classic Client
Hi Experts,
I have four companies in my database. I made one report with company Dataitem and Item Dataitem with Item indent under Company.
Now when i select one item in the report it shows the quantity of that item in the all 4 companies like

Company1
Item No.XXXXX
Qty-4
Company2
Item No. XXXXX
Qty-3
Company3
Item No.XXXXX
Qty-5


but my query is how to get the result in horizontal format like

Item No. XXXX
Company1 Company2 Company3
QTY 2 3 4

Please Advice!

Comments

  • rajpatelbca
    rajpatelbca Member Posts: 178
    you cant print this way

    company1 company2 company3 .... horizontally.

    because this is not static. in future no of companies grow up.
    but no of quarter are fix (4 quarters) so you can create variable having dimension value 4 and find those values for one company and store it in a variable.after that you can print all quarter in same row.
    company1
    item no.
    Qty1 Qty2 Qty3 Qty4.

    company2
    item no.
    Qty1 Qty2 Qty3 Qty4.

    hope it helps.
    Experience Makes Man Perfect....
    Rajesh Patel
  • sunnyk
    sunnyk Member Posts: 280
    Hi rajesh thnx for the quick reply but my objective is not to print in quaters.
    Suppose today i run this report and select a particular item say A-123B
    then the report must show Qty on hand in all the companies as

    Item No. A-123B
    Company Name Company1 Company2 Company3
    Quantity '2' '3' '4'

    I hope u got it what i m asking:)
  • rajpatelbca
    rajpatelbca Member Posts: 178
    if no of company will increase then what you will do ? you have to edit this report every time when you add a company. the reason behind is that you can create no. of companies its not static.
    Experience Makes Man Perfect....
    Rajesh Patel
  • pruday
    pruday Member Posts: 11
    You can try Matrix type Form.
    Uday
  • sunnyk
    sunnyk Member Posts: 280
    Ya i know the no of companies are not static. but suppose i have only three companies at present how can i show this data on report.

    Uday- I m trying this on matrix form also.:)

Categories