I have some data grouped in a table by a certain criteria, and for each group it is computed an average —well, the real case is a bit more tricky— of the values from each of the detail rows that belong to that group. This average is shown in each group footer rows. Let's see this simple example: What I want now is to show a grand tota...
In Sharepoint2007, I can add a summary row to a Form Library by going to All Documents | Modify this view | Totals I seem to have to choose just ONE of the options (Count, Average, Maximum, Minimum, Sum, Std Deviation, or Variance). Is there a way to add TWO instead of just one (Count and Average)? Thanks for any help. ...
I want to know how much disk space is being used by zip files (or any other extension) in a particular directory tree. Is this possible on the command line (in a batch program)? I can list them, ie: dir /s *.zip or using "forfiles": forfiles /p d:\wincap /s /m *.zip /c "cmd /c echo @fsize" I need it in a batch program, because I wan...
Hi i have a report that gives details about warehouse packages. i was asked to insert shipping address and id number on the top. so as per their requirement it should be on the page header. but as we know we cannot add fields to page header. so what i did was i created a group by ship to name and inserted all the values in it. that was ...
Hi, If my report only generates a handful of rows of data (not pages, just rows) then I would like to have my totals row appear immediately after the last row of data, instead of being forced to the bottom of the page. How do I do that? I have tried a page footer and a column footer and they both appear at the bottom of the page rathe...
I have a query that totals up all cases that were active on 01/01/2010. SELECT COUNT(CaseID) AS Total FROM dbo.ClientCase WHERE (CaseStartDate <= CONVERT(DATETIME, '2010-01-01 00:00:00', 102)) AND (CaseClosedDate >= CONVERT(DATETIME, '2010-01-01 00:00:00', 102)) OR (CaseClosedDate IS NULL) GROUP BY CaseStartDate I also...