Questions on Reporting Forum

1 answer

1.6K+ views

Visual Studio 2013 Update 3
MVC Report Viewer
Q1 2015

Currently we have four MVC views which all render a report. I believe its possible to programmatically export to PDF or Excel however is there a way to merge reports.

My question is, if i have two rendered reports programmaticlly does Telerik provide tools to merge lets say two rendered PDF files into one PDF file or two rendered Excel files into one Excel file?

General Discussions

answered on 05 Mar 2015

1 answer

191 views

Margin not working during page break

Hi,

We have set margin of 1 inch for the report header. The margin is set with the text box with 1 inch width and aligning the textbox to vertical. The report header page also has table for displaying the data.Once the page break happens the margin also breaks with the data. How can i set margin for full page even when the page break happens please.

General Discussions

answered on 05 Mar 2015

2 answers

124 views

Data source parameter issue

Hi there,

Bit of a strange one....

We have a very simple report - that runs as expected via the preview option in Visual Studio - that has one data source parameter.

The report library is a class project that we then access from our .NET application.

The problem is when we try to generate the report from the application the parameter is working weirdly.

For some reason the stored procedure is called twice - checked by adding logging to the SP.

First time the parameter is passed, second time a null value is passed. Result is always no data being returned.

Simplified code to generate report shown below...

Dim report_1l As CSA_Testing.Competitive_Tendering = New CSA_Testing.Competitive_Tendering
Dim ds1l As Telerik.Reporting.SqlDataSource = New Telerik.Reporting.SqlDataSource()

ds1l.ConnectionString = ConfigurationManager.ConnectionStrings("CSA_Testing.My.MySettings.CSA").ConnectionString
ds1l.SelectCommand = "RepGen_CT_By_CustomerID"
ds1l.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
ds1l.Parameters.Add("@CustomerID", System.Data.DbType.Int32, 400045)

report_1l.DataSource = ds1l

Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource
instanceReportSource.ReportDocument = report_1l

rv1.ReportSource = instanceReportSource

Has anybody come across this before or have any ideas why it would happen?

We have an older report libray running off earlier Telerik.Report versions that all work fine.

Now we have updated to the lateset versions and tried to create some new reports we always get this issue.

FYI: Visual Studio 2013 / SQL 2012 / Latest Telerik vestions.

Thanks in advance

General Discussions

answered on 04 Mar 2015

1 answer

230 views

How to programatically close a ReportViewer with NO records?

We've stumbled on a show stopper problem (as we can't use Telerik Reporting as a solution) where we can't close a Telerik Report programatically if there are no records returned. We're using the Telerik process where a web service is assigned to the ReportViewer and that web service contains a single line:

<%@ ServiceHost Service="Telerik.Reporting.Service.ReportService, Telerik.Reporting.Service, Version=8.1.14.620, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" %>

We're unable to recover any return information (i.e. RecordCount = 0) that would allow us to issue a Me.Close on the Report Child Window that contains the ReportViewer control. In fact, there is NO web service handler we can use i.e. a "Completed" handler to be able to get any type of return information.

Is this just a limitation of Telerik Reporting and hence we need to explore alternative products, or is there some method we're missing that will help us accomplish our application requirements?

Thanks, Rob.

General Discussions

answered on 03 Mar 2015

2 answers

222 views

CrossTab column group paging

I have a CrossTab with a row grouping and a column grouping. The data results in the row grouping displaying 12 rows, while the column grouping displays 8 or more columns. The width of the page can only fit 7 columns, so the overflowed columns are rendered on the next page. Is there any way to make the overflowed columns render on the same page? There's plenty of vertical space under the original 7 columns/12 rows to fit the overflowed columns/12 rows. The attached SampleReport.png illustrates the situation and desired result.

General Discussions

answered on 03 Mar 2015

11 answers

623 views

Problem with rendering report second time

Hi,

I've created a webshop in Sitefinity. When a user finishes the order, a .pdf invoice file is send.
The first time this process goes without any problem.

The second time, the rendered .pdf is empty. I notice that creating a new instance of the report is very fast, the second time, so it looks like it is not creating a new, fresh instance.

This is the code I'm using:

/// <summary>

/// Generate an invoice

/// </summary>

private Attachment GenerateInvoice(Guid orderid, string ordernumber, string att, string address, string att2, string address2) {

try {

rptInvoice report = new rptInvoice();

Filter f = new Filter();

f.Expression = "=Fields.OrderId";

f.Operator = FilterOperator.Equal;

f.Value = orderid.ToString();

report.Filters.Add(f);

// Invoice address

report.Att = att;

report.FullAddress = address;

// Send address

report.Att2 = att2 != string.Empty ? "VERZENDADRES:" + Environment.NewLine + att2 : string.Empty;

report.FullAddress2 = address2;

ReportProcessor processor = new ReportProcessor();

RenderingResult result = processor.RenderReport("PDF", report, null);

string reportName = "Factuur-" + ordernumber + ".pdf";

string reportLocation = MapPath("~/Orders/");

using (FileStream fs = new FileStream(reportLocation + reportName, FileMode.Create)) {

fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);

fs.Close();

fs.Dispose();

}

report.Dispose();

processor = null;

result = null;

return new Attachment(reportLocation + reportName);

}

catch (Exception ex) {

throw ex;

}

When I restart the webserver, or kill wp3 I can generate my invoices correctly...

What could this be?

Regards,
Daniel

General Discussions

answered on 03 Mar 2015

1 answer

110 views

Render PDFs inside report

We are able to render image files ( JPEG) using picture box control. Is there a anyway to render PDF inside a report.

Is there a option to use Iframe inside a report?

thanks
- satish

General Discussions

answered on 03 Mar 2015

1 answer

152 views

Telerik Reporting Multivalue Parameters custom datasource

Hello,

I am using Telerik's HTML5 report viewer version 8.2.14.1204.

Is there a way to provide a custom datasource for a Multivalue parameter?

I have read the http://www.telerik.com/help/reporting/designing-reports-parameters-using-multivalue-parameter.html article and understand how to provide the list of available values from a sql query. However, what if I want to provide those values from a custom object like a list of custom models or a enum object?Is there a way to do that?

Thank you.

General Discussions

answered on 02 Mar 2015

2 answers

235 views

Bar Chart (BarSeries) Gradients

In a Graph control using a BarSeries, I know how to control colors of the bars as solid colors, but can't find how to color the bars of the BarSeries as a gradient. I've been searching but nothing seems to address this issue. It's on a Graph control, not a Chart. I'm creating the BarSeries in code.

General Discussions