Hi everybody I try to print BAQReport on Customization, Epicor told me Report Complete but nevert print the document
here the Code:
BAQReportImpl SHImpl = Ice.Lib.Framework.WCFServiceSupport.CreateImpl<BAQReportImpl>(session, Epicor.ServiceModel.Channels.ImplBase<Ice.Contracts.BAQReportSvcContract>.UriPath);
BAQReportDataSet dsDynamicReport = new BAQReportDataSet();
dsDynamicReport = SHImpl.GetNewParameters();
dsDynamicReport.Tables["BAQReportParam"].Rows[0].BeginEdit();
dsDynamicReport.Tables["BAQReportParam"].Rows[0]["Summary"] = "False";
dsDynamicReport.Tables["BAQReportParam"].Rows[0]["ReportTitle"] = "Etiquetas_Nafa";
dsDynamicReport.Tables["BAQReportParam"].Rows[0]["BAQID"] ="BAQ_EtiquetaNafa";
dsDynamicReport.Tables["BAQReportParam"].Rows[0]["SortBy"] = "";
dsDynamicReport.Tables["BAQReportParam"].Rows[0]["SortFields"] ="";
dsDynamicReport.Tables["BAQReportParam"].Rows[0]["Filter1"] ="<DynamicReportDataSet xmlns=\"http://www.epicor.com/Ice/300/BO/DynamicReport/DynamicReport\">"+
" <BAQReport>"+
" <Company />"+
" <BAQRptID>Etiquetas_Nafa</BAQRptID>"+
" <Description>Etiquetas para Nafa</Description>"+
" <ReportTitle />"+
" <FormTitle>Etiquetas_Nafa</FormTitle>"+
" <ExportID>BAQ_EtiquetaNafa</ExportID>"+
" <SystemFlag>false</SystemFlag>"+
" <Completed>false</Completed>"+
" <GlobalReport>false</GlobalReport>"+
" <IsCrystalReport>false</IsCrystalReport>"+
" <ReportID>BAQ_EtiquetaNafa</ReportID>"+
" <CrystalReportName/>"+
" <CGCCode />"+
" <SSRSReportName>Etiquetas_Nafa.rdl</SSRSReportName>"+
" <SysRevID>2745616</SysRevID>"+
" <SysRowID>c447ae1d-cef6-483e-a2b4-0f08b3baa8f4</SysRowID>"+
" <TempRowID />"+
" <BitFlag>0</BitFlag>"+
" <RowMod />"+
" </BAQReport>"+
" <BAQRptOptionFld>"+
" <Company />"+
" <BAQRptID>Etiquetas_Nafa</BAQRptID>"+
" <DataTableID>PartLot</DataTableID>"+
" <FieldName>LotNum</FieldName>"+
" <CompOp>=</CompOp>"+
" <Seq>1</Seq>"+
" <DefaultValue/>"+
" <FieldLabel>Lot Number</FieldLabel>"+
" <DisplayName>PartLot_LotNum</DisplayName>"+
" <FieldFormat>x(30)</FieldFormat>"+
" <EpiGuid>9c9ae074-3b26-4139-898c-4eab935507de</EpiGuid>"+
" <IsVisible>true</IsVisible>"+
" <DataType>nvarchar</DataType>"+
" <SystemFlag>false</SystemFlag>"+
" <DispOrder>0</DispOrder>"+
" <SysRevID>2745620</SysRevID>"+
" <SysRowID>ddbed06b-6364-4147-80be-9bf92accde3c</SysRowID>"+
" <FieldValue>"+LotNum.ToString().Trim()+"</FieldValue>"+
" <TempRowID>Field1</TempRowID>"+
" <BitFlag>0</BitFlag>"+
" <RowMod />"+
" </BAQRptOptionFld>"+
" <BAQRptOptionFld>"+
" <Company />"+
" <BAQRptID>Etiquetas_Nafa</BAQRptID>"+
" <DataTableID>PartLot</DataTableID>"+
" <FieldName>PartNum</FieldName>"+
" <CompOp>=</CompOp>"+
" <Seq>2</Seq>"+
" <DefaultValue/>"+
" <FieldLabel>Part</FieldLabel>"+
" <DisplayName>PartLot_PartNum</DisplayName>"+
" <FieldFormat>x(50)</FieldFormat>"+
" <EpiGuid>94bbf616-1958-44e6-bd67-142158e80fa0</EpiGuid>"+
" <IsVisible>true</IsVisible>"+
" <DataType>nvarchar</DataType>"+
" <SystemFlag>false</SystemFlag>"+
" <DispOrder>0</DispOrder>"+
" <SysRevID>2745647</SysRevID>"+
" <SysRowID>5ea74a07-1524-4c2b-bee3-a3d286a997fe</SysRowID>"+
" <FieldValue>"+PartNum.ToString().Trim()+"</FieldValue>"+
" <TempRowID>Field2</TempRowID>"+
" <BitFlag>0</BitFlag>"+
" <RowMod />"+
" </BAQRptOptionFld>"+
" <BAQRptOptionFld>"+
" <Company />"+
" <BAQRptID>Etiquetas_Nafa</BAQRptID>"+
" <DataTableID>LaborDtl</DataTableID>"+
" <FieldName>JobNum</FieldName>"+
" <CompOp>=</CompOp>"+
" <Seq>3</Seq>"+
" <DefaultValue/>"+
" <FieldLabel>Job</FieldLabel>"+
" <DisplayName>LaborDtl_JobNum</DisplayName>"+
" <FieldFormat>x(14)</FieldFormat>"+
" <EpiGuid>d582f1f7-6ff2-4113-b4b6-5e1d6ce98388</EpiGuid>"+
" <IsVisible>true</IsVisible>"+
" <DataType>nvarchar</DataType>"+
" <SystemFlag>false</SystemFlag>"+
" <DispOrder>0</DispOrder>"+
" <SysRevID>25200938</SysRevID>"+
" <SysRowID>9bc648cd-5bf1-41e1-9500-ac1e8c5e7d9d</SysRowID>"+
" <FieldValue>"+JobNum+"</FieldValue>"+
" <TempRowID>Field3</TempRowID>"+
" <BitFlag>0</BitFlag>"+
" <RowMod />"+
" </BAQRptOptionFld>"+
" </DynamicReportDataSet>";
//MessageBox.Show( dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter1”].ToString());
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter2”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter3”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter4”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter5”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter6”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter7”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter8”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter9”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Filter10”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“UserID”] = usuario;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Character01”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Character02”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Character03”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Character04”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Character05”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check01”] =“False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check02”] =“False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check03”] =“False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check04”] =“False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check05”] =“False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Number01”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Number02”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Number03”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Number04”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Number05”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“BAQRptID”] =“Etiquetas_Nafa”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ReportID”] =“Etiquetas_Nafa”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option01”] = LotNum.ToString().Trim();
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option02”] = PartNum.ToString().Trim();
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option03”] = JobNum;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option04”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option05”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option06”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option07”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option08”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option09”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Option10”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check06”] = “False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check07”] = “False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check08”] = “False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check09”] = “False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Check10”] = “False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Date01Token”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Date02Token”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Date03Token”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Date04Token”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“Date05Token”] = “”;
//Aqui
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“SysRowID”] = “00000000-0000-0000-0000-000000000000”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“AutoAction”] = “SSRSPREVIEW”;//“SSRSClientPrint”;//“SSRSPREVIEW”;//PRINT
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“PrinterName”] = “ZDesigner GK420t”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“AgentSchedNum”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“AgentID”] = “SysAgent”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“AgentTaskNum”] = “0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“RecurringTask”] = “False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“RptPageSettings”] = “Color=False,Landscape=False,PaperSize=[Kind=‘Custom’ PaperName=‘Custom’ Height=1100 Width=850],PaperSource=[SourceName=‘Manual feed’ Kind=‘Manual’],PrinterResolution=[Kind=‘Custom’ X=203 Y=203]”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“RptPrinterSettings”] =“PrinterName=‘ZDesigner GK420t’,Copies=1,Collate=False,Duplex=Simplex,FromPage=1,ToPage=0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“RptVersion”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ReportStyleNum”] = “1”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“WorkstationID”] =workStationID;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“TaskNote”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ArchiveCode”] = “0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“DateFormat”] = “dd/mm/yyyy”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“NumericFormat”] =“,.”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“AgentCompareString”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ProcessID”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ProcessCompany”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ProcessSystemCode”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ProcessTaskNum”] = “0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“DecimalsGeneral”] = “0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“DecimalsCost”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“DecimalsPrice”] = “0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“GlbDecimalsGeneral”] = “0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“GlbDecimalsCost”] =“0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“GlbDecimalsPrice”] = “0”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“FaxSubject”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“FaxTo”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“FaxNumber”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“EMailTo”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“EMailCC”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“EMailBCC”] = “”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“EMailBody”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“AttachmentType”] = “PDF”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ReportCurrencyCode”] = “MXN”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“ReportCultureCode”] = “en-MX”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“SSRSRenderFormat”] = “PDF”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“UIXml”] =“”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“PrintReportParameters”] = “False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“SSRSEnableRouting”] =“False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“DesignMode”] =“False”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0][“RowMod”] = “A”;
dsDynamicReport.Tables[“BAQReportParam”].Rows[0].EndEdit();
SHImpl.SubmitToAgent(dsDynamicReport, “SysAgent”, 0, 0, “Ice.UIRpt.BAQReport”);