Calling Direct SSRS from Menu

Epicor ERP 10
1

Hi folks,

I want to call direct rdl file from Menu Maintenance.

I use Program Type as SSRS Custom Report Link and in Report I am giving the path of report.
Eg: http://ServerName/Reports/ERPTest/CustomReports/Sample.rdl

But when i click print preview, instead of direct firing report, its showing the report server xml tree wherein then i have to select ERPTest folder, then click on CustomReports and then my report will show.

I want to direct call this Sample.rdl file to be open on clicking Print Preview.

Kindly suggest what additional setting i need to check.

thanks friends in advance.

2

I have several custom SSRS reports, and I use “URL Link”, rather than SSRS Custom Report Link. I can’t remember why or what the difference is, but you could try to follow this example:

image
image539Ă—538 14.9 KB

1 Like
3

Hi alintz,

Actually, I am calling this report on Button click inside form.
When button click, ProcessCaller.LaunchForm(oTrans, “MenuID”)…

As per your suggestion, if report is standalone then its fine…this will work definitely.
From button click, is there any way to call this URL type link?

Hanky

4

Sorry, calling the SSRS report URL from inside code is not in my bag of tricks. You’ll have to get one of the other guru’s to handle that question.

5

:slight_smile:

Yea alintz, u r true…

6

Hello,

Anyone has any idea how to achieve this. Thanks in advance.

7

You call Process.Start( “URL String” );

For reports, Process.Start(“http://[SQL Server]/ReportServer?/[Path]/[Report Name]&[Parameters]”);

We have a button that prints a Pack Slip with it eventually calling (after setting the variable information)

Process.Start(“http://[SQL Server]/ReportServer?/” + _envName + “/reports/_CustomReports/PackingSlip/[Report Name]&PackNum=” + packNum.ToString());

Scott

8

Thanks Scott :slight_smile: