Telerik Forums
Reporting Forum
8 answers
261 views
Hello team,

i try to print a Reporbook from 3 trays under C# in one printjob. Such as
  • page 1 <- tray 2
  • page 2 <- tray 3
  • page 3 <- tray 4
Is it possible?

I can print them all from custom trays in different jobs without problems, but i need them all in one printjob because the printer have a stitcher to bound the document. How can i assign the printjob with more then one printerSettings?

My way now:
var reportProcessor = new ReportProcessor(); 
 
var printerSettings = new PrinterSettings { PrinterName = printer }; 
 
Report1 report1 = new Report1(); 
FillReport1(); 
 
Report2 report2 = new Report2(); 
FillReport2(); 
 
Report3 report3 = new Report3(); 
FillReport3(); 
 
ReportBook reportBook = new ReportBook(); 
 
reportBook.Reports.Add(report1); 
reportBook.Reports.Add(report2); 
reportBook.Reports.Add(report3); 
 
reportProcessor.PrintReport(reportBook, printerSettings); 
 

To print the reportbook from custom tray i can
printerSettings.DefaultPageSettings.PaperSource = printerSettings.PaperSources[7]; 
How can i get it from differen trays?

Hope someone can help me.


RPI Bumper to Bumper Auto Parts
Top achievements
Rank 2
 answered on 05 Oct 2016
1 answer
147 views

I need to format some text with codition, but it fails

{IIf(Fields.UiModel.IsCompany = "Yes", =Format("{0} {1}", Fields.UiModel Fields.UiModel.Customer.Firstname,Fields.UiModel.Customer.Surname), Fields.UiModel.Customer.Companyname)}

 

The problem is in the format, but i can not get this to work...

I need some expert on this

I get this error

An error has occurred while processing Report 'Factuur':
textBox18.Value expression [{IIf(Fields.UiModel.IsCompany = "Yes", =Format("{0} {1}", Fields.UiModel
Fields.UiModel.Customer.Firstname,Fields.UiModel.Customer.Surname), Fields.UiModel.Customer.Companyname)}] is not valid:
Error evaluating embedded expressions: Unexpected token inside an expression at index 57

Stef
Telerik team
 answered on 05 Oct 2016
11 answers
553 views

I've created a report in Designer, and am trying to pass the data within the ASPX code behind to the ReportViewer. This page acts as if this event exists, but my ReportViewer object doesn't have it listed in intellisense. The ReportViewer object doesn't even seem to have a DataSource object even though I see it mentioned here.

The only details that I can tell apply to what I'm using are How to: Set ReportSource for Report Viewers and ReportViewer Members. I see that I can set the designer file and the parameters, but nothing about passing the connection string or select statement/SPROC.

So can you only use Data Connections within Telerik Report Designer, and not pass them from the code behind, when using "HTML5 ASP.NET Web Forms Viewer."

Stef
Telerik team
 answered on 04 Oct 2016
3 answers
78 views

I believe the attached pictures below explains everything. I have reports on our website and the numbers displayed on the web page do not match when the user exports them to the PDF view. When exporting to a CSV file I get different values from both the web page and the pdf. 

Stef
Telerik team
 answered on 04 Oct 2016
17 answers
1.4K+ views
Hi,

I have a database table report. One of it's columns is query which can be any valid SQL statement which gives a single output after execution. It might even contain declare statements. Query also has some parameters for which values must be assigned at runtime. In all the rows the only thing that will be common is query parameters. Number of columns given by the query is not known at design time. Code decides which row from the table should be selected and gets value for query. How do I create a report to show result of such a query? One of the parameters in the report should be report_id.Will this be possible?
Stef
Telerik team
 answered on 04 Oct 2016
1 answer
373 views

Hello,

I am working on a report that should contains multiple tables with four columns. Each table is bound to a collection of the following data:
Class{
    public string item1 {get; set;}
    public string item2 {get; set;}
    public string Description1 {get; set;}
    public string Description2 {get; set;}

The cells of the first and second column should be merged when Item2 is an empty string. The same for the Description columns. I tried to adjust the TexBox sizes using the ItemDataBound events but this does not work. The column is rendered as wide as the largest text box.

The output should look like this:
Item1   Item2   Description1   Description2
Item11111111   Description11111111111111
Item1   Item2   Description1   Description2
Item1   Item2   Description1   Description2
Item11111111   Description11111111111111

Any help would be appreciated.
Regards,
Bert 

Katia
Telerik team
 answered on 04 Oct 2016
2 answers
94 views

I have a basic crosstab on a report.  Everything works fine and appears as desired when all is collapsed.

When a group is expanded (based on Action = ToggleVisibility ), it works as expected, but everything blends together visually, with no visual distinction between the expanded cells and the cells that were visible before expanding.

What I'd like to do is style the expanded cells with a different background so they'll easily stand out.

This crosstab is similar to this demo: http://demos.telerik.com/reporting/product-sales 

In that demo, when one of the Years is expanded, the newly visible cells are the same in appearance as those before expanding.  e.g. If you expand 2002, the quarter values are visible and appear the same as the year values that were already present... The Q1 value of 4.9 appears the same as the 2001 value of 20.2 - is there a way to style the 4.9 cell differently?

Attached is picture of my crosstab and the desired results.

Thanks much!

 

B
Top achievements
Rank 1
 answered on 03 Oct 2016
1 answer
60 views
IDE : Visual Studio 2015
Reporting Version : Q2 2016 (10.1.16.615)
Host: IISExpress

I create DummyMain report that must be call DummySubreport with programmatically.
When i run the report on first time after start solution, the TextBox with expression Fields.Id has error "object reference not set for subreport" on the first page but other page has not error.

Please, see the error image and report in the attachment file. 

link:https://drive.google.com/file/d/0B9yIfZcD3RmJX2dGR3RoOHo2ajg/view?usp=sharing 

Let me know what needs to be fix?  Thanks.
Katia
Telerik team
 answered on 03 Oct 2016
5 answers
1.4K+ views

As shown in the image, the Amount totals are calculating correctly ( Price*NetUnits=Amount). However, when using the SUM function in the Subtotal, the calculation is off by a penny. The SUM function is adding the amounts then Rounding which is causing the issue. See the calculations below.

Line 1 (7/25/2016) - Price $13.06 * Net Units 9.44 = Amount $123.286 (Rounded $123.29)

Line 2 (7/29/2016) - Price $13.06 * Net Units 8.30 = Amount $108.398 (Rounded $108.40)

Subtotal $123.286 + $108.398 = $231.684 (Rounded $231.68)

Line 1 + Line 2 = $231.69

Any help would be appreciated. Thanks!

 

Jennifer
Top achievements
Rank 1
 answered on 30 Sep 2016
2 answers
96 views
We seem to have encountered a rendering bug in the WPF ReportViewer (Q3 2013) where the last character in nearly all the text items inexplicably does not appear. 

In the attached image, the following problems are evident:
- On the vertical axis, PU001 should be seen, instead its PU00 (the 1 disappears off the end)
- On the horizontal axis, the first value after 0 should be 500 (instead its 50, the last 0 disappears off the end)
- In the legend, the blue box should have the label "Mitigated" (instead its "Mitigate", the last 'd' disappears off the end)

When the report is exported to pdf however, everything appears as expected, so I'm assuming this is a bug in the WPF Report viewer. Obviously it is very important that these values are displayed correctly (especially on the axis, where incorrect rendering can be mistaken for different values)
Stef
Telerik team
 answered on 30 Sep 2016
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?