Telerik Forums
Reporting Forum
1 answer
127 views

Hi everyone,

My report.trdp include 2 hidden parameters (A,B) and 2 not hidden parameters (C,D)

my PM want when user create new task in scheduling feature on my reporting server then click to parameters tab

The expectation here is:

   2 hidden parameters (A,B)  NOT auto select  "Use default value" check box

   2 not hidden parameters (C,D) AUTO SELECT  "Use default value"  check box

so Is there any way to do that?

1 answer
179 views

Hello, 

I'm new to Telerik Reporting and I was trying to check if it was possible to show custom data in a table in Reporting.

Now I have seen posts where it was mentioned that this was possible...but unfortunately I was unable to make it work at my end.

In my sample....I have already designed a template which has a blank table. Now I was trying to populate the table with data dynamically, but it didn't seem to work.

I am able to view the data from a RDBMS server and  display it in “Preview” Mode in the reporting tool, but this is not what I want.

 

Here is my code.

int[,] arr = new int[2, 2];
arr[0, 0] = 0;     arr[0, 1] = 1;    arr[1, 0] = 2;      arr[1, 1] = 3;

var reportPackager = new Telerik.Reporting.ReportPackager();
using (var sourceStream = System.IO.File.OpenRead("SampleReport.trdp"))
{
    var report = (Report)reportPackager.UnpackageDocument(sourceStream);
    Telerik.Reporting.Table table = report.Items.Find("table1", true)[0] as Telerik.Reporting.Table;
     table.DataSource = arr;

}

Can someone point me to some sample code where something like this might be happening so that I can understand where I might be wrong?

Any help would be appreciated.

Thank you!

 

 
Todor
Telerik team
 answered on 18 Aug 2021
1 answer
179 views

I'm working in a project with AspNet Core 3.1 and Postgres 13, with Npgsql-3.2.7 controller for the conection to my data base in Telerik Report Designer App Desktp. When use a DataSource in said application with default values in the parameters to a stored procedure in postgres, does WORK CORRECTLY, But, when I try use the Report in My AspNet Core MVC application running, sending the parameters like they documentation, the values aren't received in a postgres Stored Procedures. Instead they recieve null value.

Could you help us, and tell us if there are any extra settings that we are missing, or why this situation occurs?

Todor
Telerik team
 answered on 17 Aug 2021
6 answers
1.8K+ views

Hi,

We are starting to use the Reporting Web Designer. We need to implement custom report storage as explained here: https://docs.telerik.com/reporting/how-to-implement-a-report-definition-storage

 

This method: public byte[] GetDefinition(string definitionId) { // Retrieve the report definition bytes from the database. } needs to return byte array of the report.

I have tried converting the report object to byte[] using serialize as shown here https://stackoverflow.com/questions/4865104/convert-any-object-to-a-byte/45402065. But it says that Report object is not serializable.

System.Runtime.Serialization.SerializationException: 'Type 'Telerik.Reporting.Report' in Assembly 'Telerik.Reporting, Version=14.0.20.219, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' is not marked as serializable.'

 

Is there any specific byte[] serializers available with your API? I see there is ReportXmlSerializer to convert it to xml.

 

Thanks,

Tommy
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 16 Aug 2021
5 answers
493 views

I implemented custom DbDefinitionStorage from your example (https://docs.telerik.com/reporting/how-to-implement-a-report-definition-storage).

Designer is working, but when I press "Preview" button I got "Unable to get report parameters. Report 'Barcodes%20Report' cannot be resolved."

Also, how to configure Web Report Designer to work only with one report (no "Open", "New", "Save As" and etc.)

Tommy
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 16 Aug 2021
1 answer
135 views
When the ReportViewer is opened, 3 requests are sent: register client, create instance, create document. But when closed, none of the following requests are sent: unregister client, delete instance, delete document. Is there any way to send these requests from the UI?
Neli
Telerik team
 answered on 13 Aug 2021
1 answer
847 views

I need to implement a custom report resolver that will return an instance report source as the report source.

The inherited ResolveReport method from ReportSourceResolverBase in CustomReportSourceResolver is called 3 times (with 3 requests sent: client registration, instance creation, document creation) => 3 times a ReportSource instance is created, which is undesirable, since it is necessary that it be created once when you open the ReportViewer.

Is there some way to implement this behavior?

Dimitar
Telerik team
 answered on 12 Aug 2021
1 answer
426 views

Hey all, so I have this report which is basically to show how many staff members (count) are working inside a company on different characteristics like gender, city and education level.

For example:

                   ------  School 1  ------                 ------  School 2    ------                  ------  School3  ------  

                Male       ------        Female         Male       ------        Female           Male       ------        Female

City 1       box                          box                 box                             box             box                         box

City 2      box                          box                 box                             box             box                         box

City 3       box                          box                 box                             box             box                         box

So as seen above, I have 3 parameters (school, gender, city) which I'm feeding my oracle sql query with, and 1 data field (count) which I get as a result of the feed.

My fast and easy approach/plan was to put the field (count) in all of the boxes and change the parameters dynamically with multivalues etc. based on the boxes column/row values to automatically populate parameters, but there are no documentation on how to do that, or can it even be done?

How can I do that, or is there any other possible approach?

1 answer
2.3K+ views

Hello

My .net core api project use below for MySQL database connection.

<PackageReference Include="Pomelo.EntityFrameworkCore.MySql" Version="3.1" />

I would like to know Telerik Reporting service can work with Pomelo or not?

What providerName should I need to use for connectionString in appsettings?

When I tried, I got below error

Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.

------------- InnerException -------------

Cannot load assembly by name "MySql.Data".

Neli
Telerik team
 answered on 10 Aug 2021
2 answers
1.4K+ views

I have the next service in angular, 

<tr-viewer 
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]="'http://localhost:21294/api/reports'"
    [reportSource]="{
        report: 'Product Catalog.trdp',
        parameters: {}
    }"
    [viewMode]="'INTERACTIVE'"
    [scaleMode]="'SPECIFIC'"
    [scale]="1.0">
</tr-viewer> 

I have my app in .NET whit my report Product Catalog.trdp,

and i have the next errors.

 

 

alexa
Top achievements
Rank 1
Iron
 answered on 10 Aug 2021
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?