Telerik Forums
Reporting Forum
4 answers
358 views
For the application we're currently developing we'd like to use the Telerik Reporting.These last days I was testing it and how well it would suit our needs. Our application is running in WPF on .NET 4.0 and has its own look and feel. Now I was searching your forum on how to apply changes to the ReportViewer class and I came to know that you have to change the style of the ReportViewer itself, which wouldn't be a big deal. Since our application has its own Ribbonbar, we wanted to remove the Toolbar from the ReportViewer and integrate it into our application. Now I've figured out that the ReportViewer has no commands which support the functionality identical to those of the integrated Toolbar. On the forum you could find out that the ReportViewer was implemented using the MVVM-pattern.
So I'd like to know if there is a way to accomplish the needed task? Am I able to access the commands of the ReportViewerModel from ReportViewer (e.g. MoveToNextPageCommand, etc.) or do I have to write my own UserControl that has a ViewModel inheriting from ReportViewerModel?
An answer to this cause would be appreciated.

Regards
Alen
Todor
Telerik team
 answered on 18 Jun 2018
3 answers
75 views

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?

Ivan Hristov
Telerik team
 answered on 15 Jun 2018
1 answer
546 views

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

Nasko
Telerik team
 answered on 15 Jun 2018
3 answers
939 views
hi,
I'm using Telerik report table to display more than 500 rows of data (may vary) but I was unable to provide pagination to the table. 
Can you suggest an example or a way to implement it or where to find the pagination in Telerik report table wizard?
Rick
Telerik team
 answered on 14 Jun 2018
1 answer
550 views

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.

Todor
Telerik team
 answered on 14 Jun 2018
1 answer
142 views

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?

 

Milen | Product Manager @DX
Telerik team
 answered on 13 Jun 2018
10 answers
399 views

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:

  1. This implementation still works for .NET Core (I assume it does because the connection string does.)
  2. If you can see any issues with my above code.
  3. Where do these settings actually get pushed in to the report viewer template, I've searched through all the related code I can find and can't find any references to the export settings.

Thanks,

Josh

Nasko
Telerik team
 answered on 13 Jun 2018
5 answers
275 views

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

Todor
Telerik team
 answered on 13 Jun 2018
3 answers
716 views

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

Todor
Telerik team
 answered on 12 Jun 2018
2 answers
716 views

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

  1. blah    | x | 1
  2. words | y | 23
  3. hello   | z | 78

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. 

Steven
Top achievements
Rank 1
 answered on 08 Jun 2018
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?