Sorry Ninja, I did not get you...do you mean set up a trace ?

Could anyone please help me, I am still stuck on this ?

sdvoranchik (8/30/2011)

---

I am not sure I fully understand the challenge. If your expression is in the master report, setting up the drill through is relatively similar. Your question...

sdvoranchik (8/26/2011)

---

This is when I usually try to take a step back and break things down to try to figure out where the problem is occuring. First step is...

sdvoranchik (8/25/2011)

---

So it sounds like you are on your way and getting closer. Here is a quick recap. To create the drill through report, you would create it...

Hi,

I have created a drill through report but I am not getting the desired data in the target report. I dont know what is it that I am doing wrong....

sdvoranchik (8/24/2011)

---

Yes, this sounds like the exact use for a drill through report. Here is a how-to article from the microsoft website. Passing multiple parameters to the drill...

Mike Menser (7/21/2011)

---

Untested -- try this case statement:

case when ARRIVAL_SCHEDULE_DT = DATEADD (month, 3, getdate()) and VESSEL_NAME = 'BEZEE' then 'N' else '' end +

case when LAST_UPDATE_DT = getdate() and...

kramaswamy (8/18/2011)

---

VS_NEEDSNEWMETADATA shows up when the underlying data behind one of the tasks changes. In your case, if the data that is being obtained from the database has changed, then...

Sean Lange (8/16/2011)

---

Or just remove the subquery as it really isn't needed.

SELECT

ESO_PORT,

sum(case when ONTIME_S = 'On Time' then 1 else 0 end)...

Thanks very much for your help !

Charles Hearn (8/16/2011)

---

Sorry about that. You need to add an alias to the end of the subquery.

SELECT ESO_PORT,

SUM(Ontime_s) Ontime_s,

...

Charles Hearn (8/16/2011)

---

I believe this will work for you.

SELECT ESO_PORT,

SUM(Ontime_s) Ontime_s,

SUM(Late_s) Late_s,

SUM(Ontime_c) Ontime_c,

SUM(Late_c) Late_c

FROM (SELECT

ESO_PORT,

case when ONTIME_S = 'On Time' then 1 else 0 end as Ontime_s,

case when ONTIME_S =...

Thanks for your advice Welsh !!! I apologize for my comments...

Ninja's_RGR'us (8/9/2011)

---

I remember feeling like that at least twice in my life. It's not easy to turn around but it is possible.

The first time I got back to school...