BAQ Report Designer Called into Kinetic Epicor on click pass parameter

Kinetic ERP
, , , , ,
1

BAQ Report Designer
Call on click inside Application studio

BAQ Report Designer

image
image605×373 24 KB

Add button

image
image1339×570 44.5 KB

calling functions
Required Fields
api key
library
function name

image
image1488×690 38.1 KB

passing parameters

image
image1501×507 37.2 KB

function name and references

image
image623×182 6.18 KB

parameters

image
image368×424 4.27 KB

this.CallService<Ice.Contracts.SysAgentSvcContract> (vh_SysAgent =>
{  
        
    this.CallService<Ice.Contracts.BAQReportSvcContract> (vh_BAQReport =>
    {
      var agentID = "";
      vh_SysAgent.GetDefaultTaskAgentID(out agentID);
      
      var filter1 = $@"<DynamicReportDataSet xmlns=""http://www.epicor.com/Ice/300/BO/DynamicReport/DynamicReport"">
 <BAQReport>
	<Company>159599</Company>
	<BAQRptID>RPTMiscShipment</BAQRptID>
	<Description>Miscellaneous Shipment With Shipping Qty</Description>
	<ReportTitle/>
	<FormTitle>Miscellaneous Shipmen</FormTitle>
	<ExportID>RPT-BAQ-MisShipment</ExportID>
	<SystemFlag>false</SystemFlag>
	<Completed>false</Completed>
	<GlobalReport>false</GlobalReport>
	<IsCrystalReport>false</IsCrystalReport>
	<ReportID>RPTMiscShipment</ReportID>
	<CrystalReportName/>
	<CGCCode/>
	<SSRSReportName>RPTMiscShipment.rdl</SSRSReportName>
	<SysRevID>301667237</SysRevID>
	<SysRowID>50ebc74c-5bcf-4ad2-9e18-bc3b46a6fd45</SysRowID>
	<TempRowID/>
	<BitFlag>0</BitFlag>
	<RowMod/>
</BAQReport>
<BAQRptOptionFld>
	<Company>159599</Company>
	<BAQRptID>RPTMiscShipment</BAQRptID>
	<DataTableID>MscShpDt</DataTableID>
	<FieldName>JobNum</FieldName>
	<CompOp>=</CompOp>
	<Seq>1</Seq>
	<DefaultValue/>
	<FieldLabel>Job Number</FieldLabel>
	<DisplayName>MscShpDt_JobNum</DisplayName>
	<FieldFormat>x(14)</FieldFormat>
	<EpiGuid>f9deefd0-7823-4bb4-8b48-cc519ad2f85b</EpiGuid>
	<IsVisible>true</IsVisible>
	<DataType>nvarchar</DataType>
	<SystemFlag>false</SystemFlag>
	<DispOrder>0</DispOrder>
	<SysRevID>473923811</SysRevID>
	<SysRowID>1894f29d-f967-47df-9a28-fb3d76031858</SysRowID>
	<FieldValue>{jobNum}</FieldValue>
	<TempRowID>Field1</TempRowID>
	<BitFlag>0</BitFlag>
	<RowMod/>
</BAQRptOptionFld>
<BAQRptFilter>
	<Company>159599</Company>
	<BAQRptID>RPTMiscShipment</BAQRptID>
	<DataTableID>MscShpDt</DataTableID>
	<FieldName>JobNum</FieldName>
	<AdapterName>JobEntryAdapter</AdapterName>
	<Seq>1</Seq>
	<LookupField>JobNum</LookupField>
	<FilterLabel>Job Number</FilterLabel>
	<TabLabel>Job Number</TabLabel>
	<DisplayName>MscShpDt_JobNum</DisplayName>
	<EpiGuid>edfa0427-3f99-4cbb-9d63-129e52f825a1</EpiGuid>
	<IsVisible>true</IsVisible>
	<FilterField>JobNum</FilterField>
	<SystemFlag>false</SystemFlag>
	<DispOrder>0</DispOrder>
	<DataType>nvarchar</DataType>
	<SysRevID>473923819</SysRevID>
	<SysRowID>0be3bb13-797c-47a1-aa3f-ded5756a818a</SysRowID>
	<TempRowID>FilterList1</TempRowID>
	<FilterValue/>
	<BitFlag>0</BitFlag>
	<RowMod/>
</BAQRptFilter>
</DynamicReportDataSet>";

      

  
      var workBAQReportParam = vh_BAQReport.GetNewParameters();
      workBAQReportParam.BAQReportParam[0].BAQID = "RPT-BAQ-MisShipment";
      workBAQReportParam.BAQReportParam[0].ReportID = "RPTMiscShipment";
      workBAQReportParam.BAQReportParam[0].BAQRptID = "RPTMiscShipment";
      workBAQReportParam.BAQReportParam[0].ReportTitle = "Miscellaneous Shipmen";
      workBAQReportParam.BAQReportParam[0].Filter1 = filter1;
      workBAQReportParam.BAQReportParam[0].Option01 = jobNum;      
      workBAQReportParam.BAQReportParam[0].AutoAction = "SSRSPREVIEW";
      workBAQReportParam.BAQReportParam[0].TaskNote = "";
      workBAQReportParam.BAQReportParam[0].UserID = Session.UserID;
      workBAQReportParam.BAQReportParam[0].PrinterName = "";
      workBAQReportParam.BAQReportParam[0].AgentSchedNum = 0;                                                            
      workBAQReportParam.BAQReportParam[0].AgentID = agentID;     
      workBAQReportParam.BAQReportParam[0].AgentTaskNum = 0;
      workBAQReportParam.BAQReportParam[0].RecurringTask = false;          
      workBAQReportParam.BAQReportParam[0].ProcessTaskNum = 0;                                                            
      workBAQReportParam.BAQReportParam[0].ReportStyleNum = 1;
      workBAQReportParam.BAQReportParam[0].WorkstationID = Session.TaskClientID;
      workBAQReportParam.BAQReportParam[0].DateFormat = "m/d/yyyy";
      workBAQReportParam.BAQReportParam[0].NumericFormat = ",.";
      workBAQReportParam.BAQReportParam[0].SSRSRenderFormat = "";
      workBAQReportParam.BAQReportParam[0].RowMod = "A";
      
      
      vh_BAQReport.SubmitToAgent(workBAQReportParam, agentID, 0, 0, "Ice.UIRpt.BAQReport;RPTMiscShipment");
    });
   
   resultMessage="Response="+jobNum;
});
2

Let’s a take a step back!

#1 What is your end goal? Obviously, printing a BAQ Report
#2 Why aren’t you using the auto-print feature?
#3 What version are you on? A short summary of your issue / end goal.

3

It prints the BAQ Designer custom report when the button is clicked, using specific parameters, and the above code is working perfectly.