Viewing 15 posts - 2,296 through 2,310 (of 3,507 total)
Sounds like homework. Show us what you tried.
September 17, 2015 at 7:12 pm
What happened when you ran the query to see if there were any "illegal" hyperlinks?
The INSERT statement should have nothing to do with it, but it's your database,...
September 17, 2015 at 6:33 pm
Table 1 has "Gender" field with "Male" and "Female" in it, table 2 has "Gender" field with "M" and "F" in it. a query to compare data and list the...
September 17, 2015 at 5:51 pm
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...
September 17, 2015 at 5:47 pm
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...
September 17, 2015 at 3:53 pm
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...
September 17, 2015 at 2:39 pm
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...
September 17, 2015 at 2:02 pm
I don't have any data... Should I just make some up?
September 17, 2015 at 1:37 pm
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......
September 17, 2015 at 12:48 pm
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...
September 17, 2015 at 11:51 am
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...
September 17, 2015 at 11:10 am
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,...
September 16, 2015 at 8:35 pm
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,...
September 16, 2015 at 8:32 pm
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...
September 16, 2015 at 5:12 pm
Viewing 15 posts - 2,296 through 2,310 (of 3,507 total)