Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Google search


Poll
What version of Baan have you installed
Baan IV
31%
FP3
3%
FP4
0%
FP5
0%
FP6
2%
FP7
3%
10.2 (incl. 10.2.1)
3%
10.3
7%
10.4
19%
10.5
28%
Other
2%
Total votes: 86

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 09:24.


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