you've got the meat of it there... instead of doing the filtering in your avg() function, do it in the WHERE clause:

AVG(CONVERT(decimal(18,2), substring(hd1.workitem_comment, 115, 1))) AS 'Handled'

...

WHERE substring(hd1.workitem_comment, 115,...

did the modified query not return the data you're looking for? by using max(orderdate) and GROUPing BY the fields in your SELECT clause, you should get one row per unique...

is this what you're asking for?

SELECT Customers.Country, Customers.County, Customers.[e-mail], CONVERT(varchar(20), Customers.Entrydate, 102) AS EntryDate,

...

first, how are you populating the xl sheets? can you post the code? i ask because i'm wondering if there isn't a switch you can use that tells it to...

i don't know about configuring dbmail to query the ad, but you can wrap a proc around dbmail and have the proc query the ad. in other words, instead of...

if you're not able to connect from any other system, then i would think the problem's on the server. while it's possible that the same (or similar) problems exist on...

that part really depends on how you're trying to access the remote server. if you're using sql management studio, then when you're at the connection dialog, click the Options button...

just out of curiosity, in your first post, you said the job had not been done. in your last post, you said the job ran successfully. how do you know...

have you:

1. allowed remote connections in the surface area configuration tool?

2. enabled named pipes and/or tcp/ip?

3. if this is a named instance, started the sql browser?

4. allowed connections to pass...

i use return values to tell me whether or not a proc ran successfully or encountered any errors, and i use output parameters to return specific values encountered by the...

is the job and/or schedule active? is the schedule's start date in the past or in the future? is sql agent running?

is domain\sqlman a user of that database? does it have a user account under the security tab in that database?

yes, it is.

one solution is to redesign the report. instead of doing the matrix in the report, do it before the report, in sql, using the PIVOT clause (if you...

from the error message, it looks almost like you've still got the query in the dataset where command type = text.

go into the form's parameters and remove them:

layout tab

report menu

report parameters