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
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?
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.
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?
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.
what's wrong?
thanks
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