2,743
edits
Report Script: Get Field that is not in Report v2: Difference between revisions
Report Script: Get Field that is not in Report v2 (view source)
Revision as of 03:31, 20 February 2019
, 5 years ago→Get project no. from Detail, and show the Project Description as a string with 'comma' separated
(→Get project no. from Detail, and show the Project Description as a string with 'comma' separated) |
|||
| (One intermediate revision by the same user not shown) | |||
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.
}}
| |||