inventory audit report show base and target doc
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19412
Printed Date: 04 Apr 2025 at 10:19pm
Topic: inventory audit report show base and target doc
Posted By: tkaa
Subject: inventory audit report show base and target doc
Date Posted: 15 Apr 2013 at 8:01pm
I am rookie of SAP and crystal report. My boss want the inventory audit report can show the base document and target document.
At
Begin, I started to using crystl report to buildup the origin view of
inventory audit report but i find the problem in links to the base
document. I using able is OINM, Base_REF and i want to link this
document of base document.
Example: inventory audit repory shows
the document is DN-xxxxxxx , i want find the base and target document of
this DN-xxxxxx. But it contain other many document. Also when i try
links OINM, Base_REF to ODLN,DocNum, it can't. I think the reasons is
OINM, Base_REF is char and ODLN,DocNum is str. How can slove it? Sorry
of ask to many question. Thanks.
|
Replies:
Posted By: tkaa
Date Posted: 17 Apr 2013 at 8:26pm
Posted By: kevlray
Date Posted: 18 Apr 2013 at 7:59am
|
Please do not cross-post. By the way I have read your question several times, and I am not sure what you are trying to acheive.
|
Posted By: tkaa
Date Posted: 18 Apr 2013 at 8:10pm
Sorry of that. I just want to know how to link OINM base_Ref to different table docnum like ODLN Docnum. It can't link each other because OINM base_Ref type are nVarchar but ODLN Docnum are int.
|
Posted By: kevlray
Date Posted: 19 Apr 2013 at 7:18am
If you can write a command and it is a MS-SQL database I have seen some code where you can change the data type when linking the tables. I have never attempted this (never needed to). FYI: Not all versions of CR allow creating a command.
I hope this helps.
|
|