I’ve never been able to get E10 setup such that I can use the “Design SSRS Report” item under the Actions menu in the BAQ Report Designer.
Under the BAQ Options, there is a field for SSRS Web Service URL
The online help says
SSRS Web Service URL
Defines an alternate directory path to the Microsoft® SQL Server Report Builder® (Report Builder) application. By default, the URL that launches the Report Builder is automatically pulled from the Epicor server information, so typically you can leave this field blank.
However if this path is a “localhost” URL and you are on a different computer, enter the complete URL path in this field (for example: http:///Reports) and the Report Builder will launch. You can get this alternate web service URL from the Microsoft® Reporting Services Configuration Manager® located on the server. After you enter this path, selecting the Actions > Design SSRS Report option launches your BAQ report in the Report Builder as expected.
Leaving it blank yields
Same error if I populate it with http://USDATDBS00001/ReportServer
or http://USDATDBS00001:80/ReportServer
I’m thinking it wants the path to an actual program and not just a server path.
Where in the “Microsoft® Reporting Services Configuration Manager” can I find the value. The only URLs are:
and
And both provide the “Application not found” error
FWIW - I’ve always just used a browser with that URL to get to the custom Reports and used “Edit in Report Builder” from the reports dropdown. But I feel as though It should work from right inside E10.
Sorry - no answer, just echoing…
add an issue I’ve run into with RDD based report styles.
Unless I am logged in on the server as admin when using the URL to launch Report Builder, then any subreports won’t preview.
Would be interested to hear any thoughts on setting up a workstation for report writers?
Doing some research on this, and it turns out there are two versions of Report Builder. One is referred to “One Click” which I think is the one that launches when you select “Edit in Report Builder” while browsing the reports.
The other appears to be a standalone program, which is not installed on the SQL server by default.
I’m guessing that second one is what you need to point the URL to in the BAQ Report Options. After installing it on the SQL Server.
Sorry to hijack your thread and on top of it, I didn’t describe my issue clearly.
Issues previewing on the server with standalone compared to the URL.
And when trying to use either on a workstation… more previewing errors.
Ref screen shots
server url direct to reports
vs standalone report builder editing downloaded .rdls
Also wondering if anyone editd E10 RDL files in Visual Studio?
( When I looked at it last, thought I had requisite installs but… not)
What is the path to the subreport in the main RDL? Even with the subs on your local machine, the paths specified in the main report may not point to them.
Yes, I’m guessing it’s path (or lack of) As far as I can tell, paths are assumed for subreports. Only their names appear in the XML. ON a related note, I’ve been able to change problem report server connections using notepad e.g. rd:ReportServerUrlhttp://localhost/ReportServer</rd:ReportServerUrl>.
No luck fixing a problem Data Source connection path.
Also been running into permission issues when I try to use Report Builder on a workstation to edit reports.
Just seems like SSRS doesn’t like certain types of location changes or editing offline.
