1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Would like to be able to do some reporting from OneNote.

Discussion in 'Microsoft OneNote' started by Ted, Jan 20, 2010.

  1. Ted

    Ted Flightless Bird

    Would like to be able to have a way to have the total numbers of the rows in
    a table be calculated and shown on a page by page basis.

    I am working on the testing and development of software and have been using
    OneNote within my group to track outstanding issues and progress. I
    appreciate the ability to include screen shots of the issues noted (on a
    screen or within a spreadsheet or a word document or a PDF document) and also
    include written test eaxplaining the issue for others to look at / fix.

    The problem is that I have not found a way to count of the number of rows
    within a table on a page. (I presently have over 500 rows of issues at
    stages of completion listed on 26 pages (catagories)).

    If one could also sort the rows using a Tag , and have subtotals of the row
    counts on a Tag by Tag basis, as well as the total number of rows - then the
    OneNote product would be much more user friendly. As it is now any sort of
    numerical tracking / analysis of the contents of a table on a OneNote page is
    a manual process. Not fun!

    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/com...b444-bbb769fe4d2d&dg=microsoft.public.onenote
     
  2. John Guin [msft]

    John Guin [msft] Flightless Bird

    You could easily alter the table sums powertoy to do this (it already has a
    count of table rows needed to iterate through a table). It's at
    http://blogs.msdn.com/johnguin/archive/2007/12/10/table-sum-powertoy-for-onenote.aspx
    Let me know if you tweak it!

    --
    Thanks,
    John Guin
    OneNote Test Team
    http://blogs.msdn.com/johnguin


    "Ted" wrote:

    > Would like to be able to have a way to have the total numbers of the rows in
    > a table be calculated and shown on a page by page basis.
    >
    > I am working on the testing and development of software and have been using
    > OneNote within my group to track outstanding issues and progress. I
    > appreciate the ability to include screen shots of the issues noted (on a
    > screen or within a spreadsheet or a word document or a PDF document) and also
    > include written test eaxplaining the issue for others to look at / fix.
    >
    > The problem is that I have not found a way to count of the number of rows
    > within a table on a page. (I presently have over 500 rows of issues at
    > stages of completion listed on 26 pages (catagories)).
    >
    > If one could also sort the rows using a Tag , and have subtotals of the row
    > counts on a Tag by Tag basis, as well as the total number of rows - then the
    > OneNote product would be much more user friendly. As it is now any sort of
    > numerical tracking / analysis of the contents of a table on a OneNote page is
    > a manual process. Not fun!
    >
    > ----------------
    > This post is a suggestion for Microsoft, and Microsoft responds to the
    > suggestions with the most votes. To vote for this suggestion, click the "I
    > Agree" button in the message pane. If you do not see the button, follow this
    > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > click "I Agree" in the message pane.
    >
    > http://www.microsoft.com/office/com...b444-bbb769fe4d2d&dg=microsoft.public.onenote
     
  3. Ted

    Ted Flightless Bird

    The type of sums I am trying to do are not numerically based. I want to be
    able to count and sum the number of rows (or columns). (Just rows would do
    for now).

    Could the counting be done by the use of tags?

    I would first want to sort the tags then if you could get subtotals by tag
    and grand total of all tags that would be fantastic. I have been using tags
    to rank the priority of work to be done.

    "John Guin [msft]" wrote:

    > You could easily alter the table sums powertoy to do this (it already has a
    > count of table rows needed to iterate through a table). It's at
    > http://blogs.msdn.com/johnguin/archive/2007/12/10/table-sum-powertoy-for-onenote.aspx
    > Let me know if you tweak it!
    >
    > --
    > Thanks,
    > John Guin
    > OneNote Test Team
    > http://blogs.msdn.com/johnguin
    >
    >
    > "Ted" wrote:
    >
    > > Would like to be able to have a way to have the total numbers of the rows in
    > > a table be calculated and shown on a page by page basis.
    > >
    > > I am working on the testing and development of software and have been using
    > > OneNote within my group to track outstanding issues and progress. I
    > > appreciate the ability to include screen shots of the issues noted (on a
    > > screen or within a spreadsheet or a word document or a PDF document) and also
    > > include written test eaxplaining the issue for others to look at / fix.
    > >
    > > The problem is that I have not found a way to count of the number of rows
    > > within a table on a page. (I presently have over 500 rows of issues at
    > > stages of completion listed on 26 pages (catagories)).
    > >
    > > If one could also sort the rows using a Tag , and have subtotals of the row
    > > counts on a Tag by Tag basis, as well as the total number of rows - then the
    > > OneNote product would be much more user friendly. As it is now any sort of
    > > numerical tracking / analysis of the contents of a table on a OneNote page is
    > > a manual process. Not fun!
    > >
    > > ----------------
    > > This post is a suggestion for Microsoft, and Microsoft responds to the
    > > suggestions with the most votes. To vote for this suggestion, click the "I
    > > Agree" button in the message pane. If you do not see the button, follow this
    > > link to open the suggestion in the Microsoft Web-based Newsreader and then
    > > click "I Agree" in the message pane.
    > >
    > > http://www.microsoft.com/office/com...b444-bbb769fe4d2d&dg=microsoft.public.onenote
     

Share This Page