📄 10503.html
字号:
<html>
<head>
<title>原来如此!</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>原来如此!</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:subird@ms20.url.com.tw">SuBird</a> on March 02, 1999 at 11:27:00:<p>
In Reply to: <a href="10499.html">Re: 用SelectionFormula</a> posted by Fred Tsai on March 02, 1999 at 10:59:47:<p>
: <br>: : 你的月份为何要输入文字???<br>: : 可否将SelectionFormula该行秀一下，或请检查你的Field Type.<br>: 还请你帮忙一下<br>: Dim Name As String<br>: Dim ID As String<br>: Name=Combo1.Text<br>: ID=Combo2.Text<br>: CrystalReport1.selectionFormula= " {Activity Hours.Name} = " & Name & " "<br>: CrystalReport1.selectionFormula= " {Activity Hours.ID} = " & ID & " "<br>: 这样的写法第二个可以执行第一个确没有办法????<p>Re:<br>SelectionFormula犹如SQL的Where子句，当你连续写两行SQL命令时，它会去执行哪一行呢？当然是最后面那一行的结果！<br>所以 CrystalReport1.SelectionFormula= " {Activity Hours.Name} = '" & Combo1.Text <br>& "' And {Activity Hours.ID} = '" & Combo2.Text <br>& "'"<br>应该可以解决！Try it!<br>Note：<br>1. Activity Hours.Name 与 Activity Hours.ID 两个栏位必须在 Report Field 已有选取，Select才不会错。<br>2. 既然是文字资料前后应加'引号。<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 10503-->
</ul><!--end: 10503-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -