Telerik Forums
Reporting Forum
3 answers
1.2K+ views
We are evaluating Telerik Reporting for various reporting scenarios.  In one of the meetings it was asked if there was a way to set a textbox of a specific size (cangrow = false, canshrink=false, and the area being used is set appropriately) and have the size of the text automatically determined so that all of the text can be displayed within the defined area at the greatest possible font size.

From what I can tell there is not an easy way to accomplish this but I might be able to define a number of conditional rules to the textbox that check the length of the text and apply an appropriate style.  While this would work I don't think that it is the easy solution they are looking for.  This would be more of a trial and error scenario that could be very time consuming and difficult to maintain.  Is there a better alternative that I am just not seeing.
Nasko
Telerik team
 answered on 16 Aug 2018
2 answers
1.5K+ views

I want to build a System.Data.DataTable in my report code to display some quick summary data. I would like to bind the System.Data.DataTable to a Telerik.Reporting.Table and have the columns and rows automatically generated, but I can not figure out how to get it to work.

I keep finding bits and pieces of code, but nothing that shows me what I need to do from end to end. For example, http://docs.telerik.com/reporting/object-data-source-how-to-bind-to-data-table shows a way of doing the binding, but does not indicate what needs to be done on the design side so it is not working for me.

Does anyone have a quick (and full) example that will point me in the right direction?

Thanks.

Raul
Top achievements
Rank 1
 answered on 15 Aug 2018
1 answer
393 views

Hi,

I am very new to Telerik.  I am trying to add a report that I created, into a reportviewer programatically and I was able to successfully do it with a static "Hello World" report.  Now my problem is I am trying the same but this time with a report requiring several parameters and the report is not displaying in the viewer.

Here is my code below.  I have also attached the output on my browser.  I would appreciate it if anyone can point out whatever I am missing, with some examples.  I am sure it something very silly that I completely missed out.  Thanks.

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        Telerik.ReportViewer.Html5.WebForms.ReportSource rptSource = new Telerik.ReportViewer.Html5.WebForms.ReportSource();
        rptSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.TypeReportSource;
        rptSource.Identifier = typeof(SellThroughSummary).AssemblyQualifiedName;
        rptSource.Parameters.Add("CoName","Beside LLC");
        rptSource.Parameters.Add("BrandDes", "ALL");
        rptSource.Parameters.Add("SeasonDes", "SS18");
        rptSource.Parameters.Add("StoreDes", "TDM-D");
        rptSource.Parameters.Add("GenDes", "ALL");
        rptSource.Parameters.Add("CatDes", "ALL");
        rptSource.Parameters.Add("Descr", "ALL");
        rptSource.Parameters.Add("FromDt", "2018-01-01");
        rptSource.Parameters.Add("ToDt", "2018-01-31");
 
        this.ReportViewer1.ReportSource = rptSource;
 
        Telerik.Reporting.SqlDataSource sqlDataSource = new Telerik.Reporting.SqlDataSource();
        sqlDataSource.ProviderName = "System.Data.SqlClient";
        sqlDataSource.ConnectionString = "ReportLibrary.Properties.Settings.ReportServer";
        sqlDataSource.SelectCommand = "MIS_SellThru";
        sqlDataSource.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure;
        sqlDataSource.Parameters.Add("CoName", System.Data.DbType.String, "Beside LLC");
        sqlDataSource.Parameters.Add("BrandDes", System.Data.DbType.String, "ALL");
        sqlDataSource.Parameters.Add("SeasonDes", System.Data.DbType.String, "SS18");
        sqlDataSource.Parameters.Add("StoreDes", System.Data.DbType.String, "TDM-D");
        sqlDataSource.Parameters.Add("GenDes", System.Data.DbType.String, "ALL");
        sqlDataSource.Parameters.Add("CatDes", System.Data.DbType.String, "ALL");
        sqlDataSource.Parameters.Add("Descr", System.Data.DbType.String, "ALL");
        sqlDataSource.Parameters.Add("FromDt", System.Data.DbType.String, "2018-01-01");
        sqlDataSource.Parameters.Add("ToDt", System.Data.DbType.String, "2018-01-31");
        sqlDataSource.CommandTimeout = 0;
    }       
}

 

 

Silviya
Telerik team
 answered on 15 Aug 2018
3 answers
163 views

Hi,

When post back occur, the report viewer will be blank. What is the way to keep the report displayed after post back.

 

Regards,

Silviya
Telerik team
 answered on 15 Aug 2018
1 answer
1.8K+ views

I am currently evaluating your reporting tool.

I am building a report that has a webservice as the data source. The response object is json. For some reason the report designer does not parse an array within json. The element recentScans is not parsing properly. Attached is an image showing the data explorer. 

 

Here is data result for reference:

{"productItem":{"productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","gtin":"00333831111","gs1DataMatrix":"[01]00333831111[21]0[94]K+j3/SrR+17oIn74G9bWT4aBlU7x0K4I4M86bUEgXmBnvWRfr05zBTJ/L8zHEQX3xxUarCw8l0Rn82GaDkrDJJ5Mn5H4CwbnUmp1YlJmUiismoieHiFnKIbY6fLbFYrcXIIrOXe9aasNXlyaLmrRTkDLXz/ccOvIn34k9E+fmUC1n8lxrjRGlCGeKEEZAXwlNY5Ew43fmNYexV3aNOoqHGt6CqfteXpGqloUSS/d6zPoObK2Dq7KY1+MWSa1gQ0rQ8oAruvmLK2/1bN8iBaHHyd0pUx9/jyJok72K6UR/tpujICA1SpJuvSasA/Cj5gQ8WFZnsTRRgTK/L8ln3SSfQ==[95]e04f713f-ccb5-4b86-9df3-134018e4a8e0","serialNumber":"0","assetType":"Product","dbcEnc":"K+j3/SrR+17oIn74G9bWT4aBlU7x0K4I4M86bUEgXmBnvWRfr05zBTJ/L8zHEQX3xxUarCw8l0Rn82GaDkrDJJ5Mn5H4CwbnUmp1YlJmUiismoieHiFnKIbY6fLbFYrcXIIrOXe9aasNXlyaLmrRTkDLXz/ccOvIn34k9E+fmUC1n8lxrjRGlCGeKEEZAXwlNY5Ew43fmNYexV3aNOoqHGt6CqfteXpGqloUSS/d6zPoObK2Dq7KY1+MWSa1gQ0rQ8oAruvmLK2/1bN8iBaHHyd0pUx9/jyJok72K6UR/tpujICA1SpJuvSasA/Cj5gQ8WFZnsTRRgTK/L8ln3SSfQ==","gs1Map":{"gtin":"00333831111","serialNumber":"0","publicUuid":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","digitalSignature":"K+j3/SrR+17oIn74G9bWT4aBlU7x0K4I4M86bUEgXmBnvWRfr05zBTJ/L8zHEQX3xxUarCw8l0Rn82GaDkrDJJ5Mn5H4CwbnUmp1YlJmUiismoieHiFnKIbY6fLbFYrcXIIrOXe9aasNXlyaLmrRTkDLXz/ccOvIn34k9E+fmUC1n8lxrjRGlCGeKEEZAXwlNY5Ew43fmNYexV3aNOoqHGt6CqfteXpGqloUSS/d6zPoObK2Dq7KY1+MWSa1gQ0rQ8oAruvmLK2/1bN8iBaHHyd0pUx9/jyJok72K6UR/tpujICA1SpJuvSasA/Cj5gQ8WFZnsTRRgTK/L8ln3SSfQ=="},"version":"1","batchRequestId":"3e60fe00-cecc-4c47-8268-282301883a24"},"product":{"productId":"e6e85dee-fcac-40e2-b767-8bb478a527d4","manufacturerId":"909a095e-8fd7-43ed-9bec-13648a8a66da","description":"Color-enhancing shampoo brightens & refreshes blonde, highlighted, and silver hair. ABC Manufacturer Lights Color-Enhancing Shampoo. A protein-enriched conditioning formula. Tones down brassiness on blonde/gray hair. Renews & refreshes faded highlights and ash-toned hair. Removes dull yellow in gray/white hair.","gtin":"00333831111","manufacturerName":"Generic","name":"Shampoo Extreme Color-enhancing","frontImageUrl":"https://connect.1statlas.com/shampoo_front.png","backImageUrl":"https://connect.1statlas.com/shampoo_back.png","properties":{"QRRewardImageUrl":"https://connect.1statlas.com/QR_code_coupon.png","instantRewardImageUrl":"https://connect.1statlas.com/beautysalons_coupon.png"}},"recentScans":[{"productItemLogId":"b5bf052d-7d39-4eb7-a34c-08aad7205319","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533930678199,"action":"scan","latitude":30.266659,"longitude":-81.4395,"lat1000":30267,"lon1000":-81439,"city":"Jacksonville","state":"FL","zip":"32224","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-10 19:51","string":"Jacksonville, FL US"},{"productItemLogId":"f85ed19f-0015-4a3e-af27-541bbbf96369","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533246137932,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:42","string":"Ellsworth, ME US"},{"productItemLogId":"5a2d2dbd-e0ff-44ac-b1ad-3172925d6763","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533245974473,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:39","string":"Ellsworth, ME US"},{"productItemLogId":"0bf837dc-8a1f-4bca-96f5-32a0046c31e7","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533245827826,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:37","string":"Ellsworth, ME US"},{"productItemLogId":"e54d7283-69bb-4407-a601-afffad4016da","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533245819998,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:36","string":"Ellsworth, ME US"},{"productItemLogId":"2996e52e-245a-49e1-9828-c44b6799bdbe","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533245805741,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:36","string":"Ellsworth, ME US"},{"productItemLogId":"3923d1fb-cd51-4e6a-b8ad-d05092a01b3a","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533245167849,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:26","string":"Ellsworth, ME US"},{"productItemLogId":"5525f2bb-1595-4c49-9b2d-140460ac1341","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533245162333,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:26","string":"Ellsworth, ME US"},{"productItemLogId":"892ad3a6-12e6-43b9-b701-57fe2481accd","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533245086592,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:24","string":"Ellsworth, ME US"},{"productItemLogId":"1c564a93-8df1-46c8-8622-3a6745eed1c3","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533244894243,"action":"scan","latitude":44.437504,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:21","string":"Ellsworth, ME US"},{"productItemLogId":"6a6a4cf8-bc56-44a4-8b48-859983b3f1fe","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533244821262,"action":"scan","latitude":44.438324,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:20","string":"Ellsworth, ME US"},{"productItemLogId":"45a14e8c-79bf-4ad7-92de-b7eb9fb80635","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533244443870,"action":"scan","latitude":44.437504,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:14","string":"Ellsworth, ME US"},{"productItemLogId":"34a7e628-7249-473c-abed-bca0d3fc51b3","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533244223276,"action":"scan","latitude":44.437504,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:10","string":"Ellsworth, ME US"},{"productItemLogId":"687e90db-90f2-4c2b-9a5b-6999e33c497d","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533244155810,"action":"scan","latitude":44.437504,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:09","string":"Ellsworth, ME US"},{"productItemLogId":"b133e620-4f6d-42c0-8e6c-3219d78e9082","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533243934151,"action":"scan","latitude":44.437504,"longitude":-68.4032,"lat1000":44438,"lon1000":-68403,"city":"Ellsworth","state":"ME","zip":"04605","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-02 21:05","string":"Ellsworth, ME US"},{"productItemLogId":"2b83c288-6c32-4dff-910b-1a0e574e0b44","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533138505588,"action":"scan","latitude":30.267235,"longitude":-81.43838,"lat1000":30267,"lon1000":-81438,"city":"Jacksonville","state":"FL","zip":"32224","hourDistance":0.0,"dayDistance":0.22,"timeOfLogString":"2018-08-01 15:48","string":"Jacksonville, FL US"},{"productItemLogId":"e6e8f13b-66dd-4ecc-b684-378632f6cdf1","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533132242447,"action":"scan","latitude":30.266901,"longitude":-81.43961,"lat1000":30267,"lon1000":-81440,"city":"Jacksonville","state":"FL","zip":"32224","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-01 14:04","string":"Jacksonville, FL US"},{"productItemLogId":"af2c2d66-c772-4545-accb-490133cb50b8","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533132224903,"action":"scan","latitude":30.266901,"longitude":-81.43961,"lat1000":30267,"lon1000":-81440,"city":"Jacksonville","state":"FL","zip":"32224","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-01 14:03","string":"Jacksonville, FL US"},{"productItemLogId":"0544a50c-dd7c-4990-baf0-9cdf753941bf","productItemId":"e04f713f-ccb5-4b86-9df3-134018e4a8e0","timeOfLog":1533131832783,"action":"scan","latitude":30.2669,"longitude":-81.43962,"lat1000":30267,"lon1000":-81440,"city":"Jacksonville","state":"FL","zip":"32224","hourDistance":0.0,"dayDistance":0.0,"timeOfLogString":"2018-08-01 13:57","string":"Jacksonville, FL US"}],"success":true,"recentScanCount":19}

Nasko
Telerik team
 answered on 15 Aug 2018
1 answer
249 views

We are interested to develop a reporting solution with following details:

  • Database should be Cloud DB Service (Google Cloud MySQL Database)
  • Development Tool should be ASP.NET Core 2.1 Web API
  • Application will be deployed on Cloud App Service (Google Cloud App Engine - GCE )
  • We may need reports in PDF and Excel format.

 

Can we use Telerik Reporting? If not then kindly suggest solution (We can consider to develop reporting services in Full .NET Framework but it will be deployed on GCE).

 

Thanks and Regards,

Nasko
Telerik team
 answered on 15 Aug 2018
4 answers
804 views
I'm using a stored procedure with 3 parameters for my report. When I configured my SqlDataSource, the data returned by the 3 parameters was correct, however the report does not change when I preview with different values. What am I missing?

Tom
Raul
Top achievements
Rank 1
 answered on 14 Aug 2018
1 answer
132 views

 We are using the reporting tool to create dynamic reports/bills.

 

We have an automated system that creates bills and emails them every night with no issues.

 

The issue is when a user needs to manually generate the bill or any other report in IE/chrome/FF.  Randomly all reports (We have about 20 different ones)  start having caching issues and when any report generates it will have missing letters, random boxes, etc....

 

We perform an IISreset and it resolves it temporarily. 

 

When they click generate we have the URL creating a unique URL and also have the report engine not caching.

 

Any ideas as to how to solve this caching issue?

 

Silviya
Telerik team
 answered on 14 Aug 2018
1 answer
268 views

Hi, I'm too newer in Telerik Reporting, and I not have idea to when make a ReportViewer or Telerik.Reporting.Report, I have an example works fine, is a report with 2 parameter, and I can see it on screen or sent to printer, now I want to sent it to user mail, without interaction of user, how I can do this? I'm work in WPF with VS2013,  annexed my code:

 

in XAML:
<tr:ReportViewer Name="ReportViewer1" Width="800" Height="500" >
    <tr:ReportViewer.ReportSource>
        <telerikReporting:TypeReportSource TypeName="ReportLibrary, ReportLibrary" />
    </tr:ReportViewer.ReportSource>
</tr:ReportViewer>
in .cs:
var TRS = new TypeReportSource();
TRS.TypeName = typeof(pgoRelacionCobranza).AssemblyQualifiedName;
ReportViewer1.ReportSource = TRS;

FechaIni = dpFechaIni.SelectedDate.Value.Day.ToString() +"/" + dpFechaIni.SelectedDate.Value.Month.ToString() + "/" + dpFechaIni.SelectedDate.Value.Year.ToString();
FechaFin = dpFechaFin.SelectedDate.Value.Day.ToString() + "/" + dpFechaFin.SelectedDate.Value.Month.ToString() + "/" + dpFechaFin.SelectedDate.Value.Year.ToString();
               
var TRS = new TypeReportSource();
TRS.TypeName = typeof(pgoRelacionCobranza).AssemblyQualifiedName;
TRS.Parameters.Add(new Telerik.Reporting.Parameter("pFechaIni", FechaIni));
TRS.Parameters.Add(new Telerik.Reporting.Parameter("pFechaFin", FechaFin));
ReportViewer1.ReportSource = TRS;
if (rbPantalla.IsChecked == true)
{
    ReportViewer1.RefreshReport();
    stkReportView.Visibility = System.Windows.Visibility.Visible;
}
else
{
    System.Windows.Forms.PrintDialog printDlg = new System.Windows.Forms.PrintDialog();
    printDlg.AllowSomePages = true;
    printDlg.AllowCurrentPage = false;
    printDlg.UseEXDialog = true;
    DialogResult result = printDlg.ShowDialog();
    // If the result is OK then print the document.
    if (result == DialogResult.OK)
    {
        ReportProcessor reportProcessor = new ReportProcessor();
        reportProcessor.PrintReport(TRS, printDlg.PrinterSettings);
    }
}

Silviya
Telerik team
 answered on 14 Aug 2018
2 answers
277 views
Hi,

I have a simple report that runs from a stored procedure. The stored procedure returns 50 rows to the detail section via a table. My issue is that the report is generating 67 pages, when it should in fact be only two. I have checked the stored procedure and the output is 50 rows. The report seems to be repeating the same data over and over again. This issue occurs both in the designer and the report viewer. I am user the Q2 2010 version of Telerik reporting.

Appreciate any help,


Andy.
Willy
Top achievements
Rank 1
 answered on 13 Aug 2018
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?