Calendar Report Default Highlighting

[Sam Ogden]

Hi All,

We have a calendar report setup that is being shared on a dashboard.  We've add some field styles for state so we have 'state' as an option under the 'highlight based on'.  When we load the dashboard this field defaults to '--None -- '.  Is there a way to default this to always open with the highlighting as 'state'?

Thanks

Sam

[Brian Lancaster · Accepted solution]

If the report is in a dashboard you can do the following.

Navigate to Homepage Admin > Pages.
Click the homepage or dashboard title where the calendar report is located.
Click the Dropzone the calendar report type is listed under.
Click New to define a new portal preference.
Complete these fields:

Name : sysparm_calstyle
Value : priority

If you are sending out published URL you can do this.  You sysparm_report_id will be different.

https://<your servicenow instance>/sys_report_display.do?sysparm_report_id=5fb91fd60f15afc099907d4ce1050e23&sysparm_calstyle=priority

[Sam Ogden]

Cheers for this Brian, works a treat!

[Community Alums]

Hey Brian

At our organisation we have created a 'subtype' category which captures the difference between minor, major, significant changes. The category is there to 'highlight based on' using the drop down box, but i when i use sysparm_calstyle with a value of 'subtype' it doesn't work (it does work if i use the OOB category 'type'). Is there a way to use the custom category?

[Community Alums]

Sorry Brian, I just worked it out. I'll leave this here in case anyone else needs to know the answer. 

If you're highlighting based on a non OOB category you need to use the element name not the label. 

So for us if i use u_subtype in the calstyle it will indeed colour by Subtype.