I have two reports, first report (finished) shows the detail Section normally, but second doesn't. I've already changed the path. F ooter and header section are fine, but when I insert some textbox or something else on the detail section, nothing happens. I tried to change the background color to check if the problem were the items, but the background stays blank. Can you help me please? The ReportPreview shows all the items normally
Of course I set detail.Visibile = True
Please help me!
Hi,
I was designing a report and had multiple columns inside a table, e.g;
Column-A || Column-B
String 1 || 45000
String 2 ||
String 3 || 2000
Now, clearly as you can clearly see, on column-B we are supposed to perform SUM function. And this column contains one empty field. Also, I would like to mention here that table is being populated using "expression" and I am supposed to show sum of this column in separate textbox.
What I am already doing is; " =SUM(Fields.amount)" but that is not giving me correct answer.
I shall be thankful for any help.
Regards,
Muhammad Mohsin
i'm using telerik report Ver
Telerik Reporting Q1 2016 SP1 (version 10.0.16.204)
all report give me
Error loading the report viewer's templates. (Template = http://domain/APPLICATIONNAME/api/reports/resources/templates/telerikReportViewerTemplate-html).
and when i check telerik service by
"http://domain/APPLICATIONNAME/api/reports"
This XML file does not appear to have any style information associated with it. The document tree is shown below.
<Error>
<Message>
No HTTP resource was found that matches the request URI 'http://domain/APPLICATIONNAME/api/reports'.
</Message>
<MessageDetail>
No type was found that matches the controller named 'reports'.
</MessageDetail>
</Error>
Hi,
I can create the report rendering to XLSX format but a message box will be displayed before the report: How to avoid this message box? Thanks.
Hi. I have a Report with Pie Chart that displays number on purcentage based on data in a list.
When the Report repeats itself and finds no data, the Chart Pie disappears. I need a way to display an empty Chart Pie with 0% when there is no data on the list.
How can I do it?
Sorry if I open another thread, but I need help about Pie Chart.
I created a Pie Chart, and I have three questions about it:
1. How can I fix the size of the entire Chart?
2. How can I fix the size of every slice based on percent? (how you can see, the slice have all the same size even if different values))
3. Why every label near % repeat a number 0,00%?
Here the screenshot, hope you can help me.
Best regards.
Angelo
Hello! I apologize for my poor English first.
I am a beginner on Telerik Report. I have to create a Pie chart that displays a datasource's data. Make my point clear:
I am making a Report build on three lists of objects, one object of every list it's named: Status (it can be: Open, On track, Cancelled etc...).
The chart should displays the average of every "Status" inside the three lists of the Report in percent (for example: Open 100%; Open 50%, Open 75% etc...)
The problem is: I don't know how to bind via code the Chart with the ObjectDataSource, I am using Graph Wizard.
I wrote this code
private void graph1_NeedDataSource(object sender, EventArgs e)
{
Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;
chart.DataSource = CbpGlobalInitiativesUsdByCountryFollowUpStructure; //it's the DataSource of the entire Report
}
The Binding of the graph already has "Property path: DataSource", "Expression: =Field.List1 =Field.List2 =Field.List3"
I saw a tutorial and at this point the chart should already works, instead nothing happens!
Where am I get wrong?
Thank you,
Angelo
Hi There,
I'm trying to displaying Telerik report in MVC 6 , its doesn't throw any error either doesn't display the Report viewer with the report. I have provided the Razor code over here . When I Use fiddler, the webapi is throwing an error Telerik.Reporting.Services.Engine.InvalidReportException, from Telerik.Reporting.Services.Engine.ReportEngine.ResolveReportSource(String report). Please help to resolve the issue. Attached the fillder_log as well.
@{var typeReportSource = new TypeReportSource() { TypeName = typeof(BarcodesReport).AssemblyQualifiedName }; }
@(
Html.TelerikReporting().ReportViewer()
.Id("Testreport1")
.ServiceUrl("http://localhost/api/reports/")
.TemplateUrl("http://localhost/ReportViewer/templates/telerikReportViewerTemplate.html")
.ReportSource(typeReportSource)
.ViewMode(ViewMode.Interactive)
.ScaleMode(ScaleMode.Specific)
.Scale(1.0)
.PersistSession(false)
.PrintMode(PrintMode.AutoSelect)
.Deferred()
)
<select id="theme-switcher"></select>
@section scripts
{
<!--kendo.all.min.js can be used as well kendo.web.min.js and kendo.mobile.min.js-->
<script src="@Url.Content("~/ReportViewer/js/telerikReportViewer.kendo-11.1.17.614.min.js")"></script>
<script src="@Url.Content("~/Scripts/themeSwitcher.js")"></script>
<script src="@Url.Content("~/ReportViewer/js/telerikReportViewer-11.1.17.614.js")"></script>
<script type="text/javascript">
$(document).ready(function () {
//Theme switcher
themeSwitcher(
'#theme-switcher',
'#common-css',
'#skin-css');
});
</script>
@(Html.TelerikReporting().DeferredScripts())
}
Hello,
I have been having a problem trying to generate a report programatically. I can generate columns just fine, but when it comes to trying to generate the rows, the ReportViewer gives me a NullReferenceException: "Object reference not set to an instance of an object." As I iterate through my list, I add a new row to the table body. Then, for every cell that needs to be made, I add a ChildGroup to the main Rowgroup. After I've finished iterating and generating everything, I finally add the parent RowGroup. From what I can tell, the way I add rows is close to the way it's done in the designer files. Here is the code in question:
private
void
table1_ItemDataBinding(
object
sender, EventArgs e)
{
HtmlTextBox textboxGroup;
var christieTable =
new
ChristieTable(ReportParameters[
"partNumber"
].Value.ToString(),
ReportParameters[
"lotNumber"
].Value.ToString());
var christieProps =
typeof
(ChristieTable).GetProperties();
table1.ColumnGroups.Clear();
table1.RowGroups.Clear();
table1.Body.Columns.Clear();
table1.Body.Rows.Clear();
TableGroup rowsTableGroup =
new
TableGroup();
List<ReportItemBase> reportItems =
new
List<ReportItemBase>();
//start at -1 so we can account for the mold # column but retain the ability to index using i
for
(
int
columnIndex = -1; columnIndex < christieProps.Length - 1; columnIndex++)
{
var propValue = (columnIndex != -1) ? (List<Tuple<
double
,
int
>>) christieProps[columnIndex].GetValue(christieTable) :
null
;
//make sure our column property is populated
if
(propValue !=
null
&& propValue.Count > 0)
{
var columnsPerStation = 1;
var currentDip = propValue[0].Item2;
foreach
(var measurePair
in
propValue)
{
if
(measurePair.Item2 != currentDip)
{
columnsPerStation++;
currentDip = measurePair.Item2;
}
}
var tableGroupColumn =
new
TableGroup();
table1.ColumnGroups.Add(tableGroupColumn);
//if tableGroupColumn isn't given a name, all cells will have the same value as cell 0,0
tableGroupColumn.Name = columnIndex.ToString();
table1.Body.Columns.Add(
new
TableBodyColumn(Unit.Inch(1)));
for
(
int
a = 0; a < columnsPerStation; a++)
{
textboxGroup = ReportHelper.GenStandardColumnHeader(christieTable.StationNames[columnIndex] +
" - DIP NUMBER "
+ propValue[0].Item2);
tableGroupColumn.ReportItem = textboxGroup;
reportItems.Add(textboxGroup);
}
var value = (List<Tuple<
double
,
int
>>) christieProps[columnIndex].GetValue(christieTable,
null
);
table1.Body.Rows.Add(
new
TableBodyRow(Unit.Inch(0.24998027086257935D)));
for
(
int
rowIndex = 0; rowIndex < 5; rowIndex++)
{
TableGroup newRowSubGroup =
new
TableGroup();
newRowSubGroup.Name =
"row"
+ (columnIndex + rowIndex + 1).ToString();
rowsTableGroup.ChildGroups.Add(newRowSubGroup);
HtmlTextBox newTextBoxTable = ReportHelper.GenTextBox(value[rowIndex].Item1.ToString());
table1.Body.SetCellContent(rowIndex, columnIndex + 1, newTextBoxTable);
reportItems.Add(newTextBoxTable);
}
}
else
if
(propValue ==
null
)
{
var tableGroupColumn =
new
TableGroup();
table1.ColumnGroups.Add(tableGroupColumn);
tableGroupColumn.Name = columnIndex.ToString();
table1.Body.Columns.Add(
new
TableBodyColumn(Unit.Inch(1)));
textboxGroup = ReportHelper.GenStandardColumnHeader(
"MOLD #"
);
tableGroupColumn.ReportItem = textboxGroup;
reportItems.Add(textboxGroup);
HtmlTextBox textBoxTable = ReportHelper.GenTextBox(
"= RowNumber()"
);
table1.Body.SetCellContent(0, columnIndex + 1, textBoxTable);
reportItems.Add(textBoxTable);
}
}
rowsTableGroup.Name =
"rowsGroup"
;
rowsTableGroup.Groupings.Add(
new
Grouping(
null
));
table1.RowGroups.Add(rowsTableGroup);
table1.Items.AddRange(reportItems.ToArray());
}
The GenStandardColumnHeader and GenTextBox methods simply return pre-formatted textboxes, their first parameter being the value of the textbox. The properties of the object ChristieTable that I am iterating through are DataMembers consisting of a list of pairs. Using the debugger, I found that the report processes fine, but throws the exception when trying to render. Despite the fact that rows get clearly added, I found in the debugger that the row count for the table at render time is 0. Any help would be appreciated, thanks.