Hi Guys   I am geting bellow error while logging to sas financial management Addin    "A problem has been encountered reading the environment file on the server" ... View more

i think nobody knows, how to do it ... View more

I want to Publish a Report thru SAS Web Report Portal for  below given data   Sno Description Part Amount Dates    1 Apple Achieved 1200 31-Mar-2022 2 Carrot Achieved 29500 31-Mar-2022 3 Fish Achieved 30010 31-Mar-2022 4 Meat Achieved 54908 31-Mar-2022 5 Grappes Achieved 34560 31-Mar-2022 1 Apple Achieved 1800 17-Jun-2022 2 Carrot Achieved 33200 17-Jun-2022 3 Fish Achieved 25040 17-Jun-2022 4 Meat Achieved 47908 17-Jun-2022 5 Grappes Achieved 36590 17-Jun-2022 1 Apple Target 1840 30-Jun-2022 2 Carrot Target 33500 30-Jun-2022 3 Fish Target 28040 30-Jun-2022 4 Meat Target 50908 30-Jun-2022 5 Grappes Target 40590 30-Jun-2022   the REPORT has to be like this with additional calculated Field             Calculated Fields         Achieved Target         S No Description 31-Mar-2022 17-Jun-2022 30-Jun-2022 Shortfall/Excess %age Against Target Shortfall/Excess %age Against March 2022     1 Apple 1200 1800 1840 2.22% 50.00%     2 Carrot 29500 33200 33500 0.90% 12.54%     3 Fish 30010 25040 28040 11.98% -16.56%     4 Meat 54908 47908 50908 6.26% -12.75%     5 Grappes 34560 36590 40590 10.93% 5.87%                     ... View more

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 ... View more

we are upgrading to Higher Version 9.4  from 9.3   Any Advice, which needs to be kept in mind during migration,  Please provide resolutions , if u have any in mind   All Suggestion are welcome and will be taken seriously, ... View more

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   ... View more