Ask Ben First

I've just replaced the front parking bulb (5W 12V T10) of my Honda Jazz 2009. If you want to save a trip to a workshop by doing it yourself, please watch my youtube channel https://youtu.be/g1XZPGlnckU Please like and subscribe if you want more video like this in the future. Thanks.

Problem After paginating the SSRS report on the previous article , I encountered another problem displaying Tablix header on multiple pages. Solution Ensure View | Properties is checked Click on the following  triangle icon  to select  Advanced Mode Click on the first static on the Row Groups and set the Tablix Member | Other | KeepWithGroup:After and RepeatOnNewPage:True Explanation The selected (static) row to repeat on the new page was actually the header of the table (Tablix). You can visually identify the highlighted-part of Tablix as you click on the (static) row on the Row Groups. If you want the header to display on browser when scrolling down, ensure Tablix Member | Other | FixedData: True

Problem I've encountered slow performance issue on SSRS report rendering on Internet Explorer. It took 15 minutes to render a report on IE. Solution Right-click on the first row of Row Groups and select Add Group | Parent Group... Click fx button when prompted When prompted Set expression for: GroupExpression, type the following formula: =Ceiling(RowNumber(Nothing)/100)  then click OK | OK. Ensure Page Breaks | Between each instance of a group is checked Remember to delete the Sorting fx that was automatically populated otherwise you may encounter error when saving the changes: Right-click on the newly created group ( Group1 ) and select Delete Columns  | Delete group only then click OK . Explanation You can adjust the number of row per page (i.e. changing 100 on the formula to any number) to suit your needs however this pagination will affect interactive and non-interactive rendering. Also if you need to paginate the subsequent row (second, third, etc.) ...