topic How to Create Report on SAS Web Report Studio in SAS Web Report Studio https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Create-Report-on-SAS-Web-Report-Studio/m-p/820740#M2538 <P>I want to Publish a Report thru&nbsp;<A title="SAS Web Report Studio Part 2" href="https://www.youtube.com/watch?v=d3v4N1r6-PU" target="_blank" rel="noopener">SAS Web Report Portal&nbsp;</A>for&nbsp; below given data</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Sno</TD><TD>Description</TD><TD>Part</TD><TD>Amount</TD><TD>Dates&nbsp; &nbsp;</TD></TR><TR><TD>1</TD><TD>Apple</TD><TD>Achieved</TD><TD>1200</TD><TD>31-Mar-2022</TD></TR><TR><TD>2</TD><TD>Carrot</TD><TD>Achieved</TD><TD>29500</TD><TD>31-Mar-2022</TD></TR><TR><TD>3</TD><TD>Fish</TD><TD>Achieved</TD><TD>30010</TD><TD>31-Mar-2022</TD></TR><TR><TD>4</TD><TD>Meat</TD><TD>Achieved</TD><TD>54908</TD><TD>31-Mar-2022</TD></TR><TR><TD>5</TD><TD>Grappes</TD><TD>Achieved</TD><TD>34560</TD><TD>31-Mar-2022</TD></TR><TR><TD>1</TD><TD>Apple</TD><TD>Achieved</TD><TD>1800</TD><TD>17-Jun-2022</TD></TR><TR><TD>2</TD><TD>Carrot</TD><TD>Achieved</TD><TD>33200</TD><TD>17-Jun-2022</TD></TR><TR><TD>3</TD><TD>Fish</TD><TD>Achieved</TD><TD>25040</TD><TD>17-Jun-2022</TD></TR><TR><TD>4</TD><TD>Meat</TD><TD>Achieved</TD><TD>47908</TD><TD>17-Jun-2022</TD></TR><TR><TD>5</TD><TD>Grappes</TD><TD>Achieved</TD><TD>36590</TD><TD>17-Jun-2022</TD></TR><TR><TD>1</TD><TD>Apple</TD><TD>Target</TD><TD>1840</TD><TD>30-Jun-2022</TD></TR><TR><TD>2</TD><TD>Carrot</TD><TD>Target</TD><TD>33500</TD><TD>30-Jun-2022</TD></TR><TR><TD>3</TD><TD>Fish</TD><TD>Target</TD><TD>28040</TD><TD>30-Jun-2022</TD></TR><TR><TD>4</TD><TD>Meat</TD><TD>Target</TD><TD>50908</TD><TD>30-Jun-2022</TD></TR><TR><TD>5</TD><TD>Grappes</TD><TD>Target</TD><TD>40590</TD><TD>30-Jun-2022</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the REPORT has to be like this with additional calculated Field</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><FONT face="arial black,avant garde" color="#003366">Calculated Fields</FONT></TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><STRONG><FONT color="#33CCCC">Achieved</FONT></STRONG></TD><TD><STRONG><FONT color="#33CCCC">Target</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>S No</TD><TD>Description</TD><TD>31-Mar-2022</TD><TD>17-Jun-2022</TD><TD>30-Jun-2022</TD><TD>Shortfall/Excess %age Against Target</TD><TD>Shortfall/Excess %age Against March 2022</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>1</TD><TD>Apple</TD><TD>1200</TD><TD>1800</TD><TD>1840</TD><TD>2.22%</TD><TD>50.00%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2</TD><TD>Carrot</TD><TD>29500</TD><TD>33200</TD><TD>33500</TD><TD>0.90%</TD><TD>12.54%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>3</TD><TD>Fish</TD><TD>30010</TD><TD>25040</TD><TD>28040</TD><TD>11.98%</TD><TD>-16.56%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>4</TD><TD>Meat</TD><TD>54908</TD><TD>47908</TD><TD>50908</TD><TD>6.26%</TD><TD>-12.75%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5</TD><TD>Grappes</TD><TD>34560</TD><TD>36590</TD><TD>40590</TD><TD>10.93%</TD><TD>5.87%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 28 Jun 2022 17:06:31 GMT mmudasir 2022-06-28T17:06:31Z How to Create Report on SAS Web Report Studio https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Create-Report-on-SAS-Web-Report-Studio/m-p/820740#M2538 <P>I want to Publish a Report thru&nbsp;<A title="SAS Web Report Studio Part 2" href="https://www.youtube.com/watch?v=d3v4N1r6-PU" target="_blank" rel="noopener">SAS Web Report Portal&nbsp;</A>for&nbsp; below given data</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Sno</TD><TD>Description</TD><TD>Part</TD><TD>Amount</TD><TD>Dates&nbsp; &nbsp;</TD></TR><TR><TD>1</TD><TD>Apple</TD><TD>Achieved</TD><TD>1200</TD><TD>31-Mar-2022</TD></TR><TR><TD>2</TD><TD>Carrot</TD><TD>Achieved</TD><TD>29500</TD><TD>31-Mar-2022</TD></TR><TR><TD>3</TD><TD>Fish</TD><TD>Achieved</TD><TD>30010</TD><TD>31-Mar-2022</TD></TR><TR><TD>4</TD><TD>Meat</TD><TD>Achieved</TD><TD>54908</TD><TD>31-Mar-2022</TD></TR><TR><TD>5</TD><TD>Grappes</TD><TD>Achieved</TD><TD>34560</TD><TD>31-Mar-2022</TD></TR><TR><TD>1</TD><TD>Apple</TD><TD>Achieved</TD><TD>1800</TD><TD>17-Jun-2022</TD></TR><TR><TD>2</TD><TD>Carrot</TD><TD>Achieved</TD><TD>33200</TD><TD>17-Jun-2022</TD></TR><TR><TD>3</TD><TD>Fish</TD><TD>Achieved</TD><TD>25040</TD><TD>17-Jun-2022</TD></TR><TR><TD>4</TD><TD>Meat</TD><TD>Achieved</TD><TD>47908</TD><TD>17-Jun-2022</TD></TR><TR><TD>5</TD><TD>Grappes</TD><TD>Achieved</TD><TD>36590</TD><TD>17-Jun-2022</TD></TR><TR><TD>1</TD><TD>Apple</TD><TD>Target</TD><TD>1840</TD><TD>30-Jun-2022</TD></TR><TR><TD>2</TD><TD>Carrot</TD><TD>Target</TD><TD>33500</TD><TD>30-Jun-2022</TD></TR><TR><TD>3</TD><TD>Fish</TD><TD>Target</TD><TD>28040</TD><TD>30-Jun-2022</TD></TR><TR><TD>4</TD><TD>Meat</TD><TD>Target</TD><TD>50908</TD><TD>30-Jun-2022</TD></TR><TR><TD>5</TD><TD>Grappes</TD><TD>Target</TD><TD>40590</TD><TD>30-Jun-2022</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the REPORT has to be like this with additional calculated Field</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><FONT face="arial black,avant garde" color="#003366">Calculated Fields</FONT></TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD><STRONG><FONT color="#33CCCC">Achieved</FONT></STRONG></TD><TD><STRONG><FONT color="#33CCCC">Target</FONT></STRONG></TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>S No</TD><TD>Description</TD><TD>31-Mar-2022</TD><TD>17-Jun-2022</TD><TD>30-Jun-2022</TD><TD>Shortfall/Excess %age Against Target</TD><TD>Shortfall/Excess %age Against March 2022</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>1</TD><TD>Apple</TD><TD>1200</TD><TD>1800</TD><TD>1840</TD><TD>2.22%</TD><TD>50.00%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>2</TD><TD>Carrot</TD><TD>29500</TD><TD>33200</TD><TD>33500</TD><TD>0.90%</TD><TD>12.54%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>3</TD><TD>Fish</TD><TD>30010</TD><TD>25040</TD><TD>28040</TD><TD>11.98%</TD><TD>-16.56%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>4</TD><TD>Meat</TD><TD>54908</TD><TD>47908</TD><TD>50908</TD><TD>6.26%</TD><TD>-12.75%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>5</TD><TD>Grappes</TD><TD>34560</TD><TD>36590</TD><TD>40590</TD><TD>10.93%</TD><TD>5.87%</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 28 Jun 2022 17:06:31 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/How-to-Create-Report-on-SAS-Web-Report-Studio/m-p/820740#M2538 mmudasir 2022-06-28T17:06:31Z