Telerik Forums
Reporting Forum
3 answers
113 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.7K+ 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
202 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
720 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
108 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
210 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
228 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
1 answer
854 views

I would like to add a custom button to the HTML 5 Report Viewer's toolbar.  Is there an example of how to accomplish this? 

So far I have managed to create a functional custom button by adding a link to the template with a new data-command attribute, and then adding a new command to the report viewer object (see below).  

This works, and my custom command's exec() function is called when the button is clicked and the enabled() method returns true.  However, the issue I'm having is that I do not know how to get the new button to appear in a disabled state.  I expected the button to appear disabled when the emailReport command's enabled() call returns false, but this is not the case.  Am I going about this the right way, or is there a better way to accomplish this? 

Thanks!

<a title="Email Report" href="#" data-command="telerik_ReportViewer_emailReport"><i class="fa fa-envelope"></i>

 
this.reportViewer.commands.emailReport =  {
        enabled: () => {
            // todo
            return false;
        },
        checked: () => {
            // todo
            return false;
        },
        exec: () => {
            // todo
        },
    };

 

Silviya
Telerik team
 answered on 13 Aug 2018
0 answers
119 views

Hi,

We are using Telerik reporting to generate "Code128" barcode. If we use actual size to generate the barcode, we are able to scan it. If we are trying to reduce the size of barcode using "Module" property, it is not scannable.

 

Veeru
Top achievements
Rank 1
 asked on 13 Aug 2018
1 answer
108 views

Hi,

Is it possible to change HTML 5 report viewer loading yellow box to custome message. and if Yes, Please can you provide an example of making it read for example.

Hope to hear from some soon.

Regards,

Silviya
Telerik team
 answered on 13 Aug 2018
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Iron
Iron
Andrey
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?