Page Designer – Tablix Reports with Drill Throughs

The Publisher Page Designer Tablix control allows the creation of matrix or pivot style reports with values going across the columns and down the rows, similar to how Excel Pivot tables work. These reports can be filtered and viewed in the Sharperlight Web Channel as HTML or PDF and automated in Scheduler. The video also shows how to create Drill Through actions on the amounts in the report that open another report to list the transactions behind the amounts clicked on including totals.

Action Jump to URL Basic PDF version

=IIF( Fields!Amount.Value=Nothing
,””
, Parameters.Item(“_ReportUrlRoot”).Value
+ “Report/?query=TrainF8.TablixDrill”
+ “&fltCompany=”   + Parameters.Item(“_FilterCompany”).Value
+ “&fltAccName=”   + Fields!AccName.Value
+ “&fltAccName_2=” + Last(Fields!AccName.Value)
+ “&fltPeriod=”    + Fields!Period.Value
+ “&fltPeriod_2=”  + Last(Fields!Period.Value)
)

Action Jump to URL Basic HTML version with open in new tab logic

=IIF( Fields!Amount.Value=Nothing
,””
, “javascript:void(window.open(‘” + Parameters.Item(“_ReportUrlRoot”).Value
+ “Report/?query=TrainF8.TablixDrill”
+ “&fltCompany=”   + Parameters.Item(“_FilterCompany”).Value
+ “&fltAccName=”   + Fields!AccName.Value
+ “&fltAccName_2=” + Last(Fields!AccName.Value)
+ “&fltPeriod=”    + Fields!Period.Value
+ “&fltPeriod_2=”  + Last(Fields!Period.Value)
+ “‘,’_blank’))”
)

Custom Value to set blank cells correctly in Tablix

=IIF( IsNothing(Sum(Fields!Amount.Value) ), ”  “,Sum(Fields!Amount.Value))

Sample:
TrainF8

Published: 10/11/2017 9:45AM