[SOLVED] The grid link does not work from the summary when you run a dynamic group by table.

Scriptcase 9 Bugs
#1

the grid link does not work from the summary when you run a dynamic group by table.
As you can see in the query, there is no field defined in the group by dynamic.

ERROR when clicking on the link in the summary panel:
Errore durante l’accesso alla banca dati:
SQLState: 42000 Error Code: 102 Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ‘=’.
SELECT count(*) from mio_sistemimasterAE ma LEFT JOIN Magaz m ON m.ECS1=ma.ecs1 AND m.ecs1 != ‘’ LEFT JOIN SitCli sc ON sc.Codice=m.CodSito LEFT JOIN Magaz m1 ON m1.Codice=ma.codmagazzino WHERE (ma.statoAE != ‘DISMESSO’ OR ma.statoAE IS NULL) and ( = DETT)

#2

Hallo,
i have the same problem . The link works with static group by bu not with dynamic also using the same group by fields.

And now ?

#3

​The reported case was corrected in release 9.0.022. Version available for download and update.

#4

​The reported case was corrected in release 9.0.022. Version available for download and update.

#5

The reported case was corrected in release 9.0.022. Version available for download and update.