Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 3,507 total)

  • RE: How to find the first, last and the Highest (Peak Value) in a list

    Sounds like homework. Show us what you tried.

  • RE: Web URL in dataset results

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

  • RE: query for compare data in 2 tables

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: DATEDIFF between date for bills

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

  • RE: Web URL in dataset results

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

  • RE: Web URL in dataset results

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

  • RE: SSRS Design to collapse sales lines into 1 line

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

Viewing 15 posts - 2,296 through 2,310 (of 3,507 total)