Go Back > Blogs > pchuen's blog

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 47

Baanboard at LinkedIn

Reference Content

SQL Query unable to fit page layout or changes in script unable to refresh when display report
By pchuen at 15 May 2015 - 04:42

Dear All,

Hope you can help me with this. I am a newbie in LN Infor.
Had extracted a simple SQL query , the display in the report seems to be truncated. For eg. I have 10 fields, but the reports only showing 4 fields. Even though, I have exported to excel. Report only shows, orno, odat, item.

Please advice where I went wrong. At the same time, after I change the sequence of the field, it doesn't seem to refresh on the report. Thank you in advance.

tdpur401.orno, | Purchase Order
tdpur400.odat, | Order Date
tdpur401.item, | Item
tcibd001.dsca, | Description
tdpur401.qoor, | Ordered Quantity
tdpur401.qidl, | Delivered Quantity
tdpur401.cuqp, | Unit of Measure
tdpur401.pric, | Price
tdpur400, | Purchase Orders
tdpur401, | Purchase Order Lines
tccom100, | Business Partners
tcibd001 | Items General
tdpur400.hdst <> tdpur.hdst.closed

No votes yet

by bhushanchanda on May 15, 2015 - 9:20am
bhushanchanda's picture

This is not the right place to post your questions. Please post your questions in related forums.

This one should go in Tools Development forum.

In this case, you need to select the report size as 255 character(this is the maximum size allowed) and then you can click on generate report. And try again.

by bdittmar on May 16, 2015 - 12:51pm
bdittmar's picture
Originally Posted by pchuen View Post

while generating report you've got message "Fields does'nt fit on page".
Chose a proper page layout.
Maybe A4 smal manual with 255 colums.
Or maintain the generated reportlayout.


by rajesh1983 on May 20, 2015 - 7:50am
check the report layout and adjust the field length.
may be some fields are not required to print in report mark exclude.

All times are GMT +2. The time now is 13:25.

©2001-2018 - -