Selectionformula

[Former Member]

Post Author: Ottenheim

CA Forum: .NET

Hello,

Currently i'm converting my reports from CR7 to CR11.5. Everything works fine except the selectionformula:

In CR7 we create a selectionformula in the report, say 'DELETED = FALSE'. When we call the report in VB6 we set the selectionformula like 'RELATION = MYSELF'. So when i run the report from code I see data where 'relation = myself and deleted = false'

This 'trick' doesnt work in VB.NET with CR11.5. In report i make a selectionformula 'DELETED = FALSE' and in code i give a recordselectionformula 'RELATION = MYSELF'. When I run the report the data is only filtered by 'RELATION = MYSELF' Looks like the recordselectionformula from code overwrites the recordselection from the report.

Can anyone help me with this? Or do I have to copy alle the selectionformula's from the reports to code?

Thanx,

[Former Member · Accepted solution]

Post Author: Micha

CA Forum: .NET

Hi,

check if there is an existing one before you set the selectionformula, eg

if len(.RecordSelectionFormula)> 5 then .RecordSelectionFormula = "(" & .RecordSelectionFormula & ") AND " & mySelectionformula else .RecordSelectionFormula = mySelectionformula end if

Micha