I think you really want a formula like:
if datediff("yyyy",currentdate,minimum({table.date},{table.group})) < 18 then 1 else 0
Then create a group sum of that formula.
Then add a group selection formula to select groups where the sum is = 0. Then any group with 1 or more people under 18 will...
Hi,
Does anyone know a way to suppress cross-tab rows based on the row total value? I want to suppress rows where the row total is <= 15.
I tried adding a group selection formula but even though the groups were removed from the report they were not removed from the crosstab.
Thanks,
Rob
I have stored procedures with parameters in Sybase ASE. When I connect from Crystal XI to one of these stored procedures using Sybase ASE ODBC driver, the parameters are missing from the report. However, using the native Sybase drive the parameters show properly.
Any idea why the parameters...
I'm looking for a product or source code for calculating statistics (like SPSS, SAS, etc,) in T-SQL for a SQL Server database. In particular I need to compute p-value for hypothesis testing using chi-square and t-test formulas. Any advice would be greatly appreciated.
Thanks,
Rob
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.