I find the ability to create user functions so that the users of the designer can insert domain related content. However, there are some places where I would like to help them insert objects other than text.
Is it possible to provide a function that would return, say, a shape or other visual element?
Is it possible to access values that a sub report has within the parent report?
Example: My sub report query will return a calculated value (lets say I have an expression in the sub report that is just "1+1"). Within the parent report, I would like to have an expression of ....IIF(subreport.field) = 2, "You picked the value of 2", "you did not pick the value of 2").
In crystal reports, you would create a global variable and that variable could be used within the entire report structure.
Is such a think possible in the standalone application?
I have found references to this ReportItem.Report.ItemDefinition.MyFunction(args) but it does not really explain or show what it does.
Brian
Hi,
How can we sort a table data clicking on a header and without making a backend API call Telerik report table.? Please provide an example solution for this.
Hi,
Our software enables the enduser to add 'Fee fields' to entities. This takes form as a list of 'key' and 'value' pairs in the data class.
A colleague of mine already asked about it here: https://www.telerik.com/forums/dynamic-properties-in-object-data-source
It is very important that the designer shows the available free fields with the name chosen by the enduser. I want to ask again, is it possible in some way?
I tried dynamic compilation of a DLL, but the ObjectDatasource sometimes becomes blank in the designer.
I tried a DataTable and the free fields show up correclty in the designer but i can only feed one DataTable as the root datasource. I can not create multiple DataTables as datasources in the Report before saving it to a file and then showing it in the designer. I also dont know how a DataTable deals with related entities and collections.
I tried a DataSet but that just gives 'can not find a parameterless constructor' error in the designer.
Are we out of options here?
Hi,
I'm trying out Telerik Reporting for .NET Core and I'm having an issue configuring the export device settings for CSV I've added the app.config file specified at the bottom of: http://docs.telerik.com/reporting/html5-report-viewer-asp-net-core
This app.config is being picked up by the program because it allowed me to input the connection string and run up the report.
After this I tried adding in extension settings as detailed in your support blog: http://www.telerik.com/support/kb/reporting/details/configuring-the-csv-rendering-extension
My implementation is below:
<
configuration
>
<
configSections
>
<
section
name
=
"Telerik.Reporting"
type
=
"Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting, Version=10.2.16.914, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"
allowLocation
=
"true"
allowDefinition
=
"Everywhere"
/>
</
configSections
>
<
Telerik.Reporting
>
<
Extensions
>
<
Render
>
<
Extension
name
=
"CSV"
>
<
Parameters
>
<
Parameter
name
=
"NoHeader"
value
=
"true"
/>
<
Parameter
name
=
"NoStaticText"
value
=
"true"
/>
</
Parameters
>
</
Extension
>
</
Render
>
</
Extensions
>
</
Telerik.Reporting
>
<
connectionStrings
>
<
add
name
=
"XXX"
connectionString
=
"XXX security=True;MultipleActiveResultSets=True;App=EntityFramework;Asynchronous Processing=true"
providerName
=
"System.Data.SqlClient"
/>
</
connectionStrings
>
</
configuration
>
I'm wondering if:
Thanks,
Josh
Hello,
We've got a problem with the PageCount property over here. Most of the time it works (always but once...), So it seems like the pagecount has a bug?
Is there a known bug at the moment?
Our scenario is:
We've got 6 pages, but the PageCount was 5. Pagenumbering works like fine.
It happens only when there is a certain amount of data on the pages, so when I had less data, the PageCount was 6, so correct.
Any ideas?
Steven
Dear Telerik,
we are trying to use a report file Item.trdx with ObjectDataSource in .NET MVC but the view can not render my report.
1) In ReportDesigner
I created a file Item.trdx, then tried to link to a fake sqlDataSource to test in preview mode all good.
2) ObjectDataSource: I have below classes in Model (I may build these classes into class library .dll later if required)
public class
ItemLocationModel
{
public string ITEM_NO { get; set; }
public string PREV_LOC { get; set;}
}
public class ItemLocation
{
[DataObjectMethod(DataObjectMethodType.Select)]
public static IList<ItemLocationModel> GetItemLocation(string item_no)
{
List<ItemLocationModel> l =new List<ItemLocationModel>();
//fill up data here based on item_no....
return l;
}
}
3) In Controller: I am trying to use Resolver
class
CustomReportResolver : Telerik.Reporting.Services.Engine.IReportResolver
{
public Telerik.Reporting.ReportSource Resolve(string item_no)
{
Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = ItemLocation.GetItemLocation(item_no);
Telerik.Reporting.Report report = new Telerik.Reporting.Report();
report.DataSource = objectDataSource;
Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
reportSource.ReportDocument = report;
return reportSource;
}
public class ReportsController : Telerik.Reporting.Services.WebApi.ReportsControllerBase
{
protected override Telerik.Reporting.Services.Engine.IReportResolver CreateReportResolver()
{
return new CustomReportResolver();
}
protected override Telerik.Reporting.Cache.Interfaces.ICache CreateCache()
{
return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache();
}
}
4) In CSHTML: i am populating the ReportViewer
<div id="reportViewer1" class="k-widget">
loading...
</div>
<script type="text/javascript">
$("#reportViewer1")
.telerik_ReportViewer({
serviceUrl: "/api/reports/",
templateUrl: '/ReportViewer/templates/telerikReportViewerTemplate-9.0.15.324.html',
reportSource: {
report: 1
}
});
</script>
5) RESULT:
I debugged the Resolve() function and it clearly got data correctly, but it does not show my my report, it totally empty without any error even the template was loaded. My questions are:
- How to load data returned back from an InstantDataSource in CSHTML file?
- How to bind my returned data with a report file .trdx?
Thanks so much in advanced.
Quang
Is there a way to convert a column from your data source to an array/concatenated string?
To give a little more detail:
I'm getting back a list of data from my query looking something like this
I then need to pass the comma delimited list of column 3 ("1, 23, 78") into a sub-report to be displayed.
Any help would be appreciated.