Telerik Forums
Reporting Forum
3 answers
677 views
hi...

I have attached screen shots of my reports below.
First screen shot is our existing report that have been created using crystal report
Now we want to recreate this report using telerik reports.
second image is new telarik report
I was able to create the report using textbox to make it look like old one, but I cannot continue the boarders in white space between the group footer section and report footer where I display the total values.

I have attached screen shots of sample project I created.
In 3rd image design view I placed group footer and page footer together but when rendering white space is created between group footer and page footer
How can I remove the white space between group footer and page footer?, or  move the group footer to the end of the report.
Nasko
Telerik team
 answered on 16 Jul 2018
1 answer
436 views
Hi Team,

I am developing a report in standalone report designer. I have added a table and a SQL server data source. When I configure the data source and provide a SQL query and click execute in the configure box, the query fetches the data. But when I publish the report to the server and web preview it gives below error-

"An error has occurred while processing Table 'table1':

A network-related or instance-specific error occurred while establishing a 
connection to SQL Server. The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured to 
allow remote connections. (provider: TCP Provider, error: 0 - No such host is 
known.)
------------- InnerException -------------
No such host is known"

Could you please help?

Regards,

Ashwini
Silviya
Telerik team
 answered on 16 Jul 2018
2 answers
96 views

Hi,

Is it possible for the ReportViewer to use your RadSaveDialog during exportation.

 

Thanks

Marc

Marc-Andre
Top achievements
Rank 1
 answered on 14 Jul 2018
1 answer
425 views

Helllo All,

I have been working with Telerik Windows Forms.

I already migrated a project from Silverlight Viewer to Windows Forms viewer, the issue that I have is when I print a report the print dialog does not contain an option to shrink oversized reports to letter size.

The option was available on Silverlight.

Is there any configuration to perform the shrink automatically in execution time? We have a lot of reports with different sizes but  we want to avoid modifying all the reports format.

 

Thanks in advance.

Silviya
Telerik team
 answered on 13 Jul 2018
0 answers
118 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
427 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
172 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.9K+ 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
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Iron
Iron
Andrey
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?