I had problems trying to print when I updated the Telerik dlls from 2008. There was an issue discussed in some threads regarding the orientation in
http://www.telerik.com/forums/printing-report-on-label-printer-wrong-orientation in which Stephan states
"Please download and test the latest available Telerik Reporting Q2 2014 SP1 version 8.1.14.804, where we included modifications in the print mechanism for WPF and WinForms ReportViewer controls."
I am struggling with he latest version of the software to make this work. Please help
Here is a snippet of vb which worked up to 2013
Dim rpt As New CLCertReports.Assetlabel1(mID, mPartnerID, mIdent, mSerial)
Dim mInstanceReportSource As New Telerik.Reporting.InstanceReportSource()
mInstanceReportSource.ReportDocument = rpt
Dim printerSettings As New System.Drawing.Printing.PrinterSettings()
printerSettings.PrinterName = System.Configuration.ConfigurationManager.AppSettings("LabelPrinter1") '"TECB-452"
Dim printController As System.Drawing.Printing.PrintController = New System.Drawing.Printing.StandardPrintController()
Dim reportProcessor As Telerik.Reporting.Processing.ReportProcessor = New Telerik.Reporting.Processing.ReportProcessor()
reportProcessor.PrintController = printController
Me.ReportViewer1.ReportSource = mInstanceReportSource
reportProcessor.PrintReport(mInstanceReportSource, printerSettings)
The label renders on the ReportViewer fine and if printed with the dialogue prints fine. However, it still tries to print portrait over two labels in code behind and if i change the .ReportDocument.PageSettings.Landscape settings then it clips the label and does not print properly from the ReportViewer.
What am I doing wrong and how do change the above code to make this work
Many thanks
Hi Everyone
I recently registered for the free trail, wanting to use the product for report automation. After creating the template in the standalone report designer, I want to export grammatically. However i get following error on the unpack method:
Cannot read a document with the specified schema: http://schemas.telerik.com/reporting/2012/4.1.
You might be using an older version of the product.
Not sure where to go from here.
using
(var sourceStream = System.IO.File.OpenRead(Server.MapPath(Url.Content(
"~/Forms/DebitForm.trdp"
))))
{
var report = reportPackager.Unpackage(sourceStream);
}
Is there a way to include the Selected Values from a Multi-Value parameter in the report, when just using the stand-alone designer?
I have seen posts that discuss creating user functions in Visual Studio, but no solution for those of us who need to create reports using the stand-alone designer.
Is this possible? I am using Version 10.2.16.1025
Thanks,
Cecilia Daniels
I keep getting "missing or invalid parameter value" "please input valid data for all parameters" when previewing my report. I've set up a SqlDataSource with the "Configure.." wizard. I have two parameters, both of type int/integer/Int32. When I run the "Excecute query" in the Configure-wizard I get the expected result in the results list. But, when I preview the report I get "missing or invalid parameter value" "please input valid data for all parameters"...
I've checked every parameter mapping in the report and everything looks ok.
I've attached the report causing this.
What could cause this?
//Thomas
I have a table called Components that is hierarchical; each item has a ParentId that is either NULL if it's a top-level item, or populated with the Id of its parent Component. I also have a table called Requirements with an OwningComponentId field, which connects each one to a Component.
Unfortunately, there is no limit to how deep the tree can go, nor is there a limit to how many siblings an item can have.
My report needs to be able to select a Component (ideally any component, not just top-level) as a parameter, and display aggregates for it as well as each of its children, on down to the leaves. One thing I do know is that only the leaves (Component with no children) will actually have Requirements associated with them. For the rows of the report showing the leaves, it should show the aggregates for that leaf. For each parent row, it should show the aggregates for all that parent's children.
I've seen some other threads, such as http://www.telerik.com/forums/cross-tab-report-with-a-self-referencing-hierarchy . I was able to get that example to work. However, that one does not show any aggregates or detail rows for each item, and I can't seem to figure out how to add those in in the way I need.
At one point I had a query that returned all the rows with aggregate data for the leaves (still didn't have aggregates for parents) computed directly on the database, but for some reason the report would repeat the entire set of data once for each of my Components. If there were say 125 components in the hierarchy, then the entire table was repeated 125 times. I also realized from monitoring the db that for some reason the report was calling the same stored proc on the db 126 times (once and then once again for each component). I have a feeling I had something wrong with my grouping but couldn't figure it out. Is there some logic in there that says to call the stored proc once to get the Group items, and then call it again for each group? I saw no such logic in my DataSource definition (which by the way is a SqlDataSource calling a Stored Proc that I wrote).
I would greatly appreciate any help you can give on how to do this. I've been working on this for a few weeks now with little progress, and am at the end of my rope!
Chris
Hi there,
I have a report showing a publisher/supplier relationship. The master is a simple table report grouped by publisher. There is a drill down on the table, which then shows a breakdown grouped by supplier. Both master and detail report tables have the same columns.
Want I want to do is have a toggle on the master report that can hide particular columns. I have achieved this on the master report by having a textbox with a toggle visibility action - if it is , certain columns disappear, but of course, if the user drills down to the supplier details, the columns are still displayed in the sub-report.
Is there any way of setting up a toggle visibility option that will affect both the master and detail reports?
Kind Regards,
Martin.
Hey guys,
I'm trying to create a single report, which shows multiple reports. The idea is, I have an InvoiceReport at the moment, and I built a Scheduler, that needs to generate all the reports of the month. So in this Scheduler I render all the reports and attach them to a bookReport, then I create the file.
We have to render around 3000-5000 reports into a file, but when using bookReport, you have to render each report individually first and then attach to the bookReport, and it takes 1-2 seconds to render each report individually. The data sources inside that report are really fast, so the problem becomes the render.
That's why I need to create a single report to render all the InvoiceReport without using bookReport. I found the SubReport control, but it doesn't render the Header/Footer.
Does anyone know how to solve this problem? To render many reports inside a "master report" without using bookReport.
Thanks
I've created a Telerik report and my datasource is pointing to a stored procedure in sql server. However, when executing the report I get the following error:
Procedure or function '​ABC123' expects parameter '@CustomerLocationID', which was not supplied.​
When going through the "Configure" option for the datasource, the correct report parameters are mapped to the stored procedure parameters.
When testing the stored procedure call through the "Configure" option, the resultset is returned, as expected, but when running the report through the application, I get the above error. See the attached images for parameter mapping.
Thanks.
TLDR - Is there a way to set the minimum number of pages for a report to print on, just so that the page header and footer will print a known number of times?
More detail: I've got an issue in that I have two distinct sets of data to integrate into one report. One is a list of invoice lines, and one is a list of shipping labels, both to be printed on the same page(s).
The simplest solution I have that is almost workable is to put a picture box in the page footer. I have set the image URL to: = ReportItem.Report.ItemDefinition.Transaction.OrderNumber + "-" + PageNumber + ".png". If there is only one shipping label and one page worth of transaction lines, then it will work fine. If by some stroke of luck there are two shipping labels and two pages of transaction lines, then it will also work. In most other cases, the user will get one shipping label and will have to open up the shipping software to "reprint" the other labels. This isn't the worst thing in the world, because the vast majority of the orders they ship have exactly one shipping label, and just combining the shipping label and invoice/packing slip onto one page is a huge improvement in their workflow. Is there, by chance, a way to specify a minimum number of pages for the report? If so, I could programmatically set the number of pages equal to the number of shipping labels. There will be some pages with no invoice lines printed, but the report would happily reprint the page header and footer and it would work perfectly for my purposes.
Alternately, if someone would like to enlighten me on the actual proper way to do this (a report with two sets of data with different page count requirements), I'd be happy to hear it. However, it would be much easier if I could just set the minimum number of pages...