在水晶报告中显示两个表格数据 [英] Show two table data in a crystal report

问题描述

我有两张桌子Loan& 会员，会员表包含我想在水晶报告上显示的会员图像以及有关该会员的所有贷款信息。



例如 - < br $>


会员表

I have two table "Loan" & "Member", "Member" table contain image of members which i want to show on crystal report along with all loan information about that member.

For example--

Member table

----------------
RID  MName  DOB       MPhoto
---------------------------
1    Jack   14 march   BLOB

贷款表

Loan Table

------------------
RID    MName   Paydate  Installments   Status
---------------------------------------------
1      Jack    1 jan 15  1500          Paid
1      Jack    1 Feb 15  1500          Not paid
1      Jack    1 Mar 15  1500          Not paid
1      Jack    1 Apr 15  1500          Not paid

我想从会员表中显示Mphoto（会员形象），并将贷款表中的所有信息显示为一个水晶报告。

帮我解决这个问题。谢谢。

I want to show "Mphoto"(Image of member) from "Member" table and All information from loan table into one crystal report.
Help me to solve this give some ideas. thank you.

推荐答案

要从BLOB字段显示图片，请从这里开始：在Crystal Reports中显示数据库中的图像 [ ^ ]



如需使用2个数据源，请查看：如何在c＃中将两个数据表加载到同一个Crystal报表？ - 堆栈溢出 [ ^ ]

请注意，贷款表中的详细信息应显示在子报表中。

For displaying pictures from BLOB field, start here: Show images from a database in Crystal Reports[^]

For using 2 data sources, have a look here: How to load two data table to same Crystal report in c#? - Stack Overflow[^]
Note that details from Loan table should be displayed in subreport.

这篇关于在水晶报告中显示两个表格数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！