I have gotten the ASP.NET MVC Report Viewer working in my MVC application using the sample code provided on the website. I am viewing the sample report called SampleReport.trdx.
I have created a test report using the Visual Studio Designer and of course it is of .cs extension. ActiveUsers.cs.
In the ReportViewerView.cshtml the report source is set like so: .ReportSource(new UriReportSource() { Uri = "SampleReport.trdx" })
How to I change the reportsource to use the activeusers.cs; I have tried .ReportSource(new UriReportSource() { Uri = "ActiveUsers.cs" }) and it says the name cannot be resolved.
Regards,
Kurt
I have an ASP.NET MVC application. I have the telerik reporting MVC report viewer installed. I have the sample report displaying using the report viewer view that is packaged in the installer.
I created a separate class library to hold my reports, it is called MyClass.client.reports. In is there is a reports folder and a report I created using the Visual Studio Designer. It uses a SQL query, and the DataContext from my solution which it recognized when I created the report.
When I preview the report in Visual Studio it previews fine. When I try to access the report at runtime I get the following error in the report viewer. The connection string is in the AppConfig of another project which my report project references. So my reports are in one project. Controllers & views in a second project. The data connection string is in the appconfig of the third project. I don't understand why the report cannot resolve the data connection.
An error has occurred while processing Table 'table1': Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application. ------------- InnerException ------------- Format of the initialization string does not conform to specification starting at index 0.
I have a Kendo UI grid with filters. I want to take those filters and apply them to a Reporting Services report. How do I pass the filters from the UI Grid to the reports end point?
I've seen plenty examples of how to do this with the RadGrid, but not with the UI JS grid.
Note, I'm using the DataSourceRequest helpers to construct linq queries. I'd prefer to keep this using these helpers.
thanks
Hi,
I'm very new to telerik reporting. Please check my issue below.
I have created a telerik report using designer. This report calls stored procedure to retrieve the data and binds to chart.
I'm getting following error message when I generate the report via report viewer.
"The expression contains object 'dtScan' that is not defined in the current context".
I have already added all required report parameters (input parameters). Actually this 'dtScan' is not an input parameter. It is a one of the data table field and using inside my stored procedure. I'm sure that there is no issue on my stored procedure. It is working perfectly when I design the report (means that when I set stored procedure to report via design wizard).
As I mentioned, I'm getting this error message when I generate report via report viewer and as well as preview window (please see the attached images).
Please looking forward your help to solve this issue.
Thanks!
I'm trying to figure out how to bind a List to a List<T> property of my main data source and I'm having trouble.
I have a report that binds like this:
var report = new TQuoteReport
{
DataSource = new ObjectDataSource
{
DataSource = quote // Quote is my object
}
};
var reportProcessor = new ReportProcessor();
var reportSource = new InstanceReportSource()
{
ReportDocument = report
};
var renderingResult = reportProcessor.RenderReport("PDF", reportSource, null);
return renderingResult.DocumentBytes;
And the Quote looks like this:
public class Quote
{
public int Id { get; set; }
public DateTime Created { get; set; }
...
public List<LineItem> LineItems { get; set; }
}
where LineItem is just a basic object like this:
public class LineItem
{
public int Id { get; set; }
...
}
The main report binding fields work great with [= Fields.Id]
However, I can't figure out how to bind the LineItem List to a List report object. In the designer it will only let me bind the datasource with the ObjectDataSource that is set to Quote. It won't let me choose the LineItem list. I feel like I'm missing something here.
What am I not doing right? I would rather keep it all in one report and not do a subreport if I don't have to.
Thanks!
Hi,
Is it possible to turn 'off' the caching that the Report Viewer performs?
regards
Richard
I'm using standalone report designer for creating report template, and I need to create Area chart, and in this chart areas will intersect. Can I set somehow color of the area to be partialy transparent so i will see back area also? I attached image of chart that I currently achive and a can't see area intersections.