Custom Ribbon BUtton - Link to SSRS Report

(0) Share

Report

Posted on by Community Member

I am using the ribbon workbench solution (by Develop1.net) to add a custom button to the product form ribbon. The button comand is to link to an ssrs report. an error is received

The path of the item '/Custom+Reports/InventoryCheck/Low+Stock' is not valid.
The full path must be less than 260 characters long; other restrictions apply.
If the report server is in native mode, the path must start with slash.
(rsInvalidItemPath)

The URL is 114 characters. I have also tried adding (/) in front of the url but than receive another error that says the path is dangerous. Any suggestions?

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (1)

Royal King 27,686 on at

Like (0)

Report

Is it custom report you imported into crm or you are trying to provide link to ssrs report that resides in your report server?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It does not reside in crm, its an ssrs report on our report server

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

if you access the whatever url embedded in the custom ribbon button in browser does it work?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

Are you calling javascript on click of button to open custom report if not i would suggest adding javascript function to encode url and opening it ?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Please create a custom button in your form. Attach a javascript function to open SSRS report link in a new window.

you can use below snippet for your refernce.

function openReport()

{

var w = 950;

var h = 650;

var left = (screen.width/2)-(w/2);

var top = (screen.height/2)-(h/2);

var url ="your ssrs report url"

window.open(url, "reportwindow", "resizable=1,width=950,height=700,left=" +left+ " ,top=" +top);

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I've done that but no the button wont do anything. this is my script.

function openReport() {

var w = 950;

var h = 650;

var left = (screen.width / 2) - (w / 2);

var top = (screen.height / 2) - (h / 2);

var url = "orbusssrs/.../Report.aspx;ViewMode=Detail"

window.open(url,"reportwindow", "resizable=1,width=950,height=700,left=" + left + " ,top=" + top);

}

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

It looks like you are not passing full url of the report. You have to full url of the report otherwise crm will add first part of the url from crm and it will not work.

Say if you ur report url in report server is servername/.../reportname , you have to pass this complete url not just part of the url.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The server name is orbusssrs and the name of the report is Low Stock. When I paste that URL into a browser window the report comes up

Was this reply helpful? Yes No
Royal King 27,686 on at

Like (0)

Report

can you add protocol as well like http:// or https:// to the url and give a try?

Was this reply helpful? Yes No

Community site session details

Custom Ribbon BUtton - Link to SSRS Report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Custom Ribbon BUtton - Link to SSRS Report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates