Page 1 of 1
xBrowse and lMergeVert
Posted: Tue Feb 02, 2021 2:22 pm
by Maurizio
Hello Rao
I use oCol:lMergeVert and oCol:WorkMergeData() to activate at runtime lMergeVert and it works fine ,
but is it possible to disable for other conditions?
IF oBrw:oRs:Sort) == 'State'
WITH OBJECT oBrw:State
:lMergeVert := .t.
:WorkMergeData()
END
ELSE
// HOW DO YOU RESTORE WITHOUT lMergeVert ???
ENDIF
Regards
Maurizio
Re: xBrowse and lMergeVert
Posted: Tue Feb 02, 2021 5:18 pm
by nageswaragunupudi
Code: Select all
// cancellation of vertical merge, if already merged
if oCol:lMergeVert
oCol:lMergeVert := .f.
oBrw:Refresh()
endif
Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 9:36 am
by Maurizio
Thanks RAO
it works very well .
is it possible to have a sub total for each merge?
Maurizio
Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 9:45 am
by nageswaragunupudi
Possible, but you need to do more work.
Please search the forums for samples I posted showing subtotals with mergecols.
May I know if you are using ADO with MySql or MSSql or other database?
Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 10:28 am
by Maurizio
I use ADO
Maurizio
Re: xBrowse and lMergeVert
Posted: Wed Feb 03, 2021 11:47 am
by nageswaragunupudi
Maurizio wrote:I use ADO
Maurizio
It is clear to me that you are using ADO. But with what database? MySQL or MSSQL or Oralce? what database?
I am asking because SQL syntax can vary a little between different databases.
Re: xBrowse and lMergeVert
Posted: Fri Feb 05, 2021 8:27 am
by Maurizio
I use Mysql
Maurizio