Baanboard.com

Go Back   Baanboard.com > Blogs > pchuen's blog

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

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.

select
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
from
tdpur400, | Purchase Orders
tdpur401, | Purchase Order Lines
tccom100, | Business Partners
tcibd001 | Items General
where
tdpur400.hdst <> tdpur.hdst.closed


0
No votes yet

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

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
Quote:
Originally Posted by pchuen View Post
Hello,

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.

Regards

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 00:33.


©2001-2017 - Baanboard.com - Baanforums.com