Telerik Forums
Reporting Forum
1 answer
70 views
i am using telerik reportviewer to display data and export it to many format i am facing a problem when the number of rows in the report is too large. the rows are too close to eachother and are such hiding eachother any way to solve this problem.
Peter
Telerik team
 answered on 17 Nov 2011
1 answer
193 views
I'm trying to exprt a simple table to csv, reduced the report to column headers and table fields only, but the output is somewhat odd:
- the column headers in csv are the names of the TestBoxes
- the rows contain fields for each fieldname and each value, looks altogether like this:

nameCaptionTextBox,valueCaptionTextBox,nameDataTextBox,valueDataTextBox
Name,Value,WebServiceModule.MpdConfigFilePath,
Name,Value,MaximumThreadCount,120
Name,Value,DeviceModule.QueueMaxAge,02:00:00
Name,Value,SvlDebugModule.Debug,false

thats what I would expect:

Name,Value,
WebServiceModule.MpdConfigFilePath,
MaximumThreadCount,120
DeviceModule.QueueMaxAge,02:00:00
SvlDebugModule.Debug,false

Any ideas what went wrong, or is this by design?


Steve
Telerik team
 answered on 17 Nov 2011
1 answer
116 views
I am trying to build a Profit & Loss Statement using a crosstab and I have not been able to determine if I can insert calculated values between certain groups.  The first jpg shows an example of the data returned by my query.  The other jpg shows where I need to add custom calculations between certain groups. (This example does not show the mutliple monthly columns of the crosstab.)

For example: "Net Revenue" = Total of "Revenue" group - total of "Adjustment" group.

So, it is possible to insert rows between groups in a crosstab? Any help would be greatly appreciated.

Thanks,
Mark
Peter
Telerik team
 answered on 16 Nov 2011
1 answer
114 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!
Steve
Telerik team
 answered on 16 Nov 2011
10 answers
399 views
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

 

)
Richard
Top achievements
Rank 1
 answered on 15 Nov 2011
7 answers
120 views
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                                                                                                  ________




______________________________________________________________________________












Bob Mills
Top achievements
Rank 2
 answered on 15 Nov 2011
2 answers
131 views
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();  
}  
 
Andrea
Top achievements
Rank 2
Iron
 answered on 15 Nov 2011
2 answers
85 views
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!
CHEN
Top achievements
Rank 1
 answered on 15 Nov 2011
6 answers
168 views
When I set the theme to metro everything just goes black on the report viewer. Is there any plans to support this theme?

Robert
Andrew
Top achievements
Rank 2
 answered on 14 Nov 2011
3 answers
141 views
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
Elian
Telerik team
 answered on 14 Nov 2011
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?