Telerik Forums
Reporting Forum
1 answer
229 views
I know Count is supposed to return a count of non-null items. But is there an easy way to return the number of null or empty cells in a column containing dates?
Todor
Telerik team
 answered on 23 Mar 2018
1 answer
265 views

I actually have 2 issues, both related to having a section (group footer) print at bottom of page = True.

1. If you have a table in your group header, and that table has the option to repeat column headers on each page, the group footer does not actually print at the bottom anymore.

To resolve this, I have created 2 groups and put the table in the second header group.

 

2. I have 2 group headers (due to issue 1 above), when the group footer won't fit on the page but the table did fit on the first page completely, the group footer does not print on the 2nd page at the bottom any more.

 

So to summarize, when using the option to have your group footers print on the bottom of the page, if your group header also contains a table that has the repeat column headers on each page = TRUE, the Group footer will not print at the bottom.

And, if your table fits on page 1 but the footer does not, on page 2....the group footer does not print on the bottom of the page as per the property setting.

 

Thanks,

 

Katia
Telerik team
 answered on 23 Mar 2018
1 answer
147 views

I have an application that prints images using Telerik Reporting and the Telerik.Reporting.PictureBox.  Some of these images are very old images and I am getting an error with the Telerik.Reporting.PictureBox when opening the image (a generic error occurred in GDI+).  Funny thing, is these images (all tiff images) display in the default Windows Form PictureBox control on a form.  With that said, what I would like to do, is to run the report and see a list of images that have an issue in the Telerik.Reporting.PictureBox.  The data source only has two fields, the image data and the PrimaryKey to the image.  I have tried using the reports "ERROR" event, which works in getting the error from the Telerik.Reporting.PictureBox, however, I don't know how to find out what record pointer the report is looking at so I can get the correct Primary Key value.  Can anyone help me with this.

 

TIA

Mark

Todor
Telerik team
 answered on 22 Mar 2018
6 answers
608 views
Hi,
I load text dynamically to the pagehader section, but I don't know how much text there is.
When there is a lot of text it hides behind the detail section.
Is there a property or a way to make the pageheader to autogrow in height depending on the amount of text or how can it be solved?

Regards,
Mattias
Katia
Telerik team
 answered on 22 Mar 2018
5 answers
164 views

Hi,

I'm within an MVC project, and I'd like to generate a PDF with the data contained into my Model. So I've created a Report using Telerik Reporting, and now I'd like to link it with my MVC Model.

The render is easy:

ReportRegistration reportRegistration = new ReportRegistration();
string fileName = @"C:\ReportRegistration.pdf";
 
ReportProcessor reportProcessor = new ReportProcessor();
Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = reportRegistration;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
 
using (FileStream fs = new FileStream(fileName, FileMode.Create))
{
    fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
}

 

but how do I bind data in that model to the designer? For example, in Attach the Designer I have. I'd like to use the data inside BusinessName member variabile inside my Model. Tried ObjectDataResorce but when I double click, Visual Studio crash.

Thanks

Marco
Top achievements
Rank 1
 answered on 22 Mar 2018
1 answer
147 views

Hello,

I'm a little new on Telerik Reporting, but I have a big issue. I try to make a simple calculation of a field to result a TOTAL sum... but instead of SUM i recive a kind of CONCATENATE of my cells

 

Picture below:

 

 

Brian
Top achievements
Rank 1
 answered on 20 Mar 2018
1 answer
110 views

I have a report with simply a table on it. I want to display all of the data I grabbed from EF as an IEnumerable onto said table.

How do I accomplish this?

 

 

Katia
Telerik team
 answered on 20 Mar 2018
1 answer
128 views

I have a very simple query (below). I have tested in SQL Management Studio as well as the Configure DataSource in the Telerik Report Designer. Both return 19 rows of data. I added the ISNULL as those fields have the ability to be NULL and wanted to eliminate them from causing an error. If there is no parameter in query everything works . When a parameter is filled in I see the title of the TABLE but the rest is blank. I know this is something beyond simple. 

If I put in a default value into the parameter field on the table not even the header appears. The attachment shows how the Parameter is setup. Originally I was trying to pass the RegardingIdentifier () and through that was it so I modified the routine to use a string and still get the same results.

 

SELECT 

  Tasks.TaskIdentifier
, Tasks.RegardingIdentifier
, Tasks.StatusIdentifier
, Tasks.TaskNumber
, Tasks.DescriptionShort
, Tasks.StartDate
, Tasks.DueDate
, ISNULL(Tasks.Priority, 'Normal') AS Priority
, ISNULL(Tasks.EstimatedHours, 0) AS EstimatedHours
, ISNULL(Tasks.PercentComplete, 0) AS PercentComplete
, ISNULL(Status.FieldName, '') AS TaskStatus
FROM 
Tasks 
LEFT OUTER JOIN AppSettings Status ON Tasks.StatusIdentifier = Status.AppSettingIdentifier
LEFT OUTER JOIN Accounts ON Tasks.RegardingIdentifier = Accounts.AccountIdentifier
WHERE 
(Accounts.AccountCode = @AccountCode)
AND (Tasks.TaskComplete = 0)
ORDER BY 
Tasks.TaskNumber

Todor
Telerik team
 answered on 19 Mar 2018
2 answers
352 views

I am currently working towards moving our report files into database storage. I have setup a custom resolver that is able to get the report from the id properly; however, when the subreport is loaded, it does not appear to be using the /api/reports serviceUrl. instead, it is looking in the root directory of the project in visual studio and not being routed through the Reports controller. Of course, the report is not there. What do I need to do to make the reports to evaluate on the serviceUrl to get it like the other reports? 

Here's my resolver:

public class DatabaseReportResolver : Telerik.Reporting.Services.Engine.IReportResolver
    {
        public ReportSource Resolve(string message)
        {
            using (var _context = new CommonDataContext())
            {
                var report = _context.ReportRecord.FirstOrDefault(x => x.UniqueName == message);
                if(report == null)
                {
                    return null;
                }
                var fileContent = report.ReportFiles.OrderByDescending(x => x.DateActive).FirstOrDefault();

                if (fileContent != null)
                {
                    var file = fileContent.File;
                    XmlReportSource source = new XmlReportSource();
                    source.Xml = System.Text.Encoding.Default.GetString(file);
                    return source;
                }
            }
            return null;
        }

       
    }

Katia
Telerik team
 answered on 19 Mar 2018
1 answer
542 views

In my current project, ASP.NET Core 2 (on full .Net framework), users will have no use for the Navigate backward, Navigate forward, Toggle parameters, Toggle document buttons. These are disabled but I would like to remove them from the toolbar. Do you have an example on how to do this?

Thanks

Katia
Telerik team
 answered on 19 Mar 2018
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?