Forum Replies Created

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

  • RE: Web URL in dataset results

    For grins, create a dummy table and just copy a bunch of tweet URLs, and see if they work. That's where I got them for my report. If that...

  • RE: Web URL in dataset results

    What can't you see?

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

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