Telerik Forums
Reporting Forum
3 answers
563 views

Hi

 

I've got a problem with clearing data sources with the reporting framework. I dynamically create parameters with multi value data sources (csv datasources) for the report and that works fine.

When I import the report with reportPackager.Unpackage(targetStream); I am unable to remove the CSV data source with code. Even if I delete the parameter that is linked to the csv datasource it does not get removed from the designer and is still displayed in the designer.

Is there a way to remove Data sources that are linked to parameters.

 

Thanks.

Stef
Telerik team
 answered on 05 Oct 2016
1 answer
155 views

Help request on a Pie Chart.

I have a crosstab report that I wish to add a pie chart into. I know how to do this.

The question is how to filter the pie chart to only show certain values?

The report shows the count of customer complaints per category. The goal is to show a pie chart that shows there where a total of X complaints logged per customer. Of the X complaints only Y qty are of a certain category.

Basically trying to build a radial gauge so that we can track there certain categories.

 

Anyone have a sample or ideas I could look at? It must be possible...just very new to this.

Thanks,

Brian

Katia
Telerik team
 answered on 05 Oct 2016
8 answers
257 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
144 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
544 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
75 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
364 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
90 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
56 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
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?