Telerik Forums
Reporting Forum
4 answers
351 views

My company recently converted to telerik for our reports and one of our products that's used to create checks. We have seen two major issues that I'm baffled as to the cause or how to fix it. 

1. We're experiencing an issue on one of our users using Windows 8. When she logs on to her particular windows logon and then to any user for our product her checks are shrinking on the page. Another user can log on that same computer and they don't see the issue(though if they log on to our product on the other user's window logon they do). All the fonts appear smaller and there's a great deal of white space on the right side. (It's not just adding extra white space with a normal sized check)

I attached what our user is seeing as well as what is the normal appearance(obviously very blurred out for security reasons).

2. We have a check made of the same detail section printed 4 times. When printing to a HP Laserjet 2430, each detail is shifting down slightly. I show a green box to show that it seems to be becoming diagonal which is especially odd.

Any ideas or insights into possible causes?

 

 

Lori
Top achievements
Rank 1
 answered on 06 Jan 2016
1 answer
866 views

Hi,

I'm trying to create a report programatically in C# using ObjectDataSource.

I've added a report parameter to the Report, and the parameter bar shows up on the right hand side.

I'm trying to pass the parameter from the report filer to my GetData class when the user clicks on "Preview" button. Can someone please help?

 

We first used the VS Telerik reporting wizard to create a Table report.

            this.RLDS.DataMember = "GetData";
            this.RLDS.DataSource = typeof(Test.TelerikReportLibrary.GenericTableDataSource);

            this.RLDS.Parameters.Add(
                            new Telerik.Reporting.ObjectDataSourceParameter("location", typeof(string), null));

namespace Test.TelerikReportLibrary
{
    [DataObject]
    public class GenericTableDataSource
    {
        [DataObjectMethod(DataObjectMethodType.Select)]
        public static List<AssetReportLine> GetData(string location) {
            var resultAssetList = new List<AssetReportLine>();
            // Get data from database
            return resultAssetList;
        }
    }
}

 

We tried to add a parameter so that it displays on the right hand side of the report.
var reportParameter1 = new Telerik.Reporting.ReportParameter();
reportParameter1.Name = "location";
reportParameter1.Text = "Enter Value for Parameter1";
reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer;
reportParameter1.AllowBlank = false;
reportParameter1.AllowNull = false;
reportParameter1.Value = "=10";
reportParameter1.Visible = true;
this.Report.ReportParameters.Add(reportParameter1);

Stef
Telerik team
 answered on 06 Jan 2016
2 answers
514 views

Hi guys,

I am glad to see that Telerik has released a new version of report viewer based on HTML 5. However, I hit a technical issue when I try to start using new version of Telerik report viewer.

Okay, let me talk about what I want to do with Telerik.

1. On back-end, I have built a custom reporting service in WCF, which will be implementing advanced business logic. You can think that I will do below steps on back-end in general. 

     a. Bind data to report - Receive UI request and load proper data for a report. I assume that report is a very basic report which doesn't has any sub-report, groups and other advanced features. 

     b. Render a report - Contact Telerik reporting engine to render a report. 

     c. Response - Send result to UI 

2. On front-end, I have built a MVC web project for displaying reports. But I don't want to use ASPX to display reports. Okay,instead of using aspx and Iframe, I want to use new version of HTML 5 report viewer and RESTFUL service (Personally, I don't like Teleirk restful service but I have to use it if there is no way to use HTML 5 report viewer without restful service). My questions shows as below:

 

Q1: After I sent the report result to UI, how to feed the reportSourceData or we say, report object, to HTML5 report viewer? In an old way, I used aspx page to do the data binding and displaying a report. Is there any small demo or steps to show me how to use new report viewer to display report without using Telerik restful service? If answer is no, please look at next question.

 

Q2: In my opinion, Telerik restful service seems like a build-in reporting engine which could be a black box. I don't have full control on restful service or we say its not easy to get full control on restful service. I think restful service may does similar things like my backend service does. If so, I believe there is a way to feed a report result to html 5 report viewer ? Can you please send me demo code to show me how to do that pls?

 

Thank you.

F9

 

 

Hinata
Top achievements
Rank 1
 answered on 06 Jan 2016
2 answers
275 views

I have a simple line chart report, and what I'd like to do is split the data across multiple charts.

I'm using an ObjectDataSource which returns a list of class objects with relevant fields: SampleTime, Value. 

 The chart uses SampleTime as the category and Value as value.

The samples come in at 30 minute intervals, but the charts need to be instanced by date; so two days of data would be 96 data points which would split over two charts. The range of days in the data is arbitrary so it might be 2 days data or it might be 31.

The best I've managed so far is to split the data into different coloured lines on the one chart by adding SampleTime.Date as a series group, but I feel there must be a way to have an arbitrary number of charts on the report, one for each day. In an ideal world the individual charts would populate multiple charts to one report section.

Anyone have any insight or examples to share? I've included an image below that may clarify what I'm looking for.

Tristan
Top achievements
Rank 1
 answered on 04 Jan 2016
7 answers
686 views
Hello, I have a report that I am exporting to Excel, and everything looks great except for one thing. When the text in a cell is somewhat lengthy, the last line or two get cut off because the cell is not big enough to fit it all. The report looks fine when rendered and when exporting to PDF, but for some reason Excel is not fitting the text to the cells correctly. Is there something I can do to make the text fit? I am using 2009 Q2 SP1.
Stef
Telerik team
 answered on 04 Jan 2016
11 answers
581 views
Hi,

I have 2 issues when I am using Telerik Report and export to Excel.
(Everything is good in Report viewer, but after it's exported to excel, there are some problems.)

1, After the report is exported to Excel, there is no grid lines in excel, the whole back ground is white, I did not set any border in report, how can I turn on the default grid line in Excel, not make them be white background. (Our report is not full of table, so I did not set any border in my report, it will looks strange in exported Excel, parts of the report has grid line, and others don't. So I think the default Excel grid line will solve my problem, how can I get it?)

2, In the cell of table, I set it to CanGrow=True, CanShrink=False, Multiline=True, TextWrap=True, it works fine in Report Viewer, The long text string will be turned into another line. But after export to excel, the row height is not enough, it will make half of text be cut off in second line, the user have to manually adjust the hight of row to see the whole text. I do see some of threads discussed this issue, it's caused by line spacing in Excel, I want to know is there any alternative solution I can use to solve this problem, because it looks really not good.

I appreciated any help from you.
Thank you very much.
Stef
Telerik team
 answered on 04 Jan 2016
2 answers
98 views

I'm currently using the legacy reportviewer and have modified the session state to use stateserver. All reports were running fine just prior to this update. After this update, for most of my reports, I've been able to just add the needdatasource event within the report itemdatabinding event and the results work fairly well (as long as they're serializable).

 

I have a report with a graph in it, which has its own needdatasource. I've performed the same operation with it default constructor > report itemdatabinding in which I find the graph item and add the needdatasource event > needdatasource event runs with all appropriate parameters passed in. I don't receive an error, but no results are displayed on the graph. Within the needdatasource the parameters of the sqldatasource are updated and applied to the graphs datasource.

 

I've added in a separate graph itemdatabinding event after the report binding, but the results are the same with no data displayed. All of the events, default constructor > report databinding > graph databinding > graph needdatasource run and seem to apply the parameters as needed.

 

Any idea of what the problem could be or at least how I can debug this issue?

Nasko
Telerik team
 answered on 01 Jan 2016
4 answers
246 views

Is there a way to do something like the image?

 

thanks in advance

Aplicativos
Top achievements
Rank 1
 answered on 30 Dec 2015
1 answer
189 views

I want call PROCEDURE for trdx reports  

 <Report DataSourceName="ET_OMS_v4" Width="6.46in" Name="FSBOInvoice" SnapGridSize="0.1in"xmlns="http://schemas.telerik.com/reporting/2012/3">
  <DataSources>
    <SqlDataSource ConnectionString="ETOMSv4" SelectCommand="dbo.ETSP_FSBO_GET_INVOICES_FOR_LISTING"SelectCommandType="StoredProcedure" Name="ET_OMS_v4">
      <Parameters>
        <SqlDataSourceParameter DbType="Int64" Name="@invoiceID" />
      </Parameters>
      <DefaultValues>
        <SqlDataSourceParameter DbType="Int64" Name="@invoiceID">
          <Value>
            <String>21</String>
          </Value>
        </SqlDataSourceParameter>
      </DefaultValues>
    </SqlDataSource>
    <ObjectDataSource Name="objectDataSource1" />
    <EntityDataSource Name="entityDataSource1" />
  </DataSources>

you help me

thank a lots

Nasko
Telerik team
 answered on 30 Dec 2015
1 answer
297 views

I'm trying to set up a report to list different numbers off, ill use a fake model to show.

public class FakeModel

{

      public string Name {get; set;}

      public int Age {get; set;}

      public IEnumerable<ParentModel> Parents {get; set;}

}

 

public class ParentModel

{

      public int Age {get; set;}

      public string JobName {get; set;}

      public DateTime DateOfBirth {get; set;}

}

 

My problem is I'm using FakeModel as my DataSource and it works fine for the first part of my report for the information I need. Then later in the report I need to use the list of ParentModels to display all the information listed and when I try to use the normal way for selecting values with the ... button, it shows a option to expand the list but I click and nothing changes except the button going away. The goal is to display the list of ParentModels on my report.

 

I'm using the Telerik Report Q3 2015 Wizard.

Katia
Telerik team
 answered on 29 Dec 2015
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?