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

[Ted]

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

 

[John Guin [msft]]

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

 

[Ted]

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