I saw this movie with our anime club and... wow. It's a fantastic example of the story and graphics athat can be achieved in an animated movie. The plot is tight, and honestly, one should probably see at least some of the Haruhi shows before this to understand it fully, but for those familiar with the Haruhi universe and the basic concepts within it it's a great rollercoaster ride of a movie.

Overall, this movie has about the same type of content as the original series.

Violence/Gore - Virtually nonexistent until much later in the movie, where there is one scene involving a wound and a lot of blood. It lasts only a few minutes, but could still be disturbing to some nonetheless.

Nudity/Sexual Content - If you've seen the first season of Haruhi, then you should be fine with this movie, as there's less fanservice than the series proper. The only real problematic scene I remember is an accidental panty shot.

Theo. Themes - Again, about as much as the TV series. There are certain people who have "powers" so to speak, Y'know, Yuki being an alien, Itsuki having ESP, the usual.
There are two scenes that caught my attention, one near the beginning, and one somewhere in the middle. The first is when Haruhi is talking about Christmas, and she blabbers on about how if they celebrate Christ's birthday, maybe they should celebrate Muhammad and Buddha's too. The second is during a fairly climactic moment involving Kyon, and he wonders who he should pray to. He mentions a number of names, Christ being one of them.

Other Themes - Minor swearing as far as I can remember, in both the sub and dub.
In the beginning of the movie, Haruhi mentions that she won't drink alcohol. That's pretty much it.

Sub vs Dub - I've seen each version twice, and they're both good. I personally prefer Kyon's English voice, but yet prefer Haruhi's Japanese voice. The rest of cast is just fine in either, though I have heard of people who aren't too happy with Yuki's English voice for some reason.
I really can't choose between the sub/dub, and there aren't any substantial changes to the script (no extra swearing, no parts are cut out.)

This was a great conclusion to a already excellent title. Beautiful animation, excellent computer animation, and a gripping music score, this film was, I would have to say, the best chapter of the Haruhi series.

Violence/Gore: A character punches another, but its more like self defense, and it isn't anything that serious. The climax is where all the blood and violence (which doesn't happen for too long. The violence I mean.) could be too much for some viewers.

Nudity/Sexual content: None except at the beginning where Kyon and the viewer see Mikuru's panties, but Kyon only saw them by accedent. This cause Haruhi to labe him a perv.

Potentially problematic Theological themes: Haruhi is still a god like character and Spoiler: the world is remade by Yuki Nagato. The film does have a lot to do with this.

Other Potentially Problematic themes: Kyon is still partially dirty mouthed, as da** and h*** are common. ba***** is also used once.

Sub vs. dub: I have only watched the dub, but the sub may have less cursing.