Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[stricko]

Hi there,

So I'm in Theatre View, trying to resolve the issue about movies with the same title. Nothing clever, I'm trying to use the Year field to differentiate the movies. In my query grouping expression, I have the value [Name] [Year]. But this returns the following result

Toy Story 2 1999
Toy Story 3 2010
Toy Story 1995

How do I rewrite my grouping expression to put Toy Story at the top of the results?

Many thanks

[EnglishTiger]

Looks to me like the Sort is being done on Name - try changing it to Year or maybe Name within Year

[stricko]

Sorry, I probably didn't make myself clear. I definitely want the films sorted by name. It's primarily to resolve issues with multiple films have exactly the same name. Like Crash, True Grit, War of the World's etc etc etc. My query works perfectly for that. But, it has the wierd side effect shown in my original post.

I assumed that my [Name]  [Year] would either sort by name first, in which case Toy Story should come before Toy Story 2, or produce a string where Toy Story 1995. Should come before Toy Story 2

Or am I missing something. I tried exactly the same data in Excel, and the sort results are as I expect

[zybex]

Try:
Expression to group by = [Name]
Expression to Display = [Name] ​([Year])
Sorting: Ascending

You can also use a different expression on the "group by" and then set Sorting="Name".