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

[Sachin_bansode]

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.

[XavierBizoux]

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