Questions on Reporting Forum

2 answers

205 views

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

609 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

102 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

150 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

223 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

282 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

192 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

108 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

154 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

997 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