Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nugget5

    Conditional average

    Here is an example of the data from my datasource: user year month days netcash amt amt days id wrked wrked wrked var over short inbal ----- ------ ----- ----- ------- ------ -------- ----- Admin 2007 2 4 -506.00 3.00 -509.00 1 Admin 2007 1 2...
  2. nugget5

    Conditional average

    My datasource brings back a row showing a monthly summary for each user for the last 12 months. I am trying to get an average of the Number of Days Worked for the current month. Here is my formula: whileprintingrecords; average({ds.daysworked}, {ds.WorkMonth}, Month (CurrentDate)) I know this...
  3. nugget5

    Getting monthly totals when there is no activity

    Can you elaborate on this? I need rows that will have the userid not null that shows the zero activity. Right now, I get rows with null userid.
  4. nugget5

    Rows for Months with No data

    Yes, that takes care of the rows that have a null userid, but it still does not show rows for each user for each month, whether they had any activity or not.
  5. nugget5

    Getting monthly totals when there is no activity

    I have a view (vMonthlyBalSheet) that totals user activity by month SELECT UserID, DATEPART(yy, ActivityDate) AS ActivityDateYear, DATENAME(m, ActivityDate) AS ActivityDateMonth, COUNT(*) AS DaysWorked, SUM(Offage) AS NetCashVar, SUM(UnitsSold) AS TotalSold FROM vBalanceSheet GROUP BY...
  6. nugget5

    Rows for Months with No data

    Ok, I have added a table that has the dates in it. But now when the tables are joined the userid field is null for months that do not have data, so when the report is grouped by userid it still will not show months for that user that they have not worked.
  7. nugget5

    Rows for Months with No data

    I do not know what the dates to be put in a table. I only want the last 12 months.
  8. nugget5

    Rows for Months with No data

    I am creating a report that shows monthly totals for users. The view that is supplying the data has monthly aggregation done. The problem I am encountering is if a user did not work in a certain month there is not a row for that month. Is there a way I can display a row that would show zero...

Part and Inventory Search

Back
Top