Telerik Forums
Reporting Forum
1 answer
724 views

Hello,

I'm having an issue displaying data on the report I have.

I am using ReportDesigner tool to create report file which I want to be rendered however, when If I add text =Fields.WeekStartDate or =Fields.Lines im not getting anything.

 

This what I have:

Report is rendered by using ReportResolverBase class method: ReportSource ResolveReport()

protected override ReportSource ResolveReport(string reportId)
{
    return reportHelper.GetReportSource(reportId);
public ReportSource GetReportSource(string reportId)
{
    var reportSource = new InstanceReportSource();
    reportSource.ReportDocument = Telerik.Reporting.Report Report;
    report.DataSource = new ObjectDataSource(model, null); // model structure below
}
 
var model = new List<Foo>();
class Foo {
    public string WeekStartDate { get; set; }
    public string Year { get; set; }
    public string WeekOfTheYear { get; set; }
    public IEnumerable<Bar> Lines { get; set; }
}
class Bar {   
    public string DueDate { get; set; }
    public string EQCode { get; set; }
    public string EQDescription { get; set; }
    public string WSDescription{ get; set; }
}

 

My ultimate goal is to display Foo items on separate pages something like that:

DetailSection:

WeekStartDate ........................................ Year ....................... WeekOfTheYear............................

DueDate EQCode EQDescription WSDescription

DueDate EQCode EQDescription WSDescription

DueDate EQCode EQDescription WSDescription

DueDate EQCode EQDescription WSDescription (for each Line)

is there a way to achive that?

 

Thanks in advance!

Todor
Telerik team
 answered on 21 Feb 2018
2 answers
202 views

Hi,this is my first time using Telerik Reporting and having some problems....

I added to my Solution a "Telerik Reporting Library R1 2018"

Then added a EDMX file with a couple of tables. Then add a Report "Report1.cs"

Using the Report Designer on Visual Studio:

1.- Add a Entitity DataSource (using the EDMX added before).

2.- Using a table wizard to see the rows of a Table.

When i Press "Preview" tab it shows this error:

Each table row and column maintains a minimum size, resulting in a minimum table
size of {Width=10px, Height=10px}.

And if I try to render it (using c#) to PDF the pdf shows this error too:

An error has occurred while processing Table 'table2':
An error has occurred while resolving 'entityDataSource1' data source: An error occurred while invoking data
retrieval method.
------------- InnerException -------------
No connection string named 'SAOO_ProductionEntities' could be found in the application config file.

But my application Config has the line with the 

<add name="SAOO_ProductionEntities" ..../>

So, wich is the problem? Telerik Reporting have been installed with the MSI package.

Thanks.

 

Jaime
Top achievements
Rank 1
 answered on 21 Feb 2018
0 answers
134 views

Hello, I'm using: Telerik Report Designer (Versión 8.2.14.2017). My issue:

I need to display every record to start on a new page, for example, if Item "1" needs 1.5 pages to be dispalyed, then the next Item "2" must start in page 3 (not in page 2) and so on...

I have a Group Header Section and also a Group Footer Section and they are working as espected.

I have tried a lot of combinations on PageBreak and Keep Together properties and is not working.

Regards, thanks for your help.

David

David
Top achievements
Rank 1
 asked on 19 Feb 2018
0 answers
191 views

There is a way to customize the report with LINQ?

I did this but I made it work

public class ReportController : Controller
    {
        // GET: Report
        public ActionResult Index()
        {
            Uri uri = HttpContext.Request.Url;
            var changeReport = new ReportController().Identification(1, uri);
            return View(new ReportModel() { TheReport = changeReport});
        }

@(Html.TelerikReporting().ReportViewer()
            .Id("reportViewer1")
            .ServiceUrl(Url.Content("~/api/reports"))
            .TemplateUrl(Url.Content("~/Content/ReportViewer/templates/telerikReportViewerTemplate.html"))
            .ReportSource(Model.TheReport)
            .ViewMode(ViewMode.Interactive)
            .ScaleMode(ScaleMode.Specific)
            .Scale(1.0)
            .PersistSession(false)
            .PrintMode(PrintMode.AutoSelect)
            .EnableAccessibility(false)
            .Deferred()
    )

//This is what I do

DBContext db = new DBContext();

            var data = db.Patient.FirstOrDefault();
            var name = data.FirstName + " " + data.LastName;

var txtName= ((Telerik.Reporting.TextBox)report.Items.Find("txtName", true)[0]);
                txtName.Value = !string.IsNullOrEmpty(name) ? name.Trim() : empty;

// in asp.net webforms I did it this way and it worked

var instanceReportSource = new Telerik.Reporting.InstanceReportSource {ReportDocument = report};
                ReportViewer.ReportSource = instanceReportSource;
                ReportViewer.RefreshReport();

Does anyone know how to do this in asp.net mvc?

 

 

Luis Ismael
Top achievements
Rank 1
 asked on 19 Feb 2018
0 answers
135 views

Hello, someone has some idea how to customize reporting

I do the following

 @(Html.TelerikReporting().ReportViewer()
            .Id("reportViewer1")
            .ServiceUrl(Url.Content("~/api/reports"))
            .TemplateUrl(Url.Content("~/Content/ReportViewer/templates/telerikReportViewerTemplate.html"))
            .ReportSource(Model.TheReport)
            .ViewMode(ViewMode.Interactive)
            .ScaleMode(ScaleMode.Specific)
            .Scale(1.0)
            .PersistSession(false)
            .PrintMode(PrintMode.AutoSelect)
            .EnableAccessibility(false)
            .Deferred()
    )

public class ReportController : Controller
    {
        // GET: Report
        public ActionResult Index()
        {
            Uri uri = HttpContext.Request.Url;
            var changeReport = new ReportController().Identification(1, uri);
            return View(new ReportModel() { TheReport = changeReport});
        }
             // Controls

    
            var txtName = ((Telerik.Reporting.TextBox)report.Items.Find("txtName ", true)[0]);
            txtName.Value = !string.IsNullOrEmpty(name) ? name.Trim() : empty;

Luis Ismael
Top achievements
Rank 1
 asked on 19 Feb 2018
0 answers
57 views
I am using two tables in detail section and the output I want is to appear one at  a time. The output I am having is attached below although what I want is to look like something like this.

Allowance                                 Leave
Bonus                                       Annual Leave     2
Increment                                 Casual Leave     4
Muhammad
Top achievements
Rank 1
 asked on 19 Feb 2018
1 answer
178 views

I'm using: Telerik Reporting Q1 2015 v9.0.15.422

I have some data that is duration information (TimeSpan to be specific). I want to show duration in h:mm:ss  so that we can sum up durations in spreadsheet. However, I'm only able to show duration in hh:mm:ss format which can't be summed up in spreadsheet.  Is there any way to show TimeSpan in h:mm:ss format?

Nasko
Telerik team
 answered on 19 Feb 2018
5 answers
141 views

When I press zoom in or zoom out in HTML5 viewer, the element trv-report-page has set height: 0px; width;0px

I'm using Firefox 58.

When I disable width,height in css inspector all looks ok.

Without disabling report is gone. (hidden)

Silviya
Telerik team
 answered on 16 Feb 2018
2 answers
521 views

Hi,

I'm creating report where table1 contains another table2 and these tables bind to a data (Layout.png). Tha data for table2 can be empty and it needs to be callapced. But report generates empty space for table2 if there is no data (Table space.png). I've tried to set the CanShrink = True for textbox2, to add the ConditionalFormatting to set the Visibility = False if there is no data for table2. But it does not work.

How can I hide the empty space?

Thank you,

Yuri.

 

 

Todor
Telerik team
 answered on 16 Feb 2018
1 answer
228 views

I'm upgrading a Production version of our Reporting App that is using version 10.1.16.615 to the newer 11.0.17.222. There are numerous changes although I have not touched one type of reports, but with the new version .dll's I'm getting "Invalid value of report parameter" (see attached screenshot) on those. These reports all have approximately 50 sub-reports, logo's and the typical Header/Footer combination, in other words, they are complex reports. The other 2/3 of reports display correctly, but these give me the error.

Any help would be appreciated. Thank you,

Jack

Todor
Telerik team
 answered on 16 Feb 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?