Telerik Forums
Reporting Forum
7 answers
232 views
We are binding our reports through the code-behind.  I need to create a drillthrough report.  I have watched the video, and set up the Master report action correctly -- I selected the child report using the "Select Report Document" and I created the target report parameter. On the Child Report, I have created the parameter to match the one specified within the master.

However, on my child report, I cannot figure out how to access this parameter. It is not being passed into the constructor (get an error if I force the constructor to accept a parameter) and the "Load" and "Init" events of the child report do not fire.  The value of the Report.Parameter I have defined is null.

How can I access this passed-in parameter value?
Stef
Telerik team
 answered on 03 Nov 2015
6 answers
316 views
Hello

We are working on optimizing our reports, and after some investigation it turns out, reports with more than 1000 rows take too long to render.



We have modified our queries so fetching the data is actually neglectible compared to the actual rendering time. Both Excel and CSV produce very similar results, so it cannot be due to some formatting issue. There isn't any conditional formatting applied to the reports there is only a table with 14 columns in the details section.
The computer specs I'm testing it on: Core i5 3.2 GHz, 8GB RAM, 240 GB SSD.

I know that similar thread exist, but I've read in the release notes that rendering performance has been significantly improved in this version, so that's why I'm puzzled.

Regards,
Roland

















Rows
SQL Time (ms)
Linq time (ms)
GetData Total (ms)
Render (ms)


2000
1
16
95
3567


4000
1
24
105
13905


8000
1
39
122
51170







%��:�
Stef
Telerik team
 answered on 03 Nov 2015
1 answer
224 views

Hi i'm trying to generate the pie Chart attached in the file ...

I have a SQL source with this 3 columns:

Category  ---- Sector .....  Numofitems

C1                     A                 125

C1                     B                 175

C2                     F                 200

C1                     N                 135

I need a pie than first made the groupby Category -- num of ítems and their % so in the legend only have 2 categories in this case.

and the in this category made the groupby Sector -- num of ítems and their %

 

But I can not know how first group by Category and then by sector with the telerik report Designer ...

I hope looking the file attached you will see what i need ...

 

Thanks,

 

Joan

 

Stef
Telerik team
 answered on 03 Nov 2015
5 answers
180 views
Hi All,

I am trying to create a drill through report in a new window in a winforms application.  I know that I can set up a drill through to the same report viewer, but often the users like to see both the original report and any sub-reports side by side.  Is there a way to get the field name and value and perhaps other data for the same row in a VB or C# program when a user clicks or double clicks on a data item?  I could then use that data to create the other report.  Alternatively, is there a way to use the drill through action to create a spawned report in its own window?

Thanks in advance for any help.

Stef
Telerik team
 answered on 30 Oct 2015
1 answer
132 views

Hello,

I need to set scale unit and/or step properties based on expressions for datetime scale. The reason for this is because my charts' time axis (x-axis) vary based on report input parameters (from date and to date).

Moreover, axis labels and grid lines should be able to dynamically reflect a timespan of an hour as well as a timespan of several months. 

Doing this programmatically is currently not an option. Are there any ways to achieve the above in Telerik Report Designer?

 

 

Nasko
Telerik team
 answered on 30 Oct 2015
1 answer
217 views

Hi,

 

I want to hide header and footer of main report, in subreport.

Ignore header and footer of main report, in some of sub reports.

Nasko
Telerik team
 answered on 30 Oct 2015
3 answers
336 views

We are using Telerik Reporting 2015 Q2 using HTML5 MVC Viewer and REST Web API services.

Everything working fine and the report rendered correctly and exports fine. Event the print functionality is working great.

But when clicking the print preview button for single page report, it fails. From browser console we see that the request receives 400 response.

The same print preview works when the rendered reports has 2 pages or more.

We are using SQL Server Database for caching.

Are we missing something?

Stef
Telerik team
 answered on 30 Oct 2015
1 answer
148 views

I'm trying to use two sqlDataSources on a single report.

 So farI have this piece of code where the Datasource is binded to the first sqlDataSource.

 

01.this.sqlDataSource1.ConnectionString = this.SqlConnectionString;
02.this.sqlDataSource1.CommandTimeout = 600;
03.this.sqlDataSource1.Parameters.Clear();
04.this.sqlDataSource1.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
05.                new Telerik.Reporting.SqlDataSourceParameter(StandardParams.varKey, System.Data.DbType.Int32, _varKey),
06.                new Telerik.Reporting.SqlDataSourceParameter(StandardParams.IncludeZeroBalance, System.Data.DbType.Boolean, false)
07.            });
08.this.sqlDataSource3.ConnectionString = this.SqlConnectionString;
09.this.sqlDataSource3.CommandTimeout = 600;
10.this.sqlDataSource3.Parameters.Clear();
11.this.sqlDataSource3.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] {
12.                new Telerik.Reporting.SqlDataSourceParameter(StandardParams.varKey, System.Data.DbType.Int32, _varKey)
13.            });
14.this.DataSource = sqlDataSource1;

 

I want to know if there is a way in order to tell the report that whenever I set the value of an htmlTextBox I can use the sqlDataSource other than the one set on this.DataSource.

 

Thanks.

Stef
Telerik team
 answered on 30 Oct 2015
1 answer
80 views
getting this error in the end of installation process. Error screen attached.
I have run package as administrator on local computer (WIndows 10).

what's wrong? 

thanks

 
 

Stef
Telerik team
 answered on 30 Oct 2015
1 answer
801 views

Hi,

 We are trying to pass the data source query for the Telerik report as a parameter, at present we have option to build data source query during report creation in stand alone designer and the query is hardcoded inside the report(trdx file) when viewed from report designer or dot net application.

 

But we want to build the source query filters at run time in dot net application and pass them to the Telerik reports. I had raised a support ticket for this but haven't got an update from them, please share if you have some pointers to achieve this.

Thanks,

Daniel

Stef
Telerik team
 answered on 29 Oct 2015
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?