[SOLVED] filter table contents on page level

This topic is locked

[SOLVED] filter table contents on page level	4/27/2011 4:53:18 AM
ASPRunnerPro General questions
K kimz author Hello, I am trying asprunner and i have the following stock table; Product BoxId Serial HD204UI BJZ90000017900 S2H7J1BZ928416 HD204UI BJZ90000017900 S2H7J1BZ928420 HD204UI BJZ90000017900 S2H7J1BZ928418 HD204UI BJZ90000017901 S2H7J1BZ928425 HD204UI BJZ90000017901 S2H7J1BZ928423 HD204UI BJZ90000017901 S2H7J1BZ928427 HD204UI BJZ90000017901 S2H7J1BZ928428 WD5000AAKS FVMKB16196 WCAWFA046934 WD5000AAKS FVMKB16196 WCAWFA043462 WD5000AAKS FVMKB16196 WCAWFA043323 WD5000AAKS FVMKB16196 WCAWFA176521 WD5000AAKS FVMKB16196 WCAWFA041354 WD5000AAKS FVMKB19999 WCAWFA046644 WD5000AAKS FVMKB19999 WCAWFA047172 WD5000AAKS FVMKB19999 WCAWFA176532 WD5000AAKS FVMKB19999 WCAWFA041251 WD5000AAKS FVMKB19999 WCAWFA047315 The table also has an id colum with auto numbering values. I would like the data of this table to be grouped in products (with totals) with subgroups boxid (with totals per box) and the serial numbers at the lowest level. I know the totals can be calculated with the COUNT option. But how can i group the same items? Kim

Mark as Solved Mark as not solved

2 replies


	Sergey Kornilov admin 4/27/2011
	It looks like you need to create a report choosing Product as a first group field and Boxid as a second group field. Report can be added on 'Datasource tables' screen.


K	kimz author 4/28/2011
	It looks like you need to create a report choosing Product as a first group field and Boxid as a second group field. Report can be added on 'Datasource tables' screen. Hi, thanks for the tip.

2 replies

Mark as Solved Reply