BookmarkSubscribeRSS Feed
Sachin_bansode
Fluorite | Level 6

Dear All,

We are creating reports by using SAS Web report studio 4.4.

 

For this we are creating      Cube --->Info map --->WRS.

 

Our Requirements

1-we need to highlight rows in reports on basis user who is login on WRS.

e.g.

-Suppose user B is from “office1” logs in WRS then he is able to see all field of reports by

 

Highlighting those all records which are belongs from "office1” & “Region” & “User”

 

Below is demo report which is Highlighting the row of user B.

 

Idea is the user will quickly find his related data.

 

Region

Office

User

count_orders

Sum_Sales

1

Office2

A

23

1234

2

office1

B

34

2314

3

office1

C

32

45678

4

office4

D

54

54326

5

office4

E

6

543

6

office7

F

67

2314

 

 

Is there any way to pass the macros parameters (Prompt) to Info map or WRS report by   using filters on the user basis?

 

Please let me know which the best way to do this task is.

In Advance Thanks.

1 REPLY 1
XavierBizoux
SAS Super FREQ

Hi,

 

Beginning with SAS® Web Report Studio 4.31_M2, you can create conditional highlighting rules that are based on character categories.

https://support.sas.com/documentation/cdl/en/citug/65339/PDF/default/citug.pdf

 

If you want to create rules based on numeric categories, or if you are using an earlier version of SAS Web Report Studio, you can refer to the following SAS Note: http://support.sas.com/kb/40/747.html

 

Have a good day

Xavier BIZOUX
Advisory Technical Architect ● Global Enablement and Learning
Technology Transfer and Governance, R&D

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 838 views
  • 0 likes
  • 2 in conversation