以SQL Server為例 select a.*, 欄位1改= CASE WHEN (a.欄位1 = 1) then 'ABC' WHEN (a.欄位1 = 2...
以SQL Server為例 select a.*, 欄位1改= CASE WHEN (a.欄位1 = 1) then 'ABC' WHEN (a.欄位1 = 2...
使用Crystal Report建立報表,並將資料來源Sqldatasource指定給report,再用Crystal Report viewer來載入原設計好...