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

Sachin_bansode — Thu, 27 Oct 2016 12:47:05 GMT

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.

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

XavierBizoux — Tue, 08 Nov 2016 09:38:52 GMT

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

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

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

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