从报表中的两个表查询 [英] Query from two tables in report
本文介绍了从报表中的两个表查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的VB应用程序通过ODBC打印报告.我使用数据库专家添加了表,并设计了Crystal Report.我在哪里查询? 这是我的查询
My VB application prints a report via ODBC. I added the tables using database expert and designed the Crystal Report. Where do I put my query? here is my query
SELECT ts.`SCHEDIDNO`,
ts.`DAYNAME`,
DATE_FORMAT(ts.`TIMESTART`, '%h:%i %p') as TIMESTART,
DATE_FORMAT(ts.`TIMEEND`, '%h:%i %p') as TIMEEND,
ts.`GRADELEVEL`,
ts.`SECTIONNAME`,
ts.`SUBJECTNAME`,
ts.`FACFULLNAME`,
ts.`ROOMNAME`,
tf.`FACFULLNAME` as PERSONNEL,
tf.`DEPARTMENT`,
tse.`Adviser`
FROM `tblschedule` ts,
`tblfaculty` tf,
`tblsection` tse
WHERE ts.`GRADELEVEL` = " & lblgrade.Text & "
AND ts.`SECTIONNAME` = '" & lblsect.Text & "'
AND ts.`DEPARTMENTNAME` = tf.`DEPARTMENT`
AND tf.`ADMINISTRATOR` = 1
AND tse.`SECTIONNAME` = '" & lblsect.Text & "'
推荐答案
在Crystal报表向导中,找到使用用户名和密码创建的odbc.
In Crystal report wizard, locate your odbc created with username and password.
然后您将看到一个Command文本,您可以在其中放置查询.
Then you will see a Command text, You can put your Query in there.
此VB.NET代码
Private CRPT As New ReportDocument
Private APPPATH As String
Private PARAM As New ParameterFields
Public PARAM_DESC As New ParameterDiscreteValue
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
APPPATH = Application.StartupPath & "\REPORT\sample.rpt"
CRPT.Load(APPPATH)
Me.CrystalReportViewer1.ReportSource = CRPT
PARAM = CRPT.ParameterFields
PARAM_DESC.Value = Format(DatePicker1.Value, "yyyyMMdd")
PARAM("DATEP").CurrentValues.Clear()
PARAM("DATEP").CurrentValues.Add(PARAM_DESC)
Me.CrystalReportViewer1.Refresh()
End Sub
此代码适用于C#:
CRPT = new ReportDocument();
APPPATH = Environment.CurrentDirectory + "Sample.rpt";
CRPT.Load(APPPATH);
Report_Viewer.Refresh();
CRPT.SetParameterValue("syear", Servercls.year);
CRPT.SetParameterValue("smonth", Servercls.month);
CRPT.SetParameterValue("sday", Servercls.day);
CRPT.SetParameterValue("datevalue", Servercls.Datevalue);
Report_Viewer.ReportSource = CRPT;
sc.configureCrystalReport();
Report_Viewer.Refresh();
您的Crystal Report参数名称必须与您的隐藏代码"中的名称相同.
Your crystal report parameter name must be the same with in your Code Behind.
这篇关于从报表中的两个表查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文