Search results for query: *

I came across a posting that indicated that RDL evaluates a group header and footer at the same time as the detail section. This appears to explains the issues I was encountering. If I include another group for forecastdt (date field), set the variable there and reference it in the previous...

Thanks for helping out. The data is grouped by Category Name (categorynm), then by Driver Name (drivernm). For example: categorynm, drivernm Customers, Express Customers, Regular Customers, Service Center Sales, Express Sales, Regular Sales, Service Center There is a single value for each...

Apparently I'm missing something. I had to revert to the original approach. I set the variable in the detail section via the day of the week. =IIf(Weekday(Fields!forecastdt.Value) =2 AND Fields!forecastamt.Value > 0 AND Fields!categorynm.Value = "Sales" AND Fields!drivernm.Value = "Express"...

That worked perfectly, thank you. I need to do this for every day of the week and 3 different buckets, so a total of 21 variables. I list 2 of 7 from each bucket below. Is there a more efficient way to handle this, i.e. an array? Public Dim varSalesExpD1 As Decimal Public Dim varSalesExpD2 As...

I'm trying to understand how to store a value in a variable in a RDL report. I'm using Microsoft Visual Studio 2005 Tools for Applications. In the Report Properties >> Code section, I've added: Public Dim varSales As Decimal I suspect there is a way to assign a value to this value in an...