D365_VisualStudio | SSRS(2) - Multi Select Report

Report 틀 생성

1. Contract
2. Temp Table
3. Data Provider
4. Report
5. Controller
6. Output Menu Item
7. Form Extension
8. Security Privilege

※ Deploy Report 필수!!

 

VS Solution : EDU_0324
PATH : Sales and marketing > Inquiries and reports > Sales Order > All Sales Order

(판매 및 마케팅 > 판매주문 > 모든 판매주문)

 

1. Contract 클래스 생성 - EDU_SSRSReportContract

[DataContractAttribute]

 

2. Temp Table -  EDU_SalesReportTmp

 

3. Data Provider - EDU_SalesReportDP

• 조회할 데이터 Temp Table에 저장

 

4. Report - EDU_SalesReport

• Dataset – Data Source Type ‘Report Data Provider’, Query 클릭
• Design – New > Precision Design

 

 

**Multi Select**

Body > rectangle > table > text Box에 반복되는 테이블 형성의 기준이 되는 키 값을 Hedden컬럼으로 설정 ▼

• [Row Groups] Details 클릭 > Add Group > Parent Group > Group by ‘SalesId’ 
• Group Properties – Group on ‘SalesId’, Page break option ‘Between each instance of a group’ 
• 행 추가하여 하단의 정보 출력

 

5. Controller - EDU_SalesReportController

 

6. Output Menu Item - EDU_SalesReport

Label, Multi Select ‘Yes’, Object, Object Type ' Controller'

 

7. Form Extension - SalesTableListPage.EDU_Extension

 

8. Security Privilege

Add > New Item > SecurityPrivilege, Read Permission : EDU_SalesReport_View

• View : Read 조회
• Maintain : Delete 모든 권한

Entry Points에 'Display Menu Item' Drag&Drop, Access Level ‘Read’

 

Result