DavidHuang
Active Member
Hi all,
In 8.11 SP1, I created a customized business view, joined F30026 and F4102 by (ITM/F30026 - ITM/F4102) and (MCU/F4102 - MMCU/F30026). Then created a batch program base on that view. But the output on the PDF report was incorrect, as followings:
--------------------------
No Data Selected
ERROR:
Unable to locate table in specified datasource for section: Export Item Cost Component
---------------------------
I have checked, the data selected exist in the system.
But when I join F30026 and F4102 only by ITM, the PDF can show the selected data correctly.
This happened on server. But in the 8.11 standalone, both type of join work properly.
And in 8.0, I never saw this kind of error.
In knowledge garden, I find several cases having the same error message, but it's all with AS400. I don't know why and whether that can help.
We are on:
ERP8.11 SP1 and OS is WIN2003 Server
Tools Release 8.96 G1
SQL2005 SP1
Very appreciate it if you can advice.
Thanks,
David
In 8.11 SP1, I created a customized business view, joined F30026 and F4102 by (ITM/F30026 - ITM/F4102) and (MCU/F4102 - MMCU/F30026). Then created a batch program base on that view. But the output on the PDF report was incorrect, as followings:
--------------------------
No Data Selected
ERROR:
Unable to locate table in specified datasource for section: Export Item Cost Component
---------------------------
I have checked, the data selected exist in the system.
But when I join F30026 and F4102 only by ITM, the PDF can show the selected data correctly.
This happened on server. But in the 8.11 standalone, both type of join work properly.
And in 8.0, I never saw this kind of error.
In knowledge garden, I find several cases having the same error message, but it's all with AS400. I don't know why and whether that can help.
We are on:
ERP8.11 SP1 and OS is WIN2003 Server
Tools Release 8.96 G1
SQL2005 SP1
Very appreciate it if you can advice.
Thanks,
David