Build a ConnectWise Report Writer URL with Filters

Report Writer lets you encode filter values directly into a URL. Share that URL with a team member and the report opens with the filters already applied — no manual selection required.

URL structure

The base URL format is:

http://CW.MyCompany.com/v4_6_release/reporting/ReportViewer.aspx?rn=CATEGORY/REPORTNAME&PARAMETERS

For cloud instances, replace the version segment with your current version number — for example, v2015_5:

http://CW.MyCompany.com/v2015_5/reporting/ReportViewer.aspx?rn=CATEGORY/REPORTNAME&PARAMETERS

Segment	What to replace it with
CW.MyCompany.com	Your ConnectWise server hostname
v4_6_release or v2015_5	Your installed version
CATEGORY	The report’s category (assigned when the report was saved)
REPORTNAME	The report title — replace any spaces with +
PARAMETERS	Filter values in the format P1Value=x&P2Value=y

Note: A report’s category is set when you save it. Go to Save in Report Writer, choose a category, or create a new one.

Pass a single filter value

Each filter maps to a positional parameter — P1Value is the first filter on the report, P2Value the second, and so on. The order matches the filter order shown in the report viewer.

Example URL passing a single Company_RecID:

http://CW.MyCompany.com/v4_6_release/reporting/ReportViewer.aspx?rn=Example+Reports/TestReport&P1Value=19499

Report Writer URLs support up to 5 filter values (P1Value through P5Value).

Pass multiple filters

Separate each additional parameter with &.

To add a Location filter as the second parameter:

http://CW.MyCompany.com/v4_6_release/reporting/ReportViewer.aspx?rn=Example+Reports/TestReport&P1Value=19499&P2Value=Tampa

Pass multiple values into a single filter

To filter on more than one value within the same parameter, separate the values with commas.

For example, to pull four companies using filter 1:

P1Value=19499,19501,19482,19496

Full example URL:

http://CW.MyCompany.com/v4_6_release/reporting/ReportViewer.aspx?rn=Example+Reports/TestReport&P1Value=19499,19501,19482,19496

Skip a filter position

You do not need to supply a value for every filter. To filter on the third filter only (for example, Updated By), address it as P3Value and omit the others:

http://CW.MyCompany.com/v4_6_release/reporting/ReportViewer.aspx?rn=Example+Reports/TestReport&P3Value=cedwards

Hidden filters

A hidden filter has its Param checkbox unchecked in the report designer. The filter applies a fixed default value that the end user cannot change. Passing a value for a hidden filter in the URL has no effect — the URL value is ignored.

Caveats

• If you reorder or add filters in the report designer, any existing URLs break — the positional parameters no longer match. Rewrite the URL after any filter changes.
• If your URL passes in more filter positions than the report has filters, the extra values are ignored.
• If a filter value does not match any data in that column, the report returns no results.
• Filter values must match the expected data type. Passing a date string into a numeric field (e.g., 1/1/2005 into a Company_RecID filter) returns no results.