The following will give you yesterday's date:

In T-SQL

DATEADD(dd,-1,GETDATE())

In VB/SSRS

=DATEADD("d",-1,NOW())

HTH

toolman

singhs2,

Please copy and paste your exact syntax and the error message here. That may give us a clue why something that typically works every time is not working for...

Sorry. Didn't notice at first that you had different fields.

Try

=SUM(IIF(Fields!Status.Value = "C" AND Fields!Race = "W", 1, 0))

I think that should work for you.

Here's a couple good resources for...

Change your AND to OR. That should do it.

Try

=COUNT(IIF(Fields!Status.Value = "C", Fields!Status.Value, Nothing))

Found this on MSDN, maybe will help?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2656661&SiteID=1

I posed your situation to our DBAs. Here's their reponse and a little further explanation.

"OK. He can try the following:

1. Ensure that smtp mail...

Unfortunately that's fairly typical SSRS behavior for longish running reports. What's happening is you're hitting some kind of timeout. When that happens the user's stored credentials go out...

My understanding of the advantages of shared vs. timed is primarily the server resources involved. Here is a comparison of the two prepared by one of our DBAs.

"Shared...

That's apparently the case when running subs as individual jobs (i.e. Timed Subscription) and not on Shared Schedules. At least that's when I get NULL values.

Unfortunately, if you aren't...

This may likely get you more (or less) than you want but it will set you in the right direction with the tables and columns to query. Hope it...

Yes, you'll need to query the tables in the ReportServer database on your report server box.

In particular look to these tables:

catalog - contains data for deployed reports

users...

I think what's happening is your subreport placeholder remains the same width regardless of how your subreport renders. If your place holder is 3 columns wide in the main...

I think what's happening is you don't have your main report and subreport linked properly. You're likely just getting info back from the first record in the subreport dataset.

Does...

When you group on the voucher_ID, you will automatically get a header and footer for the group in addition to the table header and footer.

You'll want your subreport in the...