Posts

Showing posts with the label SSRS Report

Generate and attach a SSRS report as PDF file in document attachment form through X++ code

                   Sometimes we face this requirement to attach a SSRS reports directly on attachment form. Following is the code that helps you to achieve.         str                              fileName;         String10                          Extension;         Args                              _args;         SRSPrintDestinationSettings   printerSettings;         System. Byte []                 reportBytes = new System. Byte [ 0 ]();         SRSProxy                      srsProxy;         SRSReportRunService              srsReportRunService = new SrsReportRunService ();                  Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService. ParameterValue []   parameterValueArray;         Map                           reportParametersMap;          str                           reportnamerun;         SRSReportExecutionInfo        executionInfo = new SRSReportExecutionInfo ();         System.IO. Stream               stream = null ;         _args = new Args ();     

Multi Select Lookup in SSRS Report in D365

Multi Select Lookup in SSRS Report in D365 Description:-  Here we will create multi select lookup in ssrs report so we can select multiple data from lookup. Here I have given sample demonstration for how to generate multi select lookup in ssrs report. First, you must create contract class for that and create method for parameters. Contract Class: - [DataContractAttribute, SysOperationContractProcessingAttribute( classstr (SampleUIBuilder))] class SampleContract implements SysOperationValidatable {     List   ListItemId; [DataMemberAttribute( "Item Id" ),AifCollectionTypeAttribute( "Item Id" , Types ::String),        SysOperationLabelAttribute( literalStr ( "Item Id" ))]        public List parmItemId( List _ListItemId = ListItemId) {               ListItemId = _ListItemId;               return ListItemId; } } //For validation parameters,     public boolean validate()     {         boolean              is

SSRS Report using Controller , Contract and RDP classes in D365

Image
STEP 1 : Create new TEMP table STEP 2 : Create query. STEP 3 : Create a Contract class [DataContractAttribute] class SMJ_PerdiemContract {     PerdiemStatus    perdiemstatus;     [DataMemberAttribute(identifierStr(PerdiemStatus)),         SysOperationLabelAttribute ("Perdiem status"),         SysOperationHelpTextAttribute("Perdiem status"),         SysOperationDisplayOrderAttribute("1")]         public PerdiemStatus parmPerdiemStatus(PerdiemStatus _PerdiemStatus = perdiemstatus)     {         perdiemstatus = _PerdiemStatus;         return perdiemstatus;     } } STEP 4 : Create a DP class: [SRSReportQueryAttribute(queryStr(SMJ_PerdiemReport)), // query  SRSReportParameterAttribute(classStr(SMJ_PerdiemContract))]// contract class     public class SMJ_PerdiemDP extends SRSReportDataProviderBase {     SMJ_PerdiemTableTempDB  perdiemTableTempDB;     PerdiemStatus           perdiemStatus;        PerdiemRequestID        PerdiemRequ