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
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

 
Items for 'LN Infor' (by date)
By Date  
Alphabetically By Date  

 

You are browsing all items of this content category sorted by date (most recent first). Note that forum posts/threads are not included here.

 

If you would like to search through the content then please refer to the Site Search page.

 

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 13:59.


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