Is the hyperlink nested inside of a text column?

I created a dummy report with a text string that I wanted to use as a hyperlink, and it worked.

In Placeholder properties,...

Is the hyperlink nested inside of a text column?

I created a dummy report with a text string that I wanted to use as a hyperlink, and it worked.

In Placeholder properties,...

One option is to use a tablix, and add the Item to the Row Groups section, and then put the quantity INSIDE that group.

Then you end up with

Gold Watch...

Here's an article about it:

http://www.sqlservercentral.com/blogs/vivekssqlnotes/2013/12/29/deleting-duplicate-rows-using-cte/

Since you're new here, and we can't really help without some create table scripts and some data.... Please read this[/url]

It's not that we don't want to help, it's just that...

Could you give a couple of examples of your expected output? It's just a lot easier to code from that. It sounds like you could use something like this:...

(Sorry,...

like I said "Sharp as a MARBLE!!!"

Got it to work... Makes me feel like Ralph Wiggum "I'm learnding!!!" <with crayon in nose>

I looked there, but didn't see a link to download, so that's why I asked here. He explains the patterns, but without the database they're working from, I can't...

Are you doing a running total? Is this in SSRS that you need to do this? Or in T-SQL?

thanks for the data. Helps a lot, but really you should post it in a consumable format (because folks here are busy... so set the scenario up for them)....

Oh, ouch. That's painful slow. <hanging head>

Something like...

CREATE TABLE Actuals (

FY INT

,P1 SMALLMONEY

,P2 SMALLMONEY

,P3 SMALLMONEY

,P4 SMALLMONEY

,P5 SMALLMONEY

,P6 SMALLMONEY

,P7 SMALLMONEY

,P8 SMALLMONEY

,P9 SMALLMONEY

,P10 SMALLMONEY

,P11 SMALLMONEY

,P12 SMALLMONEY

CONSTRAINT pkActuals PRIMARY KEY (FY)

);

GO

-- insert some dummy values...

INSERT INTO dbo.Actuals(FY,P1,P2,P3,P4,P5,P6,P7,P8,P9,P10,P11,P2)

-- 2000...

That's what I thought... if they gave me the scripts to create a database and said "write a stored procedure that does X", then it would make sense. Otherwise, the...

John,

It's a recruiter, which makes me wonder, because the number of recruiters in this town that understand and can evaluate the "goodness" of T-SQL code is less than 5. In...

That's kind of what I was thinking. Without context, the solution is somewhat meaningless. For example, in a previous job, I had to summarize data in tables that I...