Questions on Reporting Forum

1 answer

120 views

Dear Support,

During Development we've been confronted with a question of our customer concerning the navigation of the report viewer.
The reports created by us always consists of 3 or 4 sub-reports. Is it possible to change the navigation from arrows to direct links?

For explanation:

How it currently looks like: http://temp.mobile.at/telerik/ReportViewer1.jpg
How we want it to look like: http://temp.mobile.at/telerik/ReportViewer2.jpg

Thanks in advance!

General Discussions

answered on 16 Nov 2011

10 answers

430 views

OCIEnvCreate failed while processing a Telerik report in design mode

Unable to discover a solution to this issue in other forum posts. I have an VS2010 Framework 4 ASP.Net application that uses a Telerik report. I actually have two problems to solve today.

1) I started out to fix a bug where the report parameter seems to have been ignored for a master/detail report. The data coming back is the record related to the default parameter value.

2) In the process if trying to get back into Design mode, I am forced to comment out the connection string code in Sub New() for the master report and all sub reports. After doing this and setting the default parameter to zero I now get the OCIEnvCreate failed error and can't find out how to resolve it. Oracle Home is not the problem as it worked fine in Design mode and App mode before I commented out the connection string code. I also validated that the connection string in app.config had the correct userid and password (I had changed the userid to something invalid so that I could certify that the report was using the web.config connection string at runtime vs the app.config string used at Design time.) It is in fact correct.

The (commented out) code in the Master report is given below. All subreports (there are five of them) have the identical code sans the property code.

I have to say this is extremely irritating and frustrating to have to comment and uncomment these code snippets to work in design vs run mode. I consider this a bug, and it really needs to be fixed. It's a major source of wasted development time. Once things get bollixed up one has to 'Clean' the project, recompile, sometimes exit the IDE and restart it, and in two cases last week I had to restore files from the day before to get back to a certain starting point.

If anyone knows a solution to this issue, I would be extremely grateful for any help that can be rendered!

Regards,

Rich

(

Partial

Public Class RequisitionMasterReport

Inherits Telerik.Reporting.Report

Public Sub New()

InitializeComponent()

'Me.DataSource.ConnectionString = ConfigurationManager.ConnectionStrings("WFL_TelerikReports").ConnectionString

'Me.DataSource.ProviderName = ConfigurationManager.ConnectionStrings("WFL_TelerikReports").ProviderName

End Sub

Public Property RequisitionObjectID As Integer

Get

Return Me.ReportParameters("ReqOI").Value

End Get

Set(ByVal value As Integer)

Me.ReportParameters("ReqOI").Value = value

End Set

End Property

End

Class

)

General Discussions

answered on 15 Nov 2011

7 answers

122 views

GroupFooter needs to be page footer

Hi.. How can make the GroupFooter be the Page Footer... so It always prints on the bottom of each page.
I'm trying to create a report that prints checks.   The top portion of the report is the invoices being paid. They are aligned to the top.
The bottom of the report is the actual check. Aligned to the bottom of the page.
The data is grouped by Vendor... but I can't align the groupfooter to the bottom so it prints 'on the check'
Any ideas how I can get this to work.   Thanks.

The data looks like this.

INVOICE DATE     VENDOR                    INVOICE NUMBER               AMOUNT
10/1/2010             ABC                                       100                                      $100.00
10/2/2010             ABC                                       101                                     $200.00

GROUPED BY VENDOR

CHECK AMOUNT   $300

The Check Form Looks like this....
____________________________________________________________________
Date      check #    Invoice                                                            Amount

____________________________________________________________________________
Total
_____________________________________________________________________________

                                                                                                                Check # 101
Check Date
       to the order of                                                                                                  ________

______________________________________________________________________________

General Discussions

answered on 15 Nov 2011

2 answers

135 views

HtmlTextBox server side binding

When I try to bind an HtmlTextBox server side no data is displayed on the report, I don't know when this stopped working because a client of mine just reported it happening after my last update to his system using the latest telerik Reporting build. This was working fine before that.

Here's the code, I can't find anything wrong with it.

    
            private void GetAppointments()  
        
            {  
        
                StartDate = new DateTime(2008, 10, 1);  
        
                EndDate = new DateTime(2008, 11, 1);  
        
                MemberId = 10;  
        
                Priority = null;  
        
                Color = null;  
        
                EmployeeId = null;  
        
                appointments = (from a in _context.Appointment  
        
                                where a.Start >= StartDate &&  
        
                                    a.End < EndDate &&  
        
                                    a.WorkOrderId > 0 &&  
        
                                    (a.MemberId.Equals(MemberId) || MemberId == null) &&  
        
                                    (a.WorkOrder.Job.Priority.Equals(Priority) || Priority == null) &&  
        
                                    (a.Color.Equals(Color) || Color == null) &&  
        
                                    (a.WorkOrder.WorkOrderResourceList.Select(r => (long?)r.EmployeeId).ToList().Contains(EmployeeId) || EmployeeId == null)  
        
                                orderby a.Start  
        
                                select a).ToList();  
        
            }  
        
            void Schedule_NeedDataSource(object sender, EventArgs e)  
        
            {  
        
                GetAppointments();  
        
                tblAppointments.DataSource = appointments;  
        
            }  
        
            void htmlWorkOrdeDetails_ItemDataBound(object sender, EventArgs e)  
        
            {  
        
                Telerik.Reporting.Processing.HtmlTextBox details = (Telerik.Reporting.Processing.HtmlTextBox)sender;  
        
                var workOrder = details.DataObject["WorkOrder"] as Entities.WorkOrder;  
        
                var color = (AppointmentColor)details.DataObject["ColorAppointmentColor"];  
        
                var subject = (string)details.DataObject["Subject"];  
        
                var workOrderDetails = new System.Text.StringBuilder();  
        
                if (workOrder != null)  
        
                {  
        
                    var job = workOrder.Job;  
        
                    var jobSite = job.Address;  
        
                    var customer = job.Customer;  
        
                    var resources = string.Empty;  
        
                    switch (workOrder.AssignedToType)  
        
                    {  
        
                        case 0:  
        
                            resources = "Not Assigned";  
        
                            break;  
        
                        case 1:  
        
                            resources = string.Join(", ", workOrder.WorkOrderResourceList.Select(r => (r.Employee.FirstName + " " + r.Employee.LastName)).ToArray());  
        
                            break;  
        
                        case 2:  
        
                            resources = workOrder.AssignedToContractor.Name;  
        
                            break;  
        
                    }  
        
                    workOrderDetails.Append("<div style='background-color: white'>");  
        
                    workOrderDetails.AppendFormat("<b>Work Order # {0}</b><br/>", workOrder.Number);  
        
                    workOrderDetails.AppendFormat("<b>Job Site:</b> {0}, {1}, {2}. {3}<br/>", HttpUtility.HtmlEncode(jobSite.AddressMember), HttpUtility.HtmlEncode(jobSite.City.Name), jobSite.State.Abbreviation, jobSite.ZipCode.ZipCodeMember);  
        
                    workOrderDetails.AppendFormat("<b>Customer:</b> {0}<br/>",HttpUtility.HtmlEncode(customer.Name));  
        
                    workOrderDetails.AppendFormat("<b>Job Name:</b> {0}<br/>", HttpUtility.HtmlEncode(job.Name));  
        
                    workOrderDetails.AppendFormat("<b>Assigned To:</b> {0}<br/>", HttpUtility.HtmlEncode(resources));  
        
                    workOrderDetails.AppendFormat("<b>Notes:</b> {0}", string.IsNullOrEmpty(subject) ? "N/A" : HttpUtility.HtmlEncode(subject));  
        
                    workOrderDetails.Append("</div>");  
        
                }  
        
                details.Style.BorderWidth.Default = new Unit(1);  
        
                details.Style.BorderColor.Default = ColorTranslator.FromHtml(color.Name);  
        
                details.Style.BackgroundColor = ColorTranslator.FromHtml(color.Name);  
        
                details.Value = workOrderDetails.ToString();  
        
            }

General Discussions

answered on 15 Nov 2011

2 answers

92 views

chinese can't be printed!

when I use telerik reporting trial version to generate report which contains chinese, all texts are wrong displayed.
It seems the encoding isn't correct , but i can't figure out how to set the encoding.
I need your help , thanks!

General Discussions

answered on 15 Nov 2011

6 answers

175 views

ReportViewer metro theme

When I set the theme to metro everything just goes black on the report viewer. Is there any plans to support this theme?

Robert

General Discussions

answered on 14 Nov 2011

3 answers

149 views

Additional/External Fonts Issue

We have MICR Fonts(Fonts for checks) , after installing these fonts we get to see/apply them in fields of Telerik report. Testing reports on running projects also show the fields in MICR fonts, Our live site do not show the report with these fonts whereas we installed font on server also, need your assistance in confirming if the additional fonts working with Telerik reports on live server require some other step

Thanks in advance,

Babita Banerjee

General Discussions

answered on 14 Nov 2011

3 answers

220 views

Problem with DataContext with Q1

Hello!
I just update my reporting here, and It won't return the DataContext...
that was my code:

private ReportViewerModel Model

{

get { return DataContext as ReportViewerModel; }

}

I tried to use this code snippet, but still don't work, 'coz I calling the DataContext in a partial class who complements the ReportViewer class

var layoutRoot = (FrameworkElement)VisualTreeHelper.GetChild(this.ReportViewer1, 0);

var rvm = (ReportViewerModel)(layoutRoot.DataContext);

I need to call the DataContext to print my report.. I can see it, in reportviewer, but can't print...
There's something I can do?

General Discussions

answered on 14 Nov 2011

4 answers

261 views

Functionality like master - detail nested grid?

With the GRID asp.net component you can set up a nested grid so that each row in the master table has a nested detail table under it. I would like to reproduce this functionality in a report that is only intended for PDF output so no collapsing is necessary. This is for a assembly ticket that shows part kits to be assembled and their component parts. So it looks something like this

MASTER: Bin - Part Number - Description - Qty Ordered - Qty Backordered - UOM
MASTER: Bin - Part Number - Description - Qty Ordered - Qty Backordered - UOM
Detail:    Bin - Component Part - Quantity - UOM
Detail:    Bin - Component Part - Quantity - UOM
Detail:    Bin - Component Part - Quantity - UOM
MASTER: Bin - Part Number - Description - Qty Ordered - Qty Backordered - UOM
Detail:    Bin - Component Part - Quantity - UOM

Note that sometimes a part may not have any components, so nothing would need to be shown under those.

Ideally the master table and the detail tables would have separate datasources just like the GRID implementation.

Wish so may options (crosstabs, subreports etc... ) it's hard to get started down the right path. Can someone point me in the direction of a tutorial or sample of a solution of a solution for this?

General Discussions