Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Recommended Posts

Posted (edited)

I'm struggling with the syntax to make it behave like this msSQL does:

 

Skærmbillede 2024-08-07 kl. 04.00.17.png

I'm doing this to avoid unstored fields redition of the sums and to avoid filtered portals....

--sd

Edited by Søren Dyhr
Posted (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 by comment
  • Plus1 1
Posted
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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.