Traditional web-based reporting with SAS BI tools

Highlight row in Report using SAS Web Report Studio by passing prompt (Macro) Values on user basis

Reply
Occasional Contributor
Posts: 13

Highlight row in Report using SAS Web Report Studio by passing prompt (Macro) Values on user basis

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.

SAS Employee
Posts: 10

Re: Highlight row in Report using SAS Web Report Studio by passing prompt (Macro) Values on user b

Posted in reply to Sachin_bansode

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

Ask a Question
Discussion stats
  • 1 reply
  • 176 views
  • 0 likes
  • 2 in conversation