=SUM(IIF(Fields!tickets.value = "P" or Fields!tickets.value = "C" and Fields!ticket_date.Value = today()-1, 1, 0))

today()-1 is today date - 1, 1 is the condition for the iffstatatemet, and 0 is when...

that is broad question indeed. Here is what I do. I create a report with a shared data source. One DS for testing and one for live. Then you can...

You just need to create project and drag your rdl file to it in VB .net then all your stuff should be there. Go to the following blog for some...

Would it not be easier to add a count* to your query? select employe, count(*) as emp_total from emp_table left join location table group by employee? I am writing an...