Report on web portal using Filters

[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

[tom_grant]

I would suggest posting this on the Solutions-> Business Intelligence -> Web Report Studio Community page

[mmudasir]

Any Body having answer

[Madelyn_SAS]

You can easily create filters in Web Report Studio or in the underlying information map. Although, you will need to create prompted measure filters in the map. You can create static filters on the table for either data type. What have you tried so far? Note that a filter won't remove columns from a table.