Where have you created the Query?
If you have created your Query in Console, you can on the Grouping page when adding the Grouping attribute specify whether this should be collapsed or not when the Query is run.
When the Query is created through Web Access it will always run as collapsed.
Thanks for replying. I created the query in Console but I'm wanting to use it in Web Desk. I have "Show Collapsed" unchecked, which does work when I run the query inside the Console, but Web Desk still shows the query as collapsed.
I'd give an IISReset a shot. If that doesn't work you could try to delete the query from webaccess, add it again (if it's working correctly in console) and do another IISReset. I've had issues like that in the past also.
I have tested it in my test system and it appears I was wrong.
The show collapse option is a console feature only and doesn't apply to Web Access I'm afraid.
In Web Access the Query will always run as collapsed.
If you want this feature to change, then I would suggest adding in a suggestion on our ER, which you can find here: Enhancement Requests
Thanks a lot for testing it and for the ER suggestion