How to create Filters in Reports on SaS Web Portal / SaS Web Report Studio

[mmudasir]

How to create Filters in Reports on SaS Web Portal  / SaS Web Report Studio

Data is like

Sr. No.	Group	Description	Qty	MRP	Disc	rate	GST	Total	Amount
1	Plate	2M FLAT 5 PLATE GRAY	2	327	55%	147.15	18.0%	173.64	347.27
2	Plate	3M FLAT 5 PLATE GRAY	16	362	55%	162.9	18.0%	192.22	3075.55
3	Plate	4M FLAT 5 PLATE GRAY	6	386	55%	173.7	18.0%	204.97	1229.80
4	Plate	6M FLAT 5 PLATE GRAY	10	697	55%	313.65	18.0%	370.11	3701.07
5	Switch	6A SWITCH GRAY	60	172	55%	77.4	18.0%	91.33	5479.92
6	Indicator	INDICATOR GRAY	10	263	55%	118.35	18.0%	139.65	1396.53
7	Regulator	1M FAN REGULATOR GRAY	6	612	55%	275.4	18.0%	324.97	1949.83
8	Socket	6A SOKET GRAY	25	294	55%	147.15	18.0%	173.64	347.27
9	Socket	1M SOCKET ( 2PIN) GRAY	12	198	55%	89.1	18.0%	105.14	1261.66
10	USB	USB 2.1A GRAY	4	2138	55%	962.1	18.0%	1135.28	4541.11
11	Switch	6A 2WAY SWITCH GRAY	10	207	55%	93.15	18.0%	109.92	1099.17
12	Plate	BLANK PLATE GRAY	6	50	55%	22.5	18.0%	26.55	159.30
13	Switch	16A SWITCH INDICATOR GRAY	15	306	55%	137.7	18.0%	162.49	2437.29
14	Socket	16A SOCKET GRAY	16	355	55%	159.75	18.0%	188.51	3016.08
15	Switch	25A DP (SPN) GRAY	4	578	55%	260.1	18.0%	306.92	1227.67

Report must be like having Two Filters of Group & GST

Group

Switch

GST

(All)

Description                                    Qty   MRP   Disc

6A SWITCH GRAY	60	172	0.55
6A 2WAY SWITCH GRAY	10	207	0.55
16A SWITCH INDICATOR GRAY	15	306	0.55
25A DP (SPN) GRAY	4	578	0.55

[Madelyn_SAS]

A filter won't remove columns from the object. It only filters the rows. 

For the Group, you can easily create a filter on a category. Will the filter be static or will it be prompted so that users can select the group that they want? 

For the GST, this appears to be a measure. In this case, a filter will normally be something like an EQUAL TO or a LESS THAN or GREATER THAN, etc. How were you thinking to filter for GST?