Browse/report with accordeon

[skiman]

Hi,

I have some data (array) in the following form.

Code: Select all

Brand - Category - Subcategory - Sales
Sony - Audio - TV - 1000
Sony - Audio - soundbar - 500
Sony - IT - Notebook - 1000
Samsung - Audio - TV - 2000
Samsung - Audio - Soundbar - 500
...

I'm looking to create a screen which shows the following at startup:
Sony - 2500
Samsung - 2500

If you click on Sony you get the following:
Audio - 1500
IT - 1000

If you click on Audio you get:
TV - 1000
Soundbar - 500

With jQuery this is called 'accordeon'.

Any suggestions how this could be accomplished in Xbase++?

[Auge_Ohr]

hi

if you want to browse Array :
1st Column "Brand" than "SET RELATION" from 2nd Column up with Footer to Sum.

[Wolfgang Ciriack]

Make a Treeview from your array.

[skiman]

Hi,

@Jimmy, I don't understand what you mean with the 'set relation' in an array.

@Wolfgang: Yes a treeview seems to be a logical choice, but the layout of a treeview doesn't provide columns, and also it doesn't provide totals and subtotals.

I will check the possibilities of the report-control of Codejock. That has the layout as needed.

[Wolfgang Ciriack]

but the layout of a treeview doesn't provide columns, and also it doesn't provide totals and subtotals.

You can calculate them when building your treeview (or expanding the treeview) and put the sum in the CARGO of each treeview item and showing them in on a separate static.
And your "columns" are the different childitems.

Code: Select all

+Sony-----+Audio---+TV
                   +Soundbar
     -----+IT------+Notebook
+Samsung--+Audio---+TV
                   +Soundbar

[skiman]

Hi,

I solved this problem with the codejosk reportcontrol. I has the possibility to change the order. It recalculates automatically. The user can sort on the column he/she wants with simple drag and drop.

Sorted and subtotals by brand and category:

brandcategory.PNG (31.72 KiB) Viewed 14783 times

Sorted and subtotals by Category and brand:

category-brand.PNG (21.26 KiB) Viewed 14783 times

Sorted and subtotals by Category - Subcategory - Brand:

cat-subcat-brand.PNG (27.06 KiB) Viewed 14783 times

[Auge_Ohr]

@Jimmy, I don't understand what you mean with the 'set relation' in an array.

i mean to make 2 Browse in One ...
1St Browse is only 1st Column. 2nd Browse goes into "RELATION" when Cursor of 1st Browse is moved.
have to "generate" a Array Sample if you need it.

Yes a treeview seems to be a logical choice, but the layout of a treeview doesn't provide columns, and also it doesn't provide totals and subtotals.

I will check the possibilities of the report-control of Codejock. That has the layout as needed.

hm ... Codejock Report Control ... Treeview and Listview in one Control ... look nice.

[unixkd]

Hi all

Codejock CONTROLs are good IN PRINCIPLE, but in practice, you will be disapointed with the SLUGISNESS of the controls. Try to populate 5000 items on the codejock report control, you will come back home quickly. In terms of performance on large datasets nothing close to Xbase++ in the market today except you are coding in C/C++.

Joe

[unixkd]

Hi all

Codejock CONTROLs are good IN PRINCIPLE, but in practice, you will be disapointed with the SLUGISNESS of the controls. Try to populate 5000 items on the codejock report control, you will come back home quickly. In terms of performance on large datasets nothing close to Xbase++ in the market today except you are coding in C/C++.

Joe

[Tom]

You can do all that in a XbpBrowse.