My reports that I am using in an WPF application just to print directly to a printer have some issues after the upgrade. We also had an issues when we upgraded last year.

Here is where the report is called

      string orderIds = "153461,153567,153843,153845,153872,153942,153966,153985,154210,154252,154298,154363,154382,154411,154431,154437,154463,154471,154521,154538,154556,154560,154631,154650,154686,154687";  
var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

      var typeReportSource = new Telerik.Reporting.TypeReportSource();
      typeReportSource.TypeName = typeof(Accounting.Reports.RptPostedDeposits).AssemblyQualifiedName;
      typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrderNumbers", orderIds));
      var px = new System.Drawing.Printing.PrinterSettings();
      reportProcessor.PrintReport(typeReportSource, px);

 

 

Then in my Needs_Datasource event of the report I have something like

      if (this.ReportParameters[0].Value.ToString() != "")
      {
        string sqlQuery = "Select O.OrderID, Case When D.PayorName = '' Then CAL.SubAccountName Else " +
          "SUBSTRING(CAL.SubAccountName, 0, 7) + '-' + D.PayorName End as Customer, D.EntryDate, D.PaymentNumber, D.PaymentTypeID, " +
          "D.TotalDeposit, D.AmountAppliedToInvoice, O.GrandTotal, D.PostedToCyma, ISNULL(O.PostedDate, ISNULL(O.ShipDate, GETDATE())) as PostedDate " +
        "From FCMDB.dbo.FcoOrders O " +
        "JOIN FCMDB.dbo.CustAccountLocations CAL ON CAL.AccountLocationsID = o.AccountLocationID " +
        "JOIN FCMDB.dbo.AcctDeposits D ON D.OrderID = O.OrderID " +
        "Where O.OrderID IN (" + ReportParameters[0].Value + ")";
        SqlConnection cn = new SqlConnection(MyConnection);
        cn.Open();
        SqlCommand cmdGet = new SqlCommand(sqlQuery, cn);
        DataTable dtGet = new DataTable();
        dtGet.Load(cmdGet.ExecuteReader());
        cmdGet.Dispose();
        cn.Dispose();

//This line we changed in 2016 because just setting the this.datasource would no longer reference the current report
        (sender as Telerik.Reporting.Processing.Report).DataSource = dtGet;
        //this.DataSource = dtGet;
      }

 

Now I need to access the parameter through the sender object. If I leave it the way it is currently the parameter is blank. Is this something that has been done intentionally? If so why isn't an email or something sent out about it or adding it into the whats new? 

Hello

We use the Legacy ASP.NET Reportviewer (Q1 2015).

We are experiencing problems with low memory on the server due to large amount of reportviews/high user sessiontimeout.

Is it possible to set a ClientSessionTimeout for the legacy ASP.NET reportviewer? 
If not, is it possible to disable the reporting cache?

We do not wish to migrate to the HTML5 viewer just yet.

Regards
Mark

Hi,

Having issues trying to remove time formatting from the x-axis 'category label format. Tried several formats but don't see a change on the outputted report - always showing my category dates as date WITH the time. STUPID! have already spent too much time on this & will take at least another day to get an answer, assuming no further info is required.

​

Hi,

I created a report with table, in output the report is showing a line after table which is not expected, i tried to remove the line by setting the bottom edge of table "none" in detail sectionand and also by setting the 

top edge of page footer section= "None" , but by using both the way i am not getting my expected output on the report.

please refer the attached image.

Hi everyone.

Can I export the report on the server programmatically?
I've read a KB below. It could export the report to pdf on client side.
http://www.telerik.com/support/kb/reporting/styling-and-formatting-reports/details/exporting-a-report-to-pdf-programmatically

My goal is sending an email with an attachment of pdf exported by a report programmatically.

Thanks in advance.

Hi,

I'm implemented a ReportViewer HTML5 on my page, but some clients the report trigger a error.

 

 

I found this post with same error but the user not post a solution: Getting Error Client with ID - 'XXXXXX-XXXX' not found. Expired 

I appreciate your prompt help

 

PD: I can't upload Screenshots for security restrictions on my work

 

Best regards

In my cross tab table, i want to apply bottom border at the end of the group and not for each row within in the group. Can someone please guide me how to achieve this? If i have to use conditional formatting, than what shall be the condition to identify if the the last row of a group

Hello,

 

I am working on a project that using telerik call web API, but it seems like the ReportsController does not send cookie in request.

As figure 1, there is no cookie when i tried to call api/reports/client, whereas cookie appears when call another web API(figure 2).

How to solve this problem?

 

Thank you.

Hello Telerik Team,
i'm evaluating your great reporting product, but i have some little problems and i hope to find some help here.

I've draged a PictureBox into my report (detail section) and made the following Expression to load a harddrive stored picture into it:


This is working perfectly as long as the picture with the filname "articleNo+.jpg" exists in the given harddrive folder. If there isn't a picture for the specific article (which is a common situation for our needs), i get the following error in the report output (for every not existing picture in a list with 5000 articles ...): 
"An error has occured while processing PictureBox "pictureBox1': The File "C:\ProductPictures\ART00001.jpg" could not be found."

Is there a way to supress the error message if the picture doesn't exists? We don't need and want this error message =)

Best Regards from Germany
Hans

Hi,

I have the following:
Report (report_product)
SubReport 1 (SubReportOperation)
SubReport in SubReportOperation (SubReportPreparation)

Report_product
 ...
 Header and general info for report product
 ...
 SubReportOperation line 1
 SubReportOperation line 2
         SubReportPreparation line 1
         SubReportPreparation line 2
         SubReportPreparation line n
 SubReportOperation line 3
 SubReportOperation line 4
         SubReportPreparation line 1
         SubReportPreparation line 2
 SubReportOperation line 5
 SubReportOperation line n
The datasource for the SubReportPreparation depend on the ID of SubReportOperation DataObject)
I try this in the SubReportOperation report, DataBinding of the SubReportPreparation but that doesn't work
        private void SubReportPrepa_ItemDataBinding(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.SubReport report = (Telerik.Reporting.Processing.SubReport)sender;
            SubReportPreparation subReport_Preparation = new SubReportPreparation(_connectionStringName);
            Telerik.Reporting.InstanceReportSource irs_subReport_Preparation = new Telerik.Reporting.InstanceReportSource();
            irs_subReport_Preparation.Parameters.Add(new Telerik.Reporting.Parameter("OF_OPERATION_ID", report.DataObject["ID"]));
            irs_subReport_Preparation.ReportDocument = subReport_Preparation;
            this.subReport_preparation.ReportSource = irs_subReport_Preparation;
        }

How must i do PLEASE ?

THANKS