Report Formulas in Reports

Now add Datasource then prepare Dataset for the selected Report.

this report has Year repeated so need to group them. as well this demo need write expressions.

now every

="$ " & Fields!TotalSales.Value  : &  [OR] +  for customizing the report.

using ToolBox---> Drag & Drop the image control to report header(Embeded--Filesystem path).


Report exeution time in Footer of the page

Add a TextBox--> Expression---BuiltinFunctions--ExecutionTime. (click--generates expression)

="Report Execution on " & Globals!ExecutionTime

Right side TextBox ---Expression-BuiltinFunctions

="Page " & Globals!PageNumber & "of " & Globals!TotalPages

now new drilldown approach using Grouping a

column (Calendaryear ) added to group them to report automatically.

 Information is Grouped by Yearwise.

BI ifself identifies the this TotalSales inside a group(CalenderYear)..so excepting a total/same in this footer.

as per above it will add a new Column at right(Calendar Quarter) side as well one footer also.

Year wise(sumtotal) --QuarterWise(sumtotal)--Grouping BusinessType.