Asp.net-mvc – Calling SSRS Reports From asp.net MVC4 (Also sending parameter to that report)

asp.net-mvcasp.net-mvc-4reporting-servicesssrs-2008-r2

Hi all i need help regarding ssrs reporting and calling it from mvc4 application which is the major concern at this time and also i want to send parameters to the ssrs from the mvc4 code so that utilizing these inputs may return the concerned data

I did search it over an over again but did not get the exact solution which is calling ssrs reports from mvc and also sending parameters from the mvc and show data in the reports against that report
Thanks in advance

Best Answer

If you simply want to navigate to the report create the URL like Mozy showed in his answer to https://stackoverflow.com/a/1128705/1859022
if you need to create the path dynamically you could use MVCs Url.Encode.

a sample implementation in your controller could look like:

public ActionResult ShowReport()
{
    //url encode path on server
    string path = Url.Encode("/path/to/folder/");
    string url = "http://<server>/ReportServer/Pages/ReportViewer.aspx?" + path + "<ReportName>&rs:Command=Render";
    //add param
    url += "&<Param>='<Value>'";
    return new RedirectResult(url);
}

use the action in your view like this:

@Html.ActionLink("Show Report", "ShowReport");

for further mvc tutorials have a look at http://www.asp.net/mvc

Related Solutions

SSRS Report Subscription emails stopped sending

The Report subscriptions are created as jobs for the SQL Agent. You should see a long list of jobs with GUIDs as the names. Make sure that the SQL agent jobs are running. Going through the Steps of the SQL Reporting Services Configuration tool will recreate these jobs if you were to move the Reporting Service installation to another server. (I don't recall which step recreates the subscriptions. Just go through each pane and click "Apply.")

Depending on how you move things, you may need to backup and restore encryption keys, and you can easily end up in a state where two copies of subscription exist and are executed ( on different servers.) But in your case, where you didn't move SSRS, I'd look at the SQL Agent properties on the original server (Express) to see that the SQL agent is enabled and running, and check the history of the SQL Agent jobs, to see if there are any problems.

Javascript – JSON.stringify doesn’t work with normal Javascript array

JavaScript arrays are designed to hold data with numeric indexes. You can add named properties to them because an array is a type of object (and this can be useful when you want to store metadata about an array which holds normal, ordered, numerically indexed data), but that isn't what they are designed for.

The JSON array data type cannot have named keys on an array.

When you pass a JavaScript array to JSON.stringify the named properties will be ignored.

If you want named properties, use an Object, not an Array.

const test = {}; // Object
test.a = 'test';
test.b = []; // Array
test.b.push('item');
test.b.push('item2');
test.b.push('item3');
test.b.item4 = "A value"; // Ignored by JSON.stringify
const json = JSON.stringify(test);
console.log(json);

Best Answer

Related Solutions

SSRS Report Subscription emails stopped sending

Javascript – JSON.stringify doesn’t work with normal Javascript array

Related Topic