需要生成带有2个表的Vrystal报告. [英] Need to generate Vrystal report with 2 tables.

问题描述

大家好，

在此先感谢您，从2表生成子报表时遇到一些问题.我也早些时候问过这个问题，但是我没有得到正确的答案.请任何人都可以清楚地解释如何完成此任务.再次感谢.

这是我的2张桌子，-费用，项目
费用项目
------------------------------- ------------------- --------------------
Product_ID名称重量件Product_ID项目单位_价格数量类型
---------- ----- ------ ----- ---------- ----- --------- --- --- ----
001巧克力15克120001巧克力$ 12 1.2 R
002面包20克80001牛奶$ 15 1.8 R
001面粉$ 10 2.5 P
002面粉$ 10 3.5 P
002东$ 20 0.8 R
002包$ 10 2.0 R
使用这些表格，我需要一个如下所示的报告，
/////////////////////////////////////////////////////////////////////////////////
产品ID-001名称-巧克力重量-15克装-120
-------------------------------------------------- --------

Product_ID项目Unite_Price数量类型
---------- ---- ----------- --- ----
001 choco $ 12 1.2 R-:在这里，像命令一样，我要
001牛奶$ 15 1.8 R仅"Type like''R％""

Product_ID项目Unite_Price数量类型
---------- ---- ----------- --- ----
001粉$ 10 2.5 P-:在这里像命令一样我要
只有类型如"P％""
/////////////////////////////////////////////////////////////////////////////////

我如何完成此任务，请任何人可以帮助我完成此任务.
我所做的是，我已将所有这些作为带有子报表的单独数据集，并尝试插入到主报表中.但是子报表正在运行，并且生成值主报表不仅在生成标题...，请任何人告诉我该怎么做..

Hi All,

Thanks in advance, I''m having some issues in generating sub report from 2 table. i have ask this question in earlier as well, but i didnt get proper answer. Please any one can explain clearly how to accomplish this task. thanks in advance again.

These are my 2 tables,-Cost, Item
COST ITEM
------------------------------- ---------------------------------------
Product_ID Name Weight Piece Product_ID Item Unite_Price Qty type
---------- ----- ------ ----- ---------- ----- ------------ --- ----
001 Chocolate 15g 120 001 choco $12 1.2 R
002 Bread 20g 80 001 milk $15 1.8 R
001 flour $10 2.5 P
002 flour $10 3.5 P
002 east $20 0.8 R
002 bag $10 2.0 R
with these table I need a report like below,
/////////////////////////////////////////////////////////////////////////////////
Product ID-001 Name - Chocolate Weight - 15g Piece - 120
----------------------------------------------------------

Product_ID Item Unite_Price Qty type
---------- ---- ----------- --- ----
001 choco $12 1.2 R -:here with like command I have take
001 milk $15 1.8 R Only "Type like ''R%'' "

Product_ID Item Unite_Price Qty type
---------- ---- ----------- --- ----
001 flour $10 2.5 P -:here with like command I have take
Only "Type like ''P%'' "
/////////////////////////////////////////////////////////////////////////////////

how can I accomplish this task please any one can help me in this task.
What i did is , I have taken all these as separate dataset with sub reports and try to insert into main report. but subreports are working and generating the values main report is not only generating the headings... please can any one tell me how to do this..

推荐答案

12 1.2 R
002面包20克80001牛奶

12 1.2 R
002 Bread 20g 80 001 milk

15 1.8 R
001面粉

15 1.8 R
001 flour

10 2.5 P
002面粉

10 2.5 P
002 flour

这篇关于需要生成带有2个表的Vrystal报告.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！