Posts

Showing posts from November, 2018
Image
Job TO find Inventory Line amount Frm Financial Start date to ToDay:
Image
Based On FromDate ,ToDate To Show Inventory Report: OutPut: To Show In SSRS Report: Contract Class: 1-1)Class Declaration 1-2) PArmFromDate 1-3)ParmToDate 2 DP Class 2-1) 2-2) 2-3)Process Report method(): Now Create SSRS Report For Design and Mapp the fields and Create Menu Item button for SSRS Report and run menu item
Image
SSRS Report Based On FromDate,Todate,CustGroup,SalesID,CustAccount Data Filter  : outpu 1)Create temp Table with Following Fields 2) create Query    Based on image u shown below(Tables used in this query) 3) Create Data Contract Class     [     DataContractAttribute,     SysOperationContractProcessingAttribute(classStr(DLS1016_SalesInvoiceUIBuilder)) ]  public class DLS1016_SalesInvoicecontractclass {     List                 salesId,custAccount,CustGroup;     TransDate               FromDate,ToDate; ------------- 3-1)parmcustAccountmethod [         DataMemberAttribute("Cust Account"),         AifCollectionTypeAttribute("Cust Account",Types::String),         SysOperationLabelAttribute("Cust Account"),         SysO...
Image
ProjInvoice Report:GST Tax Invoice Report 1) Create Tmp Table with  following Fields: Example  1-2) Create Query  2) write Contract Class  Based on Invoice To genearate Report *** UI Builder Class Post Build () ------------ public void postbuild() { } 3 ) DP Class Note:  In Proces report we write Single Select lookup  so I commented that Line if u use Multi Select use that commented Line 4)Controller Class 4-1) PreRunMOdifyContractClass 4-2)Main MEthod 5) Now Design SSRS Report in VisualStudio and Deploy  6) create Menu Button -output And Run The Report ..........