Questions on Reporting Forum

11 answers

641 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

117 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

163 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

261 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

answered on 02 Mar 2015

6 answers

327 views

ef5.0 DBset

Hello.
Do you have a plan to support ef5.0 Dbset in reporting Q3 2013?
If so, when are you going to support it?

I don't want this link : http://blogs.telerik.com/careypayette/posts/13-07-30/try-out-new-entity-framework-support-in-telerik-reporting-and-earn-rewards and openacess.

General Discussions

answered on 01 Mar 2015

4 answers

244 views

Can View DOCX & XLSX export option locally but not when uploaded to Azure

Can view all report export options locally, but after uploading to Azure Cloud instance I lose many including DOCX and XLSX.

Copy Local = True on all references.
<Telerik.Reporting><Extensions><Render> all set to visible=true.

Version=8.2.14.1204

Thank you.

General Discussions

answered on 28 Feb 2015

9 answers

116 views

Reporting trial and VS2013 express for web?

Hi,

I am trying to installl Reporting Q3 2014 Trial. I have VS2013 Express for WEB installed. In the reporting installer all the "Visual studio xxxx support" checks are inactive. I can only select "Local Demos" and nothing more.

Is there any way to install VS2013 support on VS2013 Express for WEB? If not, how can I add an "Object Data Source" to the new report I am creating in the report designer?

Thanks.

General Discussions

answered on 27 Feb 2015

1 answer

183 views

Showing detail rows in a crosstab report?

Hi all. I am trying to create a crosstab report that groups categories and titles, while showing details of purchases within those titles by clients. I am looking to building something similar to what is shown in the "What I Need" image. What I have come up with so far is shown in the "What I have" image.

There are more detail records than what is showing and that is the problem. How do I go about showing the detail records as rows going down under the title groupings and not across the top as the original crosstab wizard created for me (as shown in the "Not what I need image")? Is this even possible?

I'm okay if the report is a straight forward tabular report. I have tons of those in the project, and I have a couple of cross tab reports, but this one is escaping me for some reason.

Thanks in advance for any help you can offer!!

General Discussions

answered on 27 Feb 2015

2 answers

1.1K+ views

How to identify last item in data source for detail section

I have a report that is bound to a list of business objects, where the Detail section is repeated once for each business object in the list. The Detail section has a divider line at the bottom that helps to visually distinguish each section. I don't want that divider line to show up after the very last section though.

I've had trouble finding out how to implement this. It looks like in the past I could have used a Conditional Formatting on the divider line (it's actually a Shape inside of a Panel, and I want to just hide the Panel). I could have had an expression that said if =RowNumber() = =Count(RowNumber()) then set the panel invisible, but this doesn't work anymore because it was broken when some Scope features were added.

I've tried the ItemDataBinding event on the Detail section, but I can't see how I can get the current row number or the total number of rows in the data source. All I need to know is if the current row is the last row, and then I could use this event to hide the divider line.

What's the correct way to go about this?

General Discussions

answered on 27 Feb 2015

4 answers

147 views

Printing from report viewer hangs in virtual machine

I have an issue where I can't print from the report viewer in my Virtual Machine. I can print from this machine with out issues using other programs. This issue does not show up anywhere else either. I have my application installed on various other pure windows machines and it prints fine never hangs up.

I don't get any debug info it just stalls with the "Printing page 1 of report" dialog.

General Discussions

answered on 27 Feb 2015