Telerik Forums
Reporting Forum
0 answers
180 views
Hi there

I am creating a report using CrossTab and I am stuck at one point here. I am trying to set visibility to False if there is no record present in the columns for any user. If there is even one record in the database the column will be visible.

Can anybody help me out.
Muhammad
Top achievements
Rank 1
 asked on 09 Jan 2018
1 answer
559 views

Could someone please help.  I am trying to understand how to code a conditional IIF() clause with a new line. 

My goal is the following:

mfgTitle

Bob

Smith

 

Here is what I have tried

First:  I have tried using an htmlTextBox and using the conditional expression within it.  This caused the htmlTextBox to throw an error over the </br>

IIF(value <> 1, {Fields.mfgTitle} <br/> {Fields.FirstName}<br/>{Fields.LastName}, {Fields.FirstName}<br/>{Fields.LastName})

Also I tried  the following

IIF(value<> 1, {Fields.mfgTitle} + "\r\n" + {Fields.FirstName} + "\r\n" + {Fields.LastName}, {Fields.FirstName} + "\r\n" + {Fields.LastName})

 

Any Help would be greatly appreciated.

 

Thank You

David
Top achievements
Rank 1
 answered on 08 Jan 2018
3 answers
171 views

Here's the layout

_______________________
[Page Header]
-------------------------------------- 
[HeaderData]
[HeaderDetails]
[Table1]
[SubReport1]
[SubReport2]
[SubReport3]
--------------------------------------- -> PageBreak.After
[PageFooter]
_________________________

------ Denotes the DetailSection wrapper. The DetailSection also has KeepTogether = True

____ Denotes the page edges

Now what is current happening is one set of data exceeds the the size of a single page - and instead of honoring the page break and just starting the data on the next page and followed by another page which would have another page break and be mostly whitespace. It's placing the data on the page before.

Example:

_____________________

[Page Header]
-------------------------------------- 
[HeaderData]
[HeaderDetails]
[Table1]
[SubReport1]
[SubReport2]
[SubReport3]
--------------------------------------- -> PageBreak.After
[HeaderData2]
[HeaderDetails2]
[Starts the table1 data for the next page . . . continued on the following]
--------------------------------------- -> continued on the next page
[PageFooter]
___________________________

I know that part of the issue is that the data of the second data set is larger it needs an additional page (But not two complete pages). However, the render should still respect the page break from the page prior and just include an extra page after - not bleed onto the page before. 

The page break is functioning - if the data sets are small enough to fit two to the same page, it does not. (This report inherits from another report - with the page break being set using an inherited method that is called on this report, but not on the parent. This report also has one of the subreports visible while the other does not - which also adds to the height issue in question. [I also hid this on the inherited report so the sole difference was the page break to confirm the page break worked.])

The closest I got to finding a similar reported issue were Daniel's comments here: https://www.telerik.com/forums/how-to-not-keeptogether-a-subreport 

Katia
Telerik team
 answered on 08 Jan 2018
1 answer
7.9K+ views

I try to use Telerik reporting with:

- html5 reporting viewer (angular)
- .net telerik reporting webapi 2.0 service (.net 4.5.2)

I follow all instructions, but I get the following error message:
"Could not load file or assembly 'System.Net.Http.Formatting, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference."

See attachment capture.png

I tried: 
1. This dll is located in the bin directory of de service.
2. I also installed al system.net.http.formatting + system.net.http versions in the GAC.
3. I tried the redirects:
<dependentAssembly>
        <assemblyIdentity name="System.Net.Http" publicKeyToken="b03f5f7f11d50a3a" culture="neutral"/>
        <bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="5.2.3.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Net.Http.Formatting" publicKeyToken="31bf3856ad364e35" culture="neutral"/>
        <bindingRedirect oldVersion="0.0.0.0-5.2.3.0" newVersion="5.2.3.0"/>
      </dependentAssembly>
4. tried separatedly webapi service, tried existing webapi.
5. I see that telerik.reporting.services.webapi 11.2.17.913 uses:
- newtonsoft.json 4.5.0, system.net.http 2.0.0, system.net.http.formatting 4.0.0
6. Installed Cors (because of error messages) and that is working
7.In my development environment it is working (iis express), but on the server (iis) is not working. I copied the output files, I tried with publish. Nothing is helping.
8. reinstall Microsoft.AspNet.WebApi.Core -version 5.2.3 and other packages
9. tried .net 4.0, .net 4.5, net 4.6
10. tried fiddler: I see the errormessage at: http://server/api/reports/clients (http error 500)
11. tried: https://stackoverflow.com/questions/28604325/how-to-get-system-web-http-version-5-2-3-0
12. tried: http://docs.telerik.com/reporting/telerik-reporting-rest-host-http-service-using-web-hosting
13. For angular gui i used demo of telerik installation.

What can I do? Why is it still using system.net.http.formatting 4.0.0?

Jordy
Top achievements
Rank 1
 answered on 08 Jan 2018
0 answers
172 views

Hey everyone,

We have lots of great features coming to Telerik Reporting in our next release in 2 weeks. Read the attached post to get an early preview.

https://www.telerik.com/blogs/sneak-peek-internationalization-more-telerik-reporting-r1-2018

Enjoy,

Prashant

 

Prashant
Top achievements
Rank 1
 asked on 03 Jan 2018
0 answers
381 views

I am using object data source to bind the data. But I am breaking my head to fix the list of objects in the report designer which is failing in the preview report. my business model returning List of objects from a class. like, 
Public class Master
{
     public int id {get;set;}
    public string name {get;set;}
    public string deptname {get;set;}
    public List<content>  content {get;set;}
}

public class content
{
public int contentID{get;set;}
public string contentName {get;set;}
}
My businesslogic method like below, 
public async Task<List<Master>> GetToken(string AppNo)
{
----------Business return list of objects of Master----------

Return resultMaster
}
Questions, 
1. how do I define an object in the report?  ( =Fields.resultMaster.ID) or (=Fields.ID)
2. Given the model (Content) how do I bind in the report? (=Fields.resultMaster.Content.ID)  
Could you please give me same report for "Report Designer Q2 2015" version. The one you attached is an old version of Telerik report.
Thanks.

Vijayan
Top achievements
Rank 1
 asked on 02 Jan 2018
4 answers
715 views

My boss and I created a custom report resolver that works on his machine but not mine.

The ResolveReport() method is not called on my machine. We've got the exact same code.

Could you give us any hint to try and debug this issue?

Regards

public class ReportsController : ReportsControllerBase
{
  public ReportsController()
  {
    this.ReportServiceConfiguration = new ReportServiceConfiguration()
    {
      ReportResolver = new CustomReportResolver(),
      Storage = new Telerik.Reporting.Cache.File.FileStorage()    
    };
  }
}
 
public class CustomReportResolver : ReportResolverBase
{
  protected override ReportSource ResolveReport(string report)
  {
    TypeReportSource _ReportSource = new TypeReportSource()
    {
      TypeName = typeof(MADashboard).AssemblyQualifiedName
    };
    return _ReportSource;
  }
}
Senthil
Top achievements
Rank 1
 answered on 02 Jan 2018
5 answers
519 views
Hi,

How to adjust the size of the crosstab at runtime?  The total width of the crosstab should be fixed, but the size of textboxes inside should be adjusted according to the number of columns. How can i achieve this?

Thanks
Gurinder
Top achievements
Rank 1
 answered on 02 Jan 2018
3 answers
1.0K+ views
Hello, I have some problem with binding to object like

class ObjectDataSource {   
     public List<Product>  ProductListMain;
     public List<Product> ProductListSecond;
     public IdValue[] Parameters;
}
class Product {
    public string Name;
    public int Count;
}
class IdValue {
    public int Id;
    public int Value;
}

I can't create correct report to show me 3 different tables, where 2 first table get data from Lists and the 3-rd table get data from array.
Please show me the right path.
Vijayan
Top achievements
Rank 1
 answered on 02 Jan 2018
1 answer
769 views

I have recently installed reporting onto my machine. All the example projects works fine but the below one is not loading the report fine and throws exception. 

CSharp.Asp.NetCoreDemo

 

Unable to get report parameters.
An error has occurred.
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.

It looks like all the reports which connects to DB with .NetCore is not working. 

 

Can you fix and let me know what is the issue? 

Katia
Telerik team
 answered on 02 Jan 2018
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?