I would write a query against the underlying datasource (table(s)) to see what's going on.

Something like:

SELECT *

FROM TweetsList

WHERE TweetURL NOT LIKE 'http://%'

AND TweetURL NOT LIKE 'https://%'

AND TweetURL NOT LIKE 'ftp://%'

AND...

I don't think so. I did the first one as an embedded dataset and created a union query, just because I wanted the report to be as simple as...

Post if it still doesn't work and explain what you did step by step... because try as I might, I can't reproduce the issue. Can you open the links...

Okay, taking it from the top, because I have no clue why mine works and yours doesn't.

Create a dummy table:

CREATE TABLE TweetsList(

TweetDate DATE NOT NULL,

TweetURL VARCHAR(50) NOT NULL

);

GO

Populate:

INSERT...

I don't have any data... Should I just make some up?

Did you attach it? I don't see it.

Can you post your report with some dummy data? either embed the data like I did or post CREATE TABLE/INSERT scripts to populate it.

The data can be completely fake......

Sure it does. I just did it. It was even easier than I thought.

This is what I did...

(My dataset is embedded, otherwise it wouldn't work for you... it's a...

Is this between a static date, like @CompareDate DATE?

Or is this between sequential Invoice Dates?

Either way you use DATEDIFF, but if you want to look at the previous date, you...

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,...