Telerik Forums
Reporting Forum
0 answers
108 views

I am having a problem with sorting within a group on my report.  The group needs to sort alphabetically which works, but I want the blank/null values to sort to the bottom of the list.  When I sort alphabetically ascending, the blanks/nulls always go to the top of the sort.

In the datasource, I can make the blank values send in as blank or as null, whichever is needed for this functionality.

I have tried sorting by null, then by name but it still puts the blank/null values at top.

Is there anyway to sort alphabetically ascending with these blank/nulls at the bottom of the list?

Thanks,

Phil

Phil
Top achievements
Rank 1
 asked on 12 Jul 2018
7 answers
409 views
Good morning.

I've been trying to get the demo for Angular CLI working for the last few days. I'm trying the SASS approach and I've noticed that the [templateURL] is consistently running into problems with pulling the telerikReportViewerTemplate-sass.html file in the node_modules/@progress route. I've included both Chrome and Edge errors as the full link shows up better in Edge. I've tried adding ~, ~/, ../, and it seems like anything I try to modify the route and get it working is reversed out by the webpack when I load it. 

As it stands while I'm customized to working with templateURL's in the typescript I'm much less familiar with how the punctuation and other protocol have to work in loading a templateURL within a template and since this is an html page rather css I don't believe a reference in the .angular-cli.json would be useful.

Please take a look at this and let me know if there are any tweaks you see that I'd need to get it up and running.


Thank you.
Silviya
Telerik team
 answered on 11 Jul 2018
3 answers
1.0K+ views

     I am attempting to use the standalone report designer to populate a report from a Web Service Data Source.  The source will return an image as a byte array (byte[] someImage {get;set;}.  I can see the bytes coming from the web service just fine but when I set the bindings to bind the value to the byte array from the web service the report throws an exception that indicates: "Could not find a part of the path...(encoded byte array here".  I am sending in bytes but the picture box is interpreting the value property as only the path and not the bytes.  Is this possible?  Am I doing this incorrectly?  Do I need to use the Visual Studio designer instead?  Any help or guidance would be appreciated...thanks in advance.

Nasko
Telerik team
 answered on 11 Jul 2018
0 answers
164 views

I've got a report with a table and the columns are grouped.

The setup would be something like this

Category 1 - Test         Category 1 details 1

                                     Category 1 details 2

                                     Category 1 details 3

Category 2 - Test          Category 2 details 1

                                      Category 2 details 2

                                      Category 2 details 3

                                      Category 2 details 4

 

I've got my own numbering value that's being passed into the report which produces those details 1, 2 ,3, etc.... And then I go into my group column properties and set sorting to that field = Fields.OrderNum ASC. It seems to only sort the first row and then every other subsequent rows are not sorted so the numbers are all out of place. How would I go about fixing this issue?

 

Thanks

sudo
Top achievements
Rank 1
 asked on 10 Jul 2018
4 answers
1.8K+ views

I have a table that takes in an object data source which returns me back a list of objects that I populate the table row/columns with. 

In one of my row fields I have an expression like this Fields.Description which are grouped together so my table would look a little something like this:

 

---------------------------------------------------------

Col 1        Description

                Description1

                Description2

                Description3

Col 2        Description1

                Description2

                Description3

 

and so forth. I need to close the border at the bottom of the last Descriptions. Need some help getting started on how to apply the conditional formatting so that it will find out which is the data item on each row and then apply a border bottom on that to close the row off.

 

Thanks.

 

sudo
Top achievements
Rank 1
 answered on 10 Jul 2018
1 answer
1.2K+ views

Hello,

I use on asp.net UriReportSource to produce PDF invoice.

The datasource is now set on trdx file, I would like change the method.

I need to pass datasource from code c#, not set on file trdx.

Could you help me ?

Thank you.

public string GetInvoice()
        {
            string fileName = Path.GetTempPath() + (Guid.NewGuid()).ToString() + ".pdf";
            UriReportSource uriReportSource = GetInvoiceUriReportSource();
            ExportToPDF(GetReport(uriReportSource), fileName);
 
            return fileName;
        }
 
        private void ExportToPDF(UriReportSource reportToExport, string fileName)
        {
            ReportProcessor reportProcessor = new ReportProcessor();
            RenderingResult result = reportProcessor.RenderReport("PDF", reportToExport, null);
            using (FileStream fs = new FileStream(fileName, FileMode.Append))
            {
                fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
            }
        }
 
 
        private UriReportSource GetInvoiceUriReportSource()
        {
            UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource();
            if (HostingEnvironment.ApplicationPhysicalPath != null)
                uriReportSource.Uri = HostingEnvironment.ApplicationPhysicalPath + SettingType.TemplateFacture.GetValue();
            else
                uriReportSource.Uri = Directory.GetCurrentDirectory() + SettingType.TemplateFacture.GetValue();
 
             
            return GetReport(uriReportSource);
        }
 
        private UriReportSource GetReport(UriReportSource report, int documentRowId = -1)
        {
                        
 
            report.Parameters.Add(new Telerik.Reporting.Parameter("DocumentID", DocumentId));
            report.Parameters.Add(new Telerik.Reporting.Parameter("DocumentLigneID", documentRowId));
            report.Parameters.Add(new Telerik.Reporting.Parameter("SocieteNom", SettingType.SocieteNom.GetValue()));
            report.Parameters.Add(new Telerik.Reporting.Parameter("SocieteAdresse", SettingType.SocieteAdresse.GetValue()));
            report.Parameters.Add(new Telerik.Reporting.Parameter("SocieteCPVille", SettingType.SocieteCPVille.GetValue()));
            report.Parameters.Add(new Telerik.Reporting.Parameter("SocieteSiret", SettingType.SocieteSiret.GetValue()));
            report.Parameters.Add(new Telerik.Reporting.Parameter("SocieteTEL", SettingType.SocieteTEL.GetValue()));
 
            
 
            return report;
        }

 

 

Nasko
Telerik team
 answered on 10 Jul 2018
1 answer
223 views

      Hi, 

 

I am trying to show multiple reports in a reportbook object in WPF

However , I do not get any ReportSources Collection on my reportbook object , only the reports collection.    When I try to use report instead of TypeReportSource it tells me Report is obsolete and I must use ReportSource .  I have a standard WPF window, with a reportviewer object but now I want to use a reportbook object to show multiple reports.

 

var reportViewerWnd = new ReportBookViewerWnd();
            var report = new Telerik.Reporting.Report();

            var reportBook = new Telerik.Reporting.ReportBook();

            var typeReportSource = new Telerik.Reporting.TypeReportSource();
            typeReportSource.TypeName = "Schedwin.Reports.Tickets.PassengerTickets, Schedwin.Reports.Telerik";
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("ReservationIDX", ReservationIDX));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("ReservationName", ReservationName));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("PaxName", PaxName));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("TicketNo", TicketNo));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("IssuedBy", IssuedBy));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("IssuedDate", IssueDate));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("IssuePlace", IssuePlace));
            typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter("RegionalDBName", DatabaseName));
       
   

            reportBook.Reports.Add(typeReportSource);

            reportViewerWnd.ReportViewer.ReportSource = reportBook;
            reportViewerWnd.Title = "Passenger Ticket";

Nasko
Telerik team
 answered on 10 Jul 2018
2 answers
752 views

Hi..

How do you set a subreports ReportSource to a List<>?

 public List<uspGet_POs_DETResult> po_det { set; get; }

 

 

this.subReportDetail.ReportSource = po_det;

 

 

SeverityCodeDescriptionProjectFileLineSuppression State
ErrorCS0029Cannot implicitly convert type 'System.Collections.Generic.List<uspGet_POs_DETResult>' to 'Telerik.Reporting.ReportSource'


Jonathan
Top achievements
Rank 1
Iron
Veteran
 answered on 10 Jul 2018
1 answer
198 views

I have installed visual studio 2015 as well as the telerik reporting which is correctly detecting that I have VS2015.  In VS2015 there is no telerik menu and there is no item template for creating a new report . 

 

Please help

Silviya
Telerik team
 answered on 10 Jul 2018
5 answers
874 views
Hello,

Can we do rotated text labels in Telerik Reporting? i.e. 90 degrees/sideways...

I have 15 columns with 1 character in them, what is the best way to implement this? Rotated headings would be perfect. I have to fit this in for printing.

Best regards.
Silviya
Telerik team
 answered on 10 Jul 2018
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?