Steve Jones - Editor (4/6/2009)

---

Thanks, Bob. I almost didn't run that one. It grew out of a few threads over the last month or so. Had me a little exasperated...

I think you just need to do concatenation to get the value. Something like this:

="java_script:void(window.open('http://servername/ReportServer?/FolderName/ReportName&;tkId=" & Fields!tkinit.Value & "&rs:Command=Render&rc:Parameters=false&rc:Toolbar=false', 'popup','width=800,height=600,location=no,toolbar=no,resizable=1'))"

I didn't put it in a code block because I...

Bob Hovious (4/6/2009)

---

Some people already have taken shots at this approach, and will probably continue to do so. (I am braced for the beating I'm about to take.) ...

No worries. I was just a little surprised you said that, and knew something must...

Chris Morris (4/6/2009)

---

Jack Corbett (4/6/2009)

---

One problem with your first query is that it includes the columns you want the MAX for in the GROUP BY so you get all the...

webrunner (4/6/2009)

---

1. Come up with an easily digested "short version" of the etiquette rules - the purpose is not to water down the etiquette or repeat pages such as Jeff...

I agree that manners are important.

Yes, I am guilty of often not providing an answer, but asking for more information, many times pointing to links in my signature line (Jeff's...

GSquared (4/6/2009)

---

Jack Corbett (4/6/2009)

---

I agree with the facts that it could be a legit business requirement and that using a table to store the times would be the way to...

One problem with your first query is that it includes the columns you want the MAX for in the GROUP BY so you get all the rows. I think...

Is your dataset actually returning a row for each GL Account with a NULL in the amount\balance column or are you not returning anything for GL accounts with no amount\balance?

I agree with the facts that it could be a legit business requirement and that using a table to store the times would be the way to go.

Some...

Really nice solution Matt.

I think that this is one of the shortcomings of SSRS, that fact that you can't, to my knowledge, use target="" in the Jump to...

Jeff Moden (4/4/2009)

---

Heh... I agree... probably an inteview question.

I believe the question actually asks "how would you write a trigger that executed another stored procedure but only at certain times...

Can you post the exact error?

Found this thread[/url] on the MSDN forums that listed a similar problem and they fixed it by modifying the SQL SERVER CONNECTION PROPERTY and setting the 'NO COUNT' option to...