Drillback on SSRS Report - Incorrect URL

(0) Share

Report

Posted on by Brady W Riopelle

545

Hey Everyone,

I have copied a server/computer for testing purposes which had SQL & GP. After renaming the computer and the sql instance to the appropriate names, I had everything back up and running how it should. However I'm having an issue with the drillback functionality from SSRS Reports into GP. The url is trying to connect to the old server name and server instance. I tried running fiddler to see where that URL is being pulled from but I didn't get any results. Anyone know where this would be getting pulled from or where it is stored?

I have already tried creating a new Reporting Services database and redeployed GP SSRS reports to the site.

Double check all DSN's in windows making sure there is no reference to the old SQL Server instance.

Make sure there was no aliases created for SQL.

I can see the SSRS GP Reports from within GP. I can also use the link within GP to launch the SSRS Report. (Business Analyzer works as well)

Where to go from here?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Steve Simon 348 on at

Like (0)

Report

RE: Drillback on SSRS Report - Incorrect URL

Rob's answer worked for me. I Altered all the pertinent Views for the DB and replaced the test machine name with the production machine name. Then all the drillbacks worked.

Steve Simon

PDG Consultants
Rob Bernhardt on at

Like (0)

Report

Re: Drillback on SSRS Report - Incorrect URL

Brady,

The drillback url's are stored in Dynamics GP views. I don't have a list of them all, but DB..Accounts would be an example. The Account Index for Drillback column would need to be changed in your example.

Thanks

Rob