It seems as though you don't have Database mail set up correctly.

The error message points to an invalid email address and or username / password for the email...

Could you post how you unistalled / reinstalled RS? One of my "great" coworkers has jacked up my RS installation while I was on vacation and I can't uninstall,...

You might also make sure that you are using UNC paths and not mapped drives. I had the same problem when I was using a mapped drive for a...

Thanks for the information Mike, I really appreciate it. I was finally able to make the report do what I wanted. I had to set up two data...

Query

Select customer.custnum,

customer_order.order_id,

customer_order.order_date,

customer_order_item.item,

customer_order_item.quanto,

(customer_order_item.quanto * customer_order_item.it_unlist) as order_total

From customer

Join customer_order

On customer.custnum = customer_order.custnum

Join customer_order_item

On customer_order.order_id = customer_order_item.order_id

Where

customer.custnum in (SELECT customer_number FROM mailing_nar05_list_a)

AND customer_order.order_date >= @startdate

AND customer_order.order_date '0'

AND customer_order.order_status 'CN'

AND...

the errors tell me that I have to define the "variable", only problem is, I can define the variable and it still asks me to define the variable. I...

There is a SQL Server 2005 Reporting Services for dummies book that seems pretty good. Especially if you are just getting started. You can buy it from a...

Thanks for the link. It should help me get started. However, I don't understand how a company can "roll out" a new product without guides on how to...

Is there a "real" best practices guide for SQl Server 2005? If so, google can't find it. Does a best practices guide really exist? This...