Search results for query: *

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...

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...

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.

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.

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...

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.

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

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...