Hi Robert,

Do you have any idea how to make a correct trigger in SQL?

Cheers, Dirk

Hi Robert,

Indeed,

I have written the field name "Dbo.Customer.Syscstno" (without quotes) in the trigger.
In the DBF-example, the trigger is also filled with the field "Customer.Syscstno".

So, how to make a correct trigger?

Dirk

Hi Robert, All sample replorts works with DBF-files. So, I change the section properties from DBF to SQL, (and I solve all problems regarding the name of the fields). Then, I press the preview button, and I got the message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly...

Hi Robert, I have report pro 2.17 installed and I see a sample report with the name customer.rpt. This report is almost running the way I want with DBF-files. So, I change the report that the trigger runs correct (because using the original report, the trigger runs incorrect). The I try to change th...

Hello All,

Nobody has any idea ?
Where can I find support for Report Pro? Maybe paid?

Cheers, Dirk

Hello All, I don't find any good way to work with triggered section when using SQL-tables. I explain myself: I have 2 tables: First table : A customer-table containing 26 rows (for example the name of the customer is A, B, C etc) Second table : Invoices : Some customers has a few invoices, but there...