Telerik Forums
Reporting Forum
1 answer
282 views

Hello,

I am new to the telerik reports.

I am trying to create a report, I have managed to create them using static data, linking the report to a class and creating a list in its constructor, but now what I want is:

I have an object which contains a list of dynamic data,similar to the obj.png, which I want you to see in my report.

How do I pass the suscripcion object to the report1 to show the fields, as in the suscrip.png image?

 

Thank you.

Neli
Telerik team
 answered on 15 May 2019
1 answer
1.6K+ views

Hi,

I am using asp.net core and we have dev and production environments set up on different machines.

How can I pass a connection string that is appropriate for the given environment to the .trdf report? I've tried everything I can think of.

There was a long winded article with what seemed to be a very complicated way of doing something that should be simple.

(https://www.telerik.com/support/kb/reporting/details/changing-the-connection-string-dynamically-according-to-runtime-data).

All I want is to read the appsettings.json file, pull the correct connection string from there and pass it to the .trdf at runtime.

My kingdom for a simple example!

Thanks ... Ed

 

Todor
Telerik team
 answered on 15 May 2019
0 answers
69 views

I have a crosstab with this structure (year, quarter, month columns) (see attachment)

Based on which column group is expanded I want to show a different value in the yellow field.

 

  • if the Year column is collapsed I want to show field1.Value
  • if the Year column is expanded I want to show field2.Value
  • if the Quarter column is expanded I want to show field3.Value

I tried using scopes but I the scope doesn't exists I get an error. So in case the Year column is collapsed I get an error that the month scope doesn't exists.

Is there a function to check if a certain scope does exists?

 

 

 

 

Marcel
Top achievements
Rank 1
 asked on 14 May 2019
6 answers
218 views

I got a big question!

 

I used reporting and its DocumentMapText 

The content of the DocumentMapText contains Chinese

but it can display Chinese it becomes symbols

 

what can I do to solve it ?

Silviya
Telerik team
 answered on 14 May 2019
1 answer
494 views

I have a report book which I create through C# code. I want to have a single TOC covering all the reports in the report book. 

Following this (https://docs.telerik.com/reporting/designing-reports-reportbook-toc) I started creating a TOC but this article (https://docs.telerik.com/reporting/table-of-contents-report-book) says to add TocReportSource of ReportBook programmatically. But the problem is it doesn't have any example of how to do that. Can you add a sample code of how to achieve this..

 

//Report Book
var reportBook = new ReportBook();
 
//Cover Page
var coverPageReportSource = new InstanceReportSource();
var coverPagereport = new CoverPage(reportId)
{
    DocumentName = "Cover Page Report"
};
coverPageReportSource.ReportDocument = coverPagereport;
reportBook.ReportSources.Add(coverPageReportSource);
 
//TOC Page
var tocPageReportSource = new InstanceReportSource();
var tocPagereport = new FirstPage()
{
    DocumentName = "toc Page Report"
};
tocPageReportSource.ReportDocument = tocPagereport;
reportBook.ReportSources.Add(tocPageReportSource);
 
//Image Report
var imagesReportSource = new InstanceReportSource();
var imagesDatareport = new ImageReport()
{
    DocumentName = "Image Report"
};
imagesReportSource.ReportDocument = imagesDatareport;
reportBook.ReportSources.Add(imagesReportSource);
 
var instanceReportBookSource = new InstanceReportSource
{
    ReportDocument = reportBook
};
 
var reportProcessor = new ReportProcessor();
var renderingResult = reportProcessor.RenderReport("PDF", instanceReportBookSource, new Hashtable());
Neli
Telerik team
 answered on 14 May 2019
5 answers
797 views

It seems that the report viewer only supports this connection string format in the appsettings.json file for Asp.Net Core applications

"ConnectionStrings": [
  {
    "name": "Reports",
    "connectionString": "Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True",
    "providerName": "System.Data.SqlClient"
  }  
]

 

But now a days this format for connection strings is used:

"ConnectionStrings":  {
"Reports": "Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True"
}

 

It should be nice if the newer format also is supported.

 

 

 

Borja
Top achievements
Rank 1
 answered on 14 May 2019
2 answers
89 views

Does anyone know of any way of vertically centering a report (header, body and footer)?

I have a report whose body is between 1 and 25 lines.  When the report is 25 lines it takes almost the entire page up, and when 1 line almost nothing on the page.  

The client has requested the report be centered vertically.

 

First I checked the report designers page settings and properties.  And I don't see anything that looks like it does what I want.

I then checked the PrinterSettings and StandardPrintController for a setting that would do this.  And I don't see an option for what I want.

 

Is the only way to do this to figure out the number of lines, calculate the top margin and change that during runtime?  

Todor
Telerik team
 answered on 13 May 2019
5 answers
577 views

Hello ,

I am using telerik report designer R3 2016, and when I m drawing line chart using line chart, consider i have a data for the days 1,2,4 and 7 in the x-axis and 0 -100 in y axis . The line chart draws perfectly on the nodes 1 to 2, 2 to 4 and 4 to 7. But the the problem is here in x- axis 3, 5 and 6 is missing (obviously the node not drawn there) . is that any way to show the line chart 1 to 2, 2 to 3 ( go default to zero even no value is mention to draw), 3 to 4, 4 to 5, 5 to 6, 6 to 7.  Exactly to say the missing values which is not given from the user it should go down to zero and draw the nodes which the actual data. please see the screen shot for further reference.

When no value it should not directly pass to next node, My idea to show the amount of sales in particular day/month, the missing days/month not having any data means no sales. should go down to zero. If I process from back-end its huge amount of data generate for zeros.

Using C# code, we can set the missing value property as zero, but in designer i am not able to find this property, please can anyone help me to come out of this.

 

 

Neli
Telerik team
 answered on 13 May 2019
1 answer
131 views
I'm trying to replicate a SSRS report that uses a DbContext for a data source. Each page of the report has a header and footer that contains data that is retrieved and display based on report parameters. I don't see any way to implement columns in the header because I can't place a table in the PageHeaderSection. I would love to hear some suggestions on how best to accomplish what I'm trying to do.
Silviya
Telerik team
 answered on 13 May 2019
2 answers
157 views
Hello, I have a question, I am using version 2019 and when I generate a report with a line series it doesn't connect the points, the line is not drawn using Arrangemode = Clustered, when I change to Stacked it draws them twice, help I need only one line, I'm forgetting some configuration?.
Foton
Top achievements
Rank 1
 answered on 09 May 2019
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?