cost cannot show in 2 columns
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8807
Printed Date: 08 May 2024 at 1:38pm
Topic: cost cannot show in 2 columns
Posted By: skyfox
Subject: cost cannot show in 2 columns
Date Posted: 05 Jan 2010 at 5:54pm
|
file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml -
< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 11">< name="Originator" content="Microsoft Word 11"><>
Now I facing some difficulty on create the crystal report. Kindly please refer to example as below: In Database data show as below: StockCode warehouse cost KW1011 W1 20.00 KW1011 W2 25.00 KW1020 W1 18.00 KW1020 W2 22.00 Now my report design as below: StockCode cost
for Warehouse 1 (W1) cost for
Warehouse 2 (W2) KW1011 20.00 25.00 KW1020 18.00 22.00 I fail to create the report because the cost cannot show in 2 columns by ware house. The data show in report still same as database. Anyone know to solve my issue? Kindly please advice. Thank you. |
Replies:
Posted By: skyfox
Date Posted: 05 Jan 2010 at 6:31pm
|
< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 11">< name="Originator" content="Microsoft Word 11"> file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml - <>
file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml - I tried another way to create report but the result as below: file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml - StockCode -
cost for Warehouse 2 (W2) file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml - KW1011 - 00.00 file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml - KW1011 - 25.00 file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml - KW1020 - 00.00 file:///C:%5CDOCUME%7E1%5Ckhwong%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml - KW1020 - 00.00Still fail… |
