Crystal Report 사용법

Transcript Crystal Report 사용법

Crystal Report Designer Tool 설치 (공유 폴더\개발도구\Crystal Report 2011)
Crystal Report AddIn 설치(공유 폴더\개발도구\SAP Crystal Report for VS2010)
- 1번 설치 후 2번은 자신 pc의 비트에 맞는 것을 선택 설치.
D:\ATMS\WebService\crystalreportviewers13 폴더 삭제
D:\ATMS\crystalreportviewers13 경로 Last Version Update
D:\ATMS\WebService\Report 경로 Last Version Update
D:\ATMS\crystalreportviewers13 경로를 아래의 화면과 같이
IIS 에서 가상 디렉토리 설정 ( 반드시 이름을 crystalreportviewers13 으로 할 것 )
Crystalreportviewer13 폴더
선택 후
사용권한 편집 클릭
추가
- Sample Code
var
var
var
var
SUM_DETAIL_TYPE = InputForm.getCheckedValue("FOLIO");
STATUS = InputForm.getItemValue("PRINT");
GUEST = InputForm.getItemValue("GUEST");
statementid = "";
// Summary
if(SUM_DETAIL_TYPE == "T"){
- Statementid : iBatis XML id
- RptNam : CrystalReport 파일명(확장자 제외)
- P_ROOMNO, p_FOLIONO : CrystalReport 매개변수(동일
하게 설정한다. 반드시 p_ 로 시작할것.)
if(FIT_GROUP_TYPE == "F"){
statementid = "FR_RM_FD_A0216_SUM_FIT_Report";
}else{
statementid = "FR_RM_FD_A0216_SUM_GROUP_Report";
}
}else{
// Detail
if(FIT_GROUP_TYPE == "F"){
statementid = "FR_RM_FD_A0216_DET_FIT_Report";
}else{
statementid = "FR_RM_FD_A0216_DET_GRP_Report";
}
}
var val_url = "/Report/ReportViewer.aspx?statementid=" + statementid + "&RptName=FR_RM_FD_A0216"
+ "&REV_SEQ=" + encodeURI(REV_SEQ)
+ "&FOLIOSTATUS=" + encodeURI("Y")
+ "&SUM_DETAIL_TYPE=" + encodeURI(SUM_DETAIL_TYPE)
+ "&STATUS=" + encodeURI(STATUS)
+ "&GUEST=" + encodeURI(GUEST)
+ "&FOLIOTYPE=1"
+ "&FIT_GROUP_TYPE=" + encodeURI(FIT_GROUP_TYPE)
+ "&p_ROOMNO=" + encodeURI(REV_SEQ)
+ "&p_FOLIONO=" + encodeURI(FOLIOTYPE);
window.open(val_url, '_target', stat);
Web.Config 수정
<?xml version="1.0"?>
<configuration>
<configSections>
<sectionGroup name="businessObjects">
<sectionGroup name="crystalReports">
<section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared
, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null"/>
<section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler"/>
<section name="printControl" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.3300.0
, Culture=neutral, PublicKeyToken=b77a5c561934e089, Custom=null"/>
</sectionGroup>
</sectionGroup>
</configSections>
<connectionStrings>
<assemblies>
<add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="System.Data.Entity.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<add assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>

<add assembly="CrystalDecisions.ReportSource, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.ReportAppServer.Controllers, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.ReportAppServer.DataDefModel, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.ReportSource, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
<add assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
</assemblies>
</compilation>
<httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web
, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></httpHandlers>
</system.web>
<location allowOverride="true">
<appSettings>
<add key="CrystalImageCleaner-AutoStart" value="true"/>
<add key="CrystalImageCleaner-Sleep" value="60000"/>
<add key="CrystalImageCleaner-Age" value="120000"/>
</appSettings>
</location>
<businessObjects>
<crystalReports>
<rptBuildProvider>
<add embedRptInResource="true"/>
</rptBuildProvider>
<crystalReportViewer>
<add key="ResourceUri" value="/crystalreportviewers13"/>
</crystalReportViewer>
<printControl>
<add key="url" value="/crystalreportviewers13/ActiveXControls/PrintControl.cab"/>
</printControl>
</crystalReports>
</businessObjects>
<system.webServer>
<handlers>
<add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web
, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode"/>
</handlers>
<validation validateIntegratedModeConfiguration="false"/>
</system.webServer>
</configuration>
Crystal Report Design

Crystal Report 사용법

Transcript Crystal Report 사용법

Directory