2,743
edits
(→Get project no. from Detail, and show the Project Description as a string with 'comma' separated) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 87:
While, Calculated Field is able to temporary store the value.
*Calculated Field is especially useful when the report needs to calculate the total of result(s).
*:
*Furthermore, designer does not have to worry about the replacement to the control,
*:as the replacement of a label to another control will require only rebinding of data.
Line 118:
if (!string.IsNullOrEmpty(projNoSqlList))
{
//SQL Query that find Description of project that
DataTable tbl = __report.DBSetting.GetDataTable(
string.Format("SELECT [Description] FROM Project WHERE ProjNo in ({0}) ORDER BY Description"
Line 140:
Example of Multiple values in SQL statement:
SELECT [Description] FROM Project WHERE ProjNo in (''''ProjA', 'ProjB'''')
{{Note|The code in BuildSqlProjectRangeIn has not been optimized for performance.<br/>Not suitable for customer whom have more than
Suggest adding filter to empty ProjNo and distinct the ProjNo before process in the loop.
}}
|