Telerik Forums
Reporting Forum
2 answers
185 views

Hi,

I am using Web Service data source to generate a report with Crosstab. 

Below is my sample data from Web Service:

{
    "totalCount": 3,
    "dataSet": [
        {
            "Department": "Dept1",
            "Type": "Type1",
            "Amount": "10"
        },
        {
            "Department": "Dept1",
            "Type": "Type2",
            "Amount": "50"
        },
        {
            "Department": "Dept2",
            "Type": "Type1",
            "Amount": "15"
        }
    ]
}

It supposed to generate 2 columns and 2 rows in Crosstab, but it shows only first record and in Grand total column, it is showing 2 grand total in same column. (Please refer to my screenshot)

I also attached my datasource binding and fields in Crosstab.

Please help.

Thank you.

 

 

Yana
Telerik team
 answered on 19 Aug 2020
5 answers
350 views

Hi,

I want to set Grid Lines when we do Export to Excel from Telerik Reports. But I did not find any such property to set for Excel.

Is there any way to do same?

Thanks & Regards,

Anu

Silviya
Telerik team
 answered on 19 Aug 2020
3 answers
412 views

Hi,

       I have a table in group header section. I give the following command in the bin dings of each row of that table.

Visible - IIf(COUNT(1)>0,true,false)

The above expression is working well for table. But still the group header section is generating with empty space.

Which means there are some space above the detail section while preview the report.

I give the same binding for the group header section Visible - IIf(COUNT(1)>0,true,false) 

But it is not work for group header section. What can i do now. Please suggest a solution. Thanks. :-) 

Yana
Telerik team
 answered on 17 Aug 2020
3 answers
470 views

Hello,
I created 6 report files. Each file has its own table, text description and chart. I added these 6 files into a Report Book.

Now I have a question, how do I make a table of contents to correspond to these title in these files, the directory may be similar to the picture

 

Thanks

Yana
Telerik team
 answered on 17 Aug 2020
8 answers
720 views
Hi,

I am using telerik.reporing in my apllication. It was working fine before. But in the morning a strange thing happened, when user clicked the report page, the system displayed an error message 'Parameter is not valid'. I am using telerik:reportviewer to view the report. There was nothing code changed in the server. I do not know what happen, Is there anything would cause this error for telerik report?

Thanks,
Karim
Top achievements
Rank 1
 answered on 17 Aug 2020
1 answer
290 views
I am having a problem with margins when printing my report. I can reproduce the issue by creating a new report, setting the background color of the report header to light gray, and printing it from the designer. By default, my newly created report uses a 1" margin all around and has a width of 6.46". When I print a hard copy of the report, the top and left margins are always larger than the bottom and right margins. Per my measurements, the left margin ends up ~1.125" and the right margin is ~0.875, a 0.25" difference. This becomes more of a problem when I use the 0.25" margins that my customers prefer and things get cut off on the right side (they do not roll over onto another page). Interestingly, printing to a file (using CutePDF or the MS Office Image Writer) or exporting to PDF does not produce the same issue (even if I print the PDFs with no page scaling).

I'm thinking I must be missing something, or someone else would have noticed this already (maybe it's just that my forum search skills are lacking??). I'd like to re-iterate that I am printing these from the report designer in Visual Studio because we have not yet been able to get the printing working from the Silverlight report viewer. I'd also like to note that our reports are in their own project and that I've tested this on 3 different printers.

Anyone seen this before or have any other ideas?

Thanks,

Adam
LAxmikant
Top achievements
Rank 1
 answered on 13 Aug 2020
7 answers
714 views

Hi,

I'm porting an old reporting system to Telerik, and I need to adapt the old data provider strategy to a Telerik DataSource that I can use with a Telerik Report.

None of the DataSources provided suit my needs, so I'm thinking about implementing my own extension of DataSource abstract class. I didn't find any suggestion about that in the documentation; is it possible?

 

Thanks in advance and best regards.

GodHank
Top achievements
Rank 1
 answered on 13 Aug 2020
7 answers
1.3K+ views

I have designed a Telerik report, when printing the report from report viewer, its taking some unique id on the print queue.

How do I document name when printing in Telerik Report viewer.
I found this link when googling,

 http://docs.telerik.com/reporting/m-telerik-reporting-processing-reportprocessor-printreport
but i dont know when it will be called ? where to use this?

GodHank
Top achievements
Rank 1
 answered on 13 Aug 2020
1 answer
243 views

Hello,
We are using Telerik Reporting version R2 2020.
In our app to show report we use HTML5 Report Viewer and Web Report designer. Our project based on .Net Core 3.1. Currently, the report viewer is working fine but we have a problem with a web designer. I tested report web designer with a web page using the Chrome browser and it is not working fine. It shows some error messages when loading some report items. For example in my sample project I'm trying to open barcode report with report web designer. After a few seconds It shows some error messages saying "Could not generate the preview of 'barcode N'" (N - barcode number).  

You can see this from the attached picture file. I could not attache my sample project because it allows only picture file.

Here my Startup file.

    public class Startup
    {
        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            services.AddCors(o => o.AddPolicy("AllowOrigin", builder =>
            {
                builder.AllowAnyOrigin().AllowAnyHeader().AllowAnyMethod();
            }));

            //This is for showing picture
            services.Configure<IISServerOptions>(options =>
            {
                options.AllowSynchronousIO = true;
            });

            services.AddRazorPages()
                .AddNewtonsoftJson();

            //Designer
            // Configure dependencies for ReportServiceConfiguration.
            services.TryAddSingleton<ConfigurationService>(sp => new ConfigurationService(sp.GetService<IWebHostEnvironment>()));
            services.TryAddScoped<IReportSourceResolver>(sp =>
                new TypeReportSourceResolver().AddFallbackResolver(new UriReportSourceResolver(
                    Path.Combine(sp.GetRequiredService<ConfigurationService>().Environment.WebRootPath, "Reports"))));
            services.TryAddScoped<IReportServiceConfiguration>(sp =>
                new ReportServiceConfiguration
                {
                    ReportingEngineConfiguration = sp.GetRequiredService<ConfigurationService>().Configuration,
                    HostAppId = "Html5DemoAppCore",
                    Storage = new FileStorage(),
                    ReportSourceResolver = sp.GetRequiredService<IReportSourceResolver>()
                });

            // Configure dependencies for ReportDesignerServiceConfiguration.  
            services.TryAddScoped<IDefinitionStorage>(sp => new FileDefinitionStorage(Path.Combine(sp.GetRequiredService<ConfigurationService>().Environment.WebRootPath, "Reports")));
            services.TryAddScoped<IReportDesignerServiceConfiguration>(sp => new ReportDesignerServiceConfiguration { DefinitionStorage = sp.GetRequiredService<IDefinitionStorage>() });
        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
        {
            app
             .UseRouting()
             .UseCors("AllowOrigin")
             .UseDefaultFiles()
             .UseStaticFiles()
             .UseEndpoints(config =>
             {
                 config.MapControllers();
             });
        }
    }

    public class ConfigurationService
    {
        public ConfigurationService(IWebHostEnvironment environment)
        {
            this.Environment = environment;
            var configFileName = System.IO.Path.Combine(environment.ContentRootPath, "appsettings.json");
            var config = new ConfigurationBuilder()
                            .AddJsonFile(configFileName, true)
                            .Build();
            this.Configuration = config;
        }
        public IConfiguration Configuration { get; private set; }
        public IWebHostEnvironment Environment { get; private set; }
    }

Can someone help me to solve this problem?
Thank you,



Nasko
Telerik team
 answered on 12 Aug 2020
13 answers
559 views
We have a multilingual report that generates report in English and Mandarin (Chinese).

Initial generation of the reports works well. The reporting control displays the reports in both languages in html format. When we attempt to export into pdf following error occurs

[NotSupportedException: Font Arial Unicode MS 12 Bold is not supported.]
   Telerik.Reporting.Pdf.Fonts.TrueType.FontReader.GetFontData(Font font, Boolean& isTTC) +466
.....


Additionally though the export to rtf;excel works excellent in either of the languange. We are using resx files for multilingual capabilities.

Any help would be greatly appreciated. Struggling with this issue for a certain time now.
Nilesh
Top achievements
Rank 1
 answered on 11 Aug 2020
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?