Create functions in the code under the report properties: Page Number: Function PageNumber() As String Return Me.Report.Globals!PageNumber End Function Total Pages: Function TotalPages() As String Return Me.Report.Globals!TotalPages End Function Access it in the body via an expression: =code.PageNumber & ” of ” & code.TotalPages Check out Sample Usage of the Concat Function
You don’t need Linq, but you do still need custom code (in BIDS go to Report -> Report Properties -> Code) You can put a RemoveDuplicates function in here, something like this: Public Shared Function RemoveDuplicates(m_Array As Object()) As String() System.Array.Sort(m_Array) Dim k As Integer = 0 For i As Integer = 0 To m_Array.Length … Read more
You would need to restrict your dataset to the desired month and then sum the results. LookupSet is used to retrieve data from another dataset based on criteria. A VBA function, SumLookup is needed to add the results from the LookUp. This VB would go into the CODE section of the report (this can be … Read more
In BIDS or SSDT-BI, do the following: Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT-BI) Make a note of the values for Page width, Left margin, Right margin Close and go back to the design surface In the Properties window, select Body Click the + symbol to expand the … Read more