Telerik Forums
Reporting Forum
3 answers
319 views
I have a report that displays a calculated value in a textbox in a group footer section.  I need to highlight this textbox if its' value is the maximum for the values displayed in this column.

The section of the report is shown in the attached file.

How would I highlight the 16.09% in the Membership in PAL column.

Any help would be appreciated.
Stef
Telerik team
 answered on 09 Mar 2015
3 answers
135 views
Hi,

I have gone through many posts regarding this issue. By reading most of the posts I assumed that this issue has been resolved. 
I am currently using Telerik Reporting Q3 2014 and I am still having this issue when the text is justified. It may be because of the our local language.
When text is justified, it kind of gets reversed.

Language/Font and style details:
Font Name: Faruma (can be downloaded from http://fonts.webtoolhub.com/font-n24647-faruma.aspx)
Culture: dv-MV / dv
Style->TextAlight: Justify


I have attached the screenshots of what is happening for your reference. Is there any fix for this issue? Or am I missing some setting? We have many report developments pending because of this.

Sample text in case you need it: 
ވީމާ،
މިއޮތޯރިޓީއަށް ޗެކުން ފައިސާދައްކަވާ ހުރިހާ ފަރާތްތަކުންވެސް އެފަރާތްތަކުން
ހުށަހަޅުއްވާ ޗެކް ބައުންސް ނުވާނެ ގޮތެއްގެމަތިން އިންތިޒާމުތައް
ހަމަޖެއްސެވުމަށް ދަންނަވަމެވެ. އަދި މިއަދުގެ ނިޔަލަށް މިއޮތޯރިޓީއަށް ބައުންސް
ޗެކަކާ ގުޅިގެން އެއްވެސް ފައިސާއެއްދައްކަވަންޖެހި ނުދައްކައިހުރިނަމަ، އެފައިސާ
ލަސްނުކުރައްވާ ދައްކަވައި ޚަލާޞްކުރެއްވުމަށް އިލްތިމާސްކުރަމެވެ.



Stef
Telerik team
 answered on 06 Mar 2015
2 answers
94 views
Hello, I'm using the standalone report designer and I'm trying to produce a report of a simple DataTable which has columns (FullName, Group).

On my report, I'd like to display the rows in a particular group so that I get this kind of output:
[Report Header]

Header for GroupA
  Fullname1 
  Fullname2

Header for GroupB
   Fullname3
   Fullname4

But I'm only getting confused with the nested groups and subreports features, there must be a simpler way to repeat the items with different filter. Any ideas how to produce this kind of structure?
Petteri
Top achievements
Rank 1
 answered on 06 Mar 2015
3 answers
152 views
Hi Telerik,
   I have a report which has several bookmarks. When a user opens a report viewer, the document map is also displayed (which is ok in my case). However, I could not find a way to expand all bookmarks. I wonder if this could be done in Silverlight Report Viewer.

Thanks,
karlkim
Stef
Telerik team
 answered on 05 Mar 2015
1 answer
1.7K+ 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?
Nasko
Telerik team
 answered on 05 Mar 2015
1 answer
204 views
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.
Stef
Telerik team
 answered on 05 Mar 2015
2 answers
131 views
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


Geoff
Top achievements
Rank 1
 answered on 04 Mar 2015
1 answer
243 views
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.
Stef
Telerik team
 answered on 03 Mar 2015
2 answers
242 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.
Stef
Telerik team
 answered on 03 Mar 2015
11 answers
629 views
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
Stef
Telerik team
 answered on 03 Mar 2015
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?