FiveTech Software tech support forums

having a simple xbrowse table with customer.dbf, how could I go from xbrowse to Tree (in the same normal xbrowse) grouping the customer.dbf archive into groups for a sample (married, age >50) making the user select the desired group and then go back to normal xbrowse obviously ...

not only should xbrowse do it automatically but the settree() should set the field (of the array or db) to do the grouping, maybe selecting it from a combobox "normal", "tree" and also make the search work with GET oGet VAR cSeek and COMBOBOX oBrw:oSortCbx example ...

... i.e. for example the search for a city and at the same time the entries starting with ... 5) insert in the same xbrowse the possibility of grouping the records, for example in a product archive grouping by category in the xbrowse or for date of add these are just the last few things i cant ...

... of displaying both a regular table (xBrowse) and a tree (xBrowse) in the same xBrowse control with the ability to switch between grouping and non-grouping modes, you can follow these steps:Create the xBrowse control and attach the initial table (customer.dbf) as the data ...

... and the xbrowse must be the same, I created something that doesn't work but I'm sure nages will find the solution. It is important to have a grouping, for example in an archive of articles we can view the normal table or a grouping by category, it must be a fluid system. Must have research ...

... table, https://i.postimg.cc/XJvNGgBR/1.png and above the table I can do a search then a get and a combox I would like to make groupings for example for the State field, so I could use an Xbrowse Tree control and create the same columns you see in the picture. But I would also ...

... customers by status" i have to create another xbrowse i can't use the same one which is in the dialog . what if the user no longer wants grouping? I would like to make the end user could group the records according to conditions for example for customer.dbf files, the end user could group ...

... to execution of any DML statements with method Execute() or using methods Insert(...), Upsert(...) and Update(...) This us provided to faclititate grouping of several DML statements/ methods inside TRY/CATCH block for Transactions. Example Usage: // -------- local lError := .f. oCn:BeginTransaction() ...

... to execution of any DML statements with method Execute() or using methods Insert(...), Upsert(...) and Update(...) This us provided to faclititate grouping of several DML statements/ methods inside TRY/CATCH block for Transactions. Example Usage: // -------- local lError := .f. oCn:BeginTransaction() ...

...  oWnd:nWidth := 800   ACTIVATE WINDOW oWnd CENTEREDreturn nil  Demonstrates: 1. Aligning some buttons to the right. 2. Grouping of buttons 3. Labeling of groups https://imagizer.imageshack.com/v2/xq90/924/99aXVe.png

Dear Otto ,

I am Developing an accounting and Inventory software, need to develop below kind of reports:

1) Invoice ( Most Important )
2) Tabular Reports with Grouping
3) T Format Reports
4) Matrix Report


Thanks
Shrihdar

... to create. The reason is that it uses a filter on one field, and an index on another. The first field is by NAME, and we want to do the report grouping all records by name, and breaking when the name changes. The second field for selection is by date, and I use a filter to look only at records ...

... of TXBrwColumn: By default, rows with same value of the column are grouped for merging. In some cases different criterion may be necessary for grouping. In such cases bMergeValue may be specified. - Fix: oCol:cDataType 'F': When the value of a column resolves to a file name of image, specifying ...

At one time, in my distant memory, it was possible to have a header with grouping in a browse. On some columns, there might just be the normal title, but it was possible to group several columns under a title. For example: | | Section 1 | Col 1 | Col 2 | Col ...

If we need single level grouping we can use simple GROUP BY clause. For 2 or more levels of nested grouping we need to use "GROUP BY ... WITH ROLLUP" clasue. This is an example of the sql which summarizes two levels of grouping ...