Hi mate,

What values, if any, are you getting in the wait_type or blocking_session_id columns from sys.dm_exec_requests for the session the proc is running in?

Cheers

Phil Parkin (7/25/2012)

---

ChrisM@Work (7/25/2012)

---

This looks very much like a homework question, in which case Anthony's reply is a good place to start.

Don't forget that TOP is meaningless without ORDER...

What error, if any, are you getting?

You should also check with the admins of the other domain that the account you're using has permission to send email to them.

You can reference fields from other datasets using expressions - something like =(Fields!Sales.Value, "DataSet2011"), but I think you'll be in a world of hurt trying to tie the data back...

Hi Carol,

I don't think you can change the datasource based on a parameter. You can create linked reports on the report server & change the datasource for each one though....

Nope, there's no built in way to do it - pretty much forced to roll our own solutions, as you've done.

The other way would be to create empty tables with...

Cool 🙂

Yep, the * in the selects will do that. Remove them & just list the fields you actually want, in the order you want.

It's generally bad practice to use *...

Hi mate,

You can't reference a column by it's alias in the same select in that way.

You can by selecting from a subquery though - think that's what you're trying to...

Hi Beth,

I don't use integrated mode, but can you connect to the RS instance via SSMS?

You can view Shared Schedules & reports that use each one in there. At least,...

lcarrethers (7/23/2012)

---

I spoke to fast

I use these two expressions to get totals by state:

1. =Iif(trim(First(Fields!SUTASTAT.Value, "DataSet5")) = "OK", Sum(Fields!FICAMWPR.Value, "DataSet5"),cdbl(0))+Iif(trim(First(Fields!SUTASTAT.Value, "DataSet5")) = "OK", Sum(Fields!FCASWPR.Value, "DataSet5"),cdbl(0))

2=Iif(trim(First(Fields!SUTASTAT.Value, "DataSet5")) = "LA", Sum(Fields!FICAMWPR.Value, "DataSet5"),cdbl(0))+Iif(trim(First(Fields!SUTASTAT.Value,...

Hi Eliza,

Been a while since I've done this, but can you create the interior calculation as a calculated field in the report?

Then do the exterior SUM on the calculated field?

Cheers

Gaz

Edit:...

In fact, I think that can be shortened:

SELECT z.username,

REPLACE(

CASE

WHEN z.agegroup = '1' AND CHARINDEX(',2,', ISNULL(z.profiles, '')) > 0 THEN REPLACE(z.profiles, '2', '')

WHEN z.agegroup = '2' AND CHARINDEX(',1,', ISNULL(z.profiles, ''))...

Hi Labri,

Is this any good to you?

SELECT z.username,

REPLACE(

CASE

WHEN z.gender= 'm' AND CHARINDEX(',f,', ISNULL(z.profiles, '')) > 0 THEN REPLACE(z.profiles, f, '')

WHEN z.gender = 'f' AND CHARINDEX(',m,', ISNULL(z.profiles, '')) >...

rodjkidd (7/24/2012)

---

While waiting for some reasonable sized databases to back up before doing some upgrades, I finally managed to have a stab at answering a question today. No one else...