topic Report on web portal using Filters in SAS Web Report Studio https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/820561#M2539 <P>How to create Filters in Reports on SaS Web Portal&nbsp; / SaS Web Report Studio</P><P>&nbsp;</P><P>Data is like</P><TABLE><TBODY><TR><TD>Sr. No.</TD><TD>Group</TD><TD>Description&nbsp;</TD><TD>Qty</TD><TD>MRP&nbsp;</TD><TD>Disc</TD><TD>rate</TD><TD>GST</TD><TD>Total</TD><TD>Amount</TD></TR><TR><TD>1</TD><TD>Plate</TD><TD>2M FLAT 5 PLATE GRAY</TD><TD>2</TD><TD>327</TD><TD>55%</TD><TD>147.15</TD><TD>18.0%</TD><TD>173.64</TD><TD>347.27</TD></TR><TR><TD>2</TD><TD>Plate</TD><TD>3M FLAT 5 PLATE GRAY</TD><TD>16</TD><TD>362</TD><TD>55%</TD><TD>162.9</TD><TD>18.0%</TD><TD>192.22</TD><TD>3075.55</TD></TR><TR><TD>3</TD><TD>Plate</TD><TD>4M FLAT 5 PLATE GRAY</TD><TD>6</TD><TD>386</TD><TD>55%</TD><TD>173.7</TD><TD>18.0%</TD><TD>204.97</TD><TD>1229.80</TD></TR><TR><TD>4</TD><TD>Plate</TD><TD>6M FLAT 5 PLATE GRAY</TD><TD>10</TD><TD>697</TD><TD>55%</TD><TD>313.65</TD><TD>18.0%</TD><TD>370.11</TD><TD>3701.07</TD></TR><TR><TD>5</TD><TD>Switch</TD><TD>6A SWITCH GRAY</TD><TD>60</TD><TD>172</TD><TD>55%</TD><TD>77.4</TD><TD>18.0%</TD><TD>91.33</TD><TD>5479.92</TD></TR><TR><TD>6</TD><TD>Indicator</TD><TD>INDICATOR GRAY</TD><TD>10</TD><TD>263</TD><TD>55%</TD><TD>118.35</TD><TD>18.0%</TD><TD>139.65</TD><TD>1396.53</TD></TR><TR><TD>7</TD><TD>Regulator</TD><TD>1M FAN REGULATOR GRAY</TD><TD>6</TD><TD>612</TD><TD>55%</TD><TD>275.4</TD><TD>18.0%</TD><TD>324.97</TD><TD>1949.83</TD></TR><TR><TD>8</TD><TD>Socket</TD><TD>6A SOKET GRAY</TD><TD>25</TD><TD>294</TD><TD>55%</TD><TD>147.15</TD><TD>18.0%</TD><TD>173.64</TD><TD>347.27</TD></TR><TR><TD>9</TD><TD>Socket</TD><TD>1M SOCKET ( 2PIN) GRAY</TD><TD>12</TD><TD>198</TD><TD>55%</TD><TD>89.1</TD><TD>18.0%</TD><TD>105.14</TD><TD>1261.66</TD></TR><TR><TD>10</TD><TD>USB</TD><TD>USB 2.1A GRAY</TD><TD>4</TD><TD>2138</TD><TD>55%</TD><TD>962.1</TD><TD>18.0%</TD><TD>1135.28</TD><TD>4541.11</TD></TR><TR><TD>11</TD><TD>Switch</TD><TD>6A 2WAY SWITCH GRAY</TD><TD>10</TD><TD>207</TD><TD>55%</TD><TD>93.15</TD><TD>18.0%</TD><TD>109.92</TD><TD>1099.17</TD></TR><TR><TD>12</TD><TD>Plate</TD><TD>BLANK PLATE GRAY</TD><TD>6</TD><TD>50</TD><TD>55%</TD><TD>22.5</TD><TD>18.0%</TD><TD>26.55</TD><TD>159.30</TD></TR><TR><TD>13</TD><TD>Switch</TD><TD>16A SWITCH INDICATOR GRAY</TD><TD>15</TD><TD>306</TD><TD>55%</TD><TD>137.7</TD><TD>18.0%</TD><TD>162.49</TD><TD>2437.29</TD></TR><TR><TD>14</TD><TD>Socket</TD><TD>16A SOCKET GRAY</TD><TD>16</TD><TD>355</TD><TD>55%</TD><TD>159.75</TD><TD>18.0%</TD><TD>188.51</TD><TD>3016.08</TD></TR><TR><TD>15</TD><TD>Switch</TD><TD>25A DP (SPN) GRAY</TD><TD>4</TD><TD>578</TD><TD>55%</TD><TD>260.1</TD><TD>18.0%</TD><TD>306.92</TD><TD>1227.67</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Report must be like having Two Filters of Group &amp; GST</P><TABLE><TBODY><TR><TD>Group</TD><TD>Switch</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD>GST</TD><TD>(All)</TD></TR></TBODY></TABLE><P>Description&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Qty&nbsp; &nbsp;MRP&nbsp; &nbsp;Disc</P><TABLE><TBODY><TR><TD>6A SWITCH GRAY</TD><TD>60</TD><TD>172</TD><TD>0.55</TD></TR><TR><TD>6A 2WAY SWITCH GRAY</TD><TD>10</TD><TD>207</TD><TD>0.55</TD></TR><TR><TD>16A SWITCH INDICATOR GRAY</TD><TD>15</TD><TD>306</TD><TD>0.55</TD></TR><TR><TD>25A DP (SPN) GRAY</TD><TD>4</TD><TD>578</TD><TD>0.55</TD></TR></TBODY></TABLE><P>&nbsp;</P> Mon, 27 Jun 2022 18:36:44 GMT mmudasir 2022-06-27T18:36:44Z Report on web portal using Filters https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/820561#M2539 <P>How to create Filters in Reports on SaS Web Portal&nbsp; / SaS Web Report Studio</P><P>&nbsp;</P><P>Data is like</P><TABLE><TBODY><TR><TD>Sr. No.</TD><TD>Group</TD><TD>Description&nbsp;</TD><TD>Qty</TD><TD>MRP&nbsp;</TD><TD>Disc</TD><TD>rate</TD><TD>GST</TD><TD>Total</TD><TD>Amount</TD></TR><TR><TD>1</TD><TD>Plate</TD><TD>2M FLAT 5 PLATE GRAY</TD><TD>2</TD><TD>327</TD><TD>55%</TD><TD>147.15</TD><TD>18.0%</TD><TD>173.64</TD><TD>347.27</TD></TR><TR><TD>2</TD><TD>Plate</TD><TD>3M FLAT 5 PLATE GRAY</TD><TD>16</TD><TD>362</TD><TD>55%</TD><TD>162.9</TD><TD>18.0%</TD><TD>192.22</TD><TD>3075.55</TD></TR><TR><TD>3</TD><TD>Plate</TD><TD>4M FLAT 5 PLATE GRAY</TD><TD>6</TD><TD>386</TD><TD>55%</TD><TD>173.7</TD><TD>18.0%</TD><TD>204.97</TD><TD>1229.80</TD></TR><TR><TD>4</TD><TD>Plate</TD><TD>6M FLAT 5 PLATE GRAY</TD><TD>10</TD><TD>697</TD><TD>55%</TD><TD>313.65</TD><TD>18.0%</TD><TD>370.11</TD><TD>3701.07</TD></TR><TR><TD>5</TD><TD>Switch</TD><TD>6A SWITCH GRAY</TD><TD>60</TD><TD>172</TD><TD>55%</TD><TD>77.4</TD><TD>18.0%</TD><TD>91.33</TD><TD>5479.92</TD></TR><TR><TD>6</TD><TD>Indicator</TD><TD>INDICATOR GRAY</TD><TD>10</TD><TD>263</TD><TD>55%</TD><TD>118.35</TD><TD>18.0%</TD><TD>139.65</TD><TD>1396.53</TD></TR><TR><TD>7</TD><TD>Regulator</TD><TD>1M FAN REGULATOR GRAY</TD><TD>6</TD><TD>612</TD><TD>55%</TD><TD>275.4</TD><TD>18.0%</TD><TD>324.97</TD><TD>1949.83</TD></TR><TR><TD>8</TD><TD>Socket</TD><TD>6A SOKET GRAY</TD><TD>25</TD><TD>294</TD><TD>55%</TD><TD>147.15</TD><TD>18.0%</TD><TD>173.64</TD><TD>347.27</TD></TR><TR><TD>9</TD><TD>Socket</TD><TD>1M SOCKET ( 2PIN) GRAY</TD><TD>12</TD><TD>198</TD><TD>55%</TD><TD>89.1</TD><TD>18.0%</TD><TD>105.14</TD><TD>1261.66</TD></TR><TR><TD>10</TD><TD>USB</TD><TD>USB 2.1A GRAY</TD><TD>4</TD><TD>2138</TD><TD>55%</TD><TD>962.1</TD><TD>18.0%</TD><TD>1135.28</TD><TD>4541.11</TD></TR><TR><TD>11</TD><TD>Switch</TD><TD>6A 2WAY SWITCH GRAY</TD><TD>10</TD><TD>207</TD><TD>55%</TD><TD>93.15</TD><TD>18.0%</TD><TD>109.92</TD><TD>1099.17</TD></TR><TR><TD>12</TD><TD>Plate</TD><TD>BLANK PLATE GRAY</TD><TD>6</TD><TD>50</TD><TD>55%</TD><TD>22.5</TD><TD>18.0%</TD><TD>26.55</TD><TD>159.30</TD></TR><TR><TD>13</TD><TD>Switch</TD><TD>16A SWITCH INDICATOR GRAY</TD><TD>15</TD><TD>306</TD><TD>55%</TD><TD>137.7</TD><TD>18.0%</TD><TD>162.49</TD><TD>2437.29</TD></TR><TR><TD>14</TD><TD>Socket</TD><TD>16A SOCKET GRAY</TD><TD>16</TD><TD>355</TD><TD>55%</TD><TD>159.75</TD><TD>18.0%</TD><TD>188.51</TD><TD>3016.08</TD></TR><TR><TD>15</TD><TD>Switch</TD><TD>25A DP (SPN) GRAY</TD><TD>4</TD><TD>578</TD><TD>55%</TD><TD>260.1</TD><TD>18.0%</TD><TD>306.92</TD><TD>1227.67</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Report must be like having Two Filters of Group &amp; GST</P><TABLE><TBODY><TR><TD>Group</TD><TD>Switch</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD>GST</TD><TD>(All)</TD></TR></TBODY></TABLE><P>Description&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Qty&nbsp; &nbsp;MRP&nbsp; &nbsp;Disc</P><TABLE><TBODY><TR><TD>6A SWITCH GRAY</TD><TD>60</TD><TD>172</TD><TD>0.55</TD></TR><TR><TD>6A 2WAY SWITCH GRAY</TD><TD>10</TD><TD>207</TD><TD>0.55</TD></TR><TR><TD>16A SWITCH INDICATOR GRAY</TD><TD>15</TD><TD>306</TD><TD>0.55</TD></TR><TR><TD>25A DP (SPN) GRAY</TD><TD>4</TD><TD>578</TD><TD>0.55</TD></TR></TBODY></TABLE><P>&nbsp;</P> Mon, 27 Jun 2022 18:36:44 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/820561#M2539 mmudasir 2022-06-27T18:36:44Z Re: Report on web portal using Filters https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/820930#M2540 I would suggest posting this on the Solutions-&gt; Business Intelligence -&gt; Web Report Studio Community page Wed, 29 Jun 2022 14:29:34 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/820930#M2540 tom_grant 2022-06-29T14:29:34Z Re: Report on web portal using Filters https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/829536#M2541 <P>Any Body having answer</P> Sun, 21 Aug 2022 04:03:16 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/829536#M2541 mmudasir 2022-08-21T04:03:16Z Re: Report on web portal using Filters https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/829679#M2542 <P>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.&nbsp;</P> Mon, 22 Aug 2022 15:42:19 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Report-on-web-portal-using-Filters/m-p/829679#M2542 Madelyn_SAS 2022-08-22T15:42:19Z