SSRS doesn't play nice with numbers when filtering.

Try these:

convert your numeric expression to string

Expression______________________________________________Operator__Value

=CStr(DateDiff(DateInterval.Day, Fields!DateAdded.Value, Today)) <= 7

OR

Turn...

Here's info about SSRS' numbering formats along with links to MSDN's VB formatting info.

Using 123456789 as an example:

Currency - C or c = $123,456,789.00; Using precision specifier, C0 =...

Sounds like you've ended up with the FIRST aggregate attached to your field.

Change FIRST(Fields!student.Value) to just Fields!student.Value.

That should do it.

HTH

Sounds to me like you're not configured for email delivery. Check with your DBAs (or check yourself) to make sure your SSRS configuration includes the email option and that...

My guess is those single word queries are actually stored proc names. In order to track back to the actual tables, you'll need to look at these procs and...

brunm (7/24/2008)

---

i have a report which i need to repeat the data (anywhere on the report) if it spills over 1 page.

My report conatins a list (i must use a...

=sum(iif(condition field = "salary",value field,0))

Just so you know why the IIF doesn't work: IIF is a function. SSRS reads the entire statement kind of from the inside out. It sees the...

Excellent!! The fewer subreports the better I always say.;)

is250sp (7/14/2008)

---

Both subreports get parameters from the parent report. The 2nd sub receives 4 parameters and yes, when i run it independently, i am passing the exact values from...

Just throwing some thoughts out for you to look at.

What links the reports? Particularly the 2nd sub to the first and the parent report.

When you're running the problematic 2nd...

What's the exception message?

When I inserted that expression into one of my reports (substituting my report's fields of course), it ran without incident.

Leads me to believe it's a...

Chances are the dimensions of your report are exceeding the size of your page.

Make sure the width and or height of all your report parts plus margins is less than...

Couple things:

Is your usetime field a datetime field? If so, the values are going to include time along with date so using = without modifying both GETDATE() and usetime...

I answered this last Friday (Post #525356) when you posted it under "Date Parameter (Post #525310)."

Here it is again:

The following will give you yesterday's date:

In T-SQL

DATEADD(dd,-1,GETDATE())

In VB/SSRS

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