Reset page numbers for each group in a report

-
Sometime you would need to reset page numbering on your Ms Reporting on each group. To do so it's needed to add a few line of code in the sub as sample below:



Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
'Set page number to 1 when a new group starts.
    Page = 1
End Sub
And then Set the ForceNewPage property of the Country Footer section to After Section. To do this, follow these steps:
  1. In Design view, right-click  The Group Footer, and then click Properties.
  2. In the Section: GroupFooter1 dialog box, click the Format tab.
  3. In the Force New Page box, click After Section, and then close the Section: GroupFooter1 dialog box.

See Original post at 841779  Or 209215

Comments

Post a Comment

Popular posts from this blog

How to prevent a user from running Task Scheduler in Windows

-
Prevent users from adding new tasks or deleting tasks in Task Scheduler by modifying local policy settings Note   The following procedure only applies to Windows XP Professional, Windows Server 2000, or Windows Server 2003. To do this in Windows XP Home edition, see the "Prevent users from adding new tasks or deleting tasks in Task Scheduler by modifying registry settings" section of this article. Log on as Administrator to the computer where you want to modify the Local Policy settings. Click  Start , and then click  Run . In the  Open  box, type  gpedit.msc  , and then click  OK . In the left pane of the console, expand the  Computer configuration  node. Expand  Administrative Templates , and then expand  Windows Components . Click  Task Scheduler . In the Task Scheduler pane, do the following: Double-click  Prevent Task Run or End . Click  Enabled , and then click  OK . Double-click  P...
Read more

Reading excel file in asp.net

-
The followiing are that code that I have used to read excel file: DataSet myDataset = new DataSet(); if (!FullFileName.Equals("")){ OleDbConnection conn = new OleDbConnection(); OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter da = new OleDbDataAdapter(); string query = null; string connString = ""; string strFileType = System.IO.Path.GetExtension(FullFileName).ToString().ToLower(); if (strFileType.Trim() == ".xls"){ connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FullFileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (strFileType.Trim() == ".xlsx"){ connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FullFileName + ...
Read more