Telerik Forums
Reporting Forum
1 answer
504 views

I have a data source that has geo-coordinates in each record. 

I want to make a request to an API to generate a map out of these geo-coordinates using their static map feature.

To do this I need to aggregate multiple fields in a record and then aggregate these values (from each record) together to form a URL that I can use to populate an image component.

 

I've been able to use the aggregated functions like sum and count but as soon as I try to use Join(", ", Fields.x) I get the error

An error has occurred while processing TextBox 'textBox53':Type mismatch in function arguments. Cannot find an overload of the function Join() that accepts arguments of type (String, Double).

If I use Join(", ", CSTR(Fields.x)) I get the error 

An error has occurred while processing TextBox 'textBox53':Type mismatch in function arguments. Cannot find an overload of the function Join() that accepts arguments of type (String, String).

But if I use Count(Fields.x)

I get the value 9 which is correct.

Why can I use some aggregated functions on a field but not others?

 

Momchil
Telerik team
 answered on 13 Sep 2023
1 answer
229 views
Hello , 
I'm trying to print on a lable with double side Right/Left 
for example : 
Print first Item on right side and the secound item on Left side 

I have attached the Lable Image 

Thanks a lot . 
Todor
Telerik team
 answered on 13 Sep 2023
1 answer
91 views

Hello,

I also have a problem, I'm loading REST reports into webReportDesigner. If I call a report, it always returns the report I requested first. Can you please help me what could be the problem?

 

Thank

Momchil
Telerik team
 answered on 13 Sep 2023
10 answers
5.4K+ views
Hi  Telerik
I am creating the report with attaching database connection and tables by taking the class library , and i am saw the report on preview tab with database records(up to this working fine)

Now i am take the visual studio project , and attach the above report to ReportViewer and run the project then it shows following error
-----------------------------------------------
An error has occurred while processing Report '':
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 -------------
Format of the initialization string does not conform to specification starting at index 0.
-------------------------------------------------

Gunjan
Top achievements
Rank 1
Iron
 answered on 12 Sep 2023
1 answer
135 views

Hi Team, 

I want to build a chart that can categorized based on status and company(x-axis, picture 1), how can I do it? 
For now, I am only able to shows this(picture 2)

                                                                                  picture 1

                           picture 2

Todor
Telerik team
 answered on 12 Sep 2023
0 answers
434 views

Hi All,

We are implementing Web Report Designer in our project. There is Telerik Reporting service is running as a separate service (in Azure VM), our server-side project is also running in k8s which communicate to the Reporting service through gRPC. The Reporting service has custom implementation for IReportSourceResolver (for report preview) and IDefinitionStorage (for report design). We store xml content of a report file in the database that is beside of out server-side project. In the middleware of our project, we need to send report xml content. The problem we have is that xml string is too long and has unsupported characters to be used in Uri.

If you set just Telerik report file name (for report parameter in webReportDesigner.html), then it works. See CustomReportDefinitionStorage class in the picture below. That GetAsync() method works only when you send just report file name. But it doesn't work when you send entire report content as a XML string. Is there any solution or workaround to do this with report xml? Is there a way to do with POST query?

 

Thanks!

Tursunkhuja
Top achievements
Rank 2
Iron
Iron
Veteran
 asked on 08 Sep 2023
1 answer
669 views

Hi,

I have built a report on the Telerik Standalone Report Designer, it calls a stored procedure and the SP will complete by around 5 minutes 33 seconds.  I have specified the Connection Timeout to 600 seconds in the Connection String (see attached), but when I preview the report on Telerik Report Designer and Telerik Report Sever, I still got the error message "Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.".

How could I resolve this problem?

Many thanks.

Best regards,

Jocelyn

Dimitar
Telerik team
 answered on 06 Sep 2023
1 answer
765 views

I wish to integrate a telerik report viewer into a blazor application (I am using Dot net 6.0).. I have set up a Reporting Server also using Dot net 6.0
I wish to use Oracle db as the data Source of my application
I have tried the following steps

1.Opened the default Telerik.ReportDesigner

2.Clicked on new and added the datasource

3.Selected Sql Data Source

4.Clicked on build new connection and selected OracleClient Data Provider

5.Chose build option

6. In the Data Source clicked on change and selected  .Net Framework Data provider for Ole Db (as the other one is shown as deprecated)

7. Filled the feilds and when cliked on test connection, it is showing " The  'MSDORA' provider is not registered on the local machine"


I looked into the issue and tried shifting to Telerik.ReportDesigner x86 application

I followed the same steps as above and when i clicked on "test connection", it is showing an error  "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version on 7.3.3 or later client software installation.Provider is unable to function until these components are installed"

which application should i use and is there any solution to get rid of this error
Kindly provide as solution for this
I am using Oracle Db version "Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production"

my connection string is like "Data Source={111.111.1.11:2222};User Id={useid};Password={pass}"

1 answer
203 views

Hi Team,

I have created the Telerik report (.trdp) to show some data in Line Chart with below details.

Chart Type : Line Chart

Series : LineSeries

LineType : Smooth Line

YaxisScale : Numerical Scale.

Xaxis Scale : DateTime Scale

I have exported the PDF from Telerik Report designer  and it is working fine i.e, Line Type is smooth throughout . However , when I integrate the telerik report in my Asp.net Web api I started getting following issue. Line series is partially Smooth for continuous values and straight Line for missing values. Please let us know the solution to make the entire line type smooth.

PFA Screen shots for issue.

Picture 1 :  Working picture, pdf Exported from telerik report designer.

Picture 2 :  Issue image, Pdf Exported from Web api code.

 

Thanks

Momchil
Telerik team
 answered on 05 Sep 2023
1 answer
572 views

Hello,

I implement reports and use IReportSourceResolver. When report viewer asks for a report, the method is called 3x. I need to load data into the report using objectDataSource. But the problem is that the parameters from currentParameterValues are loaded only in the first call (OperationOrigin.ResolveReportParameters). In the other two, the variable is already empty. Can you please help me? 

Thank you

public ReportSource Resolve(string uri, OperationOrigin operationOrigin, IDictionary<string, object> currentParameterValues)
        {
            var reportPackager = new ReportPackager();
            var report = Construct.CommonManager.Report.GetModelFromUri(uri);

            if (report == null)
            {
                throw new FileNotFoundException();
            }

            MemoryStream stream = new(report.Data);
            Telerik.Reporting.Report report1 = (Telerik.Reporting.Report)reportPackager.UnpackageDocument(stream);
         
            var instanceReportSource = new InstanceReportSource
            {
                ReportDocument = report1
            };

            if (operationOrigin == OperationOrigin.ResolveReportParameters)
            {

            }
            else if (operationOrigin == OperationOrigin.CreateReportInstance)
            {

            }
            else if (operationOrigin == OperationOrigin.GenerateReportDocument)
            {

            }

            return instanceReportSource;
        }
Dimitar
Telerik team
 answered on 04 Sep 2023
Top users last month
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Rakhee
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?