ASP.NET

Kandepu Rajesh wrote:

The reports are displaying fine as expected. But the problem is some reports have active links in them which when clicked redirects to another report.

Kandepu Rajesh wrote:

But the reporting server services can be accessed inside the firewall only.

Kandepu Rajesh wrote:

But my asp.net application can be accessed from any where

Kandepu Rajesh wrote:

how can I display the redirection reports even in the Report Viewer control. Is there any way to manipulate the links programatically, so that they will be displayed on the report viewer.

Considerations for server-side Automation of Office[^]:

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

• EPPlus[^];
• ClosedXML[^];
• The OpenXML SDK[^];

using (OleDbConnection connection = new OleDbConnection("-YOUR CONNECTION STRING HERE-"))
using (OleDbCommand command = new OleDbCommand("SELECT * FROM emp WHERE date_logged Between ? And ?"))
{
    // OleDbCommand doesn't use named parameters, so the names don't matter here:
    command.Parameters.AddWithValue("StartDate", textbox1.Text);
    command.Parameters.AddWithValue("EndDate" ,textbox2.Text);
    
    ...
}

command.Parameters.AddWithValue("StartDate", Convert.ToDateTime(textbox1.Text));