Søren Dyhr Posted August 7, 2024 Posted August 7, 2024 (edited) I'm struggling with the syntax to make it behave like this msSQL does: I'm doing this to avoid unstored fields redition of the sums and to avoid filtered portals.... --sd Edited August 7, 2024 by Søren Dyhr
comment Posted August 7, 2024 Posted August 7, 2024 (edited) This is not a good way to ask a question. First, I don't know how MS SQL behaves. Next, I don't know what exactly "too many ?'s" means. If you are constructing the SQL in the Data Viewer, you should be getting a (more or less) helpful error message. As it is, it's not clear neither what the problem is nor the expected solution. It would be much better to post a file with sample data alongside the exact result you expect to get from it. I can only guess you are after something like the attached example. SubGroupSQL.fmp12 4 hours ago, Søren Dyhr said: I'm doing this to avoid unstored fields redition of the sums and to avoid filtered portals.... The best way to do this is to use the "Fast Summaries" method. Edited August 7, 2024 by comment 1
Søren Dyhr Posted August 7, 2024 Author Posted August 7, 2024 1 hour ago, comment said: I can only guess you are after something like the attached example. It was exactly what I was after ... thank you! --sd
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now