Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

 
pchuen's blog
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



All times are GMT +2. The time now is 21:27.


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