Telerik Forums
Reporting Forum
1 answer
111 views

I have a comma delimited string parameter that is parsed into a c# datasource method when a Telerik report gets rendered. When I pass the string as it is into the datasource, using Parameters.personId.Value it fails and I get an error. When I use the Join(",", Parameters.personId.Value) function, it only works if the string has a single value and it's not comma delimited. The moment I append another value to the string, it sends the parameter as an empty string to the datasource. 

This is how my data looks like:

Telerik UI parameter: 

 

C# DataSource definition: 

Sample Parameter Value: 

PersonIds: "965985,663958"

 

Thanks.

Todor
Telerik team
 answered on 14 Sep 2023
1 answer
380 views

Good Afternoon Telerik,

 

Please see the reference thread here: https://www.telerik.com/forums/telerik-averaging-time-to-a-negative-number

 

I am using Mochil's suggestion of the following.


= Fields.PROVISIONALDATETIME Is Not Null ? Fields.PROVISIONALDATETIME - Fields.COMPLETIONDATETIME : Fields.FINALDATETIME - Fields.COMPLETIONDATETIME

However, it is showing the hours:minutes:seconds with a days. in front. How can I get the days to just be tacked on to the hours? so instead of it stopping at 24 hours and adding a day value it'll just calculate go says 48 hours for 2 days and so on. as, the day function is causing my averages to mess up greatly since it can't calculate the day function :(

 

in example:

 

Thank you!

 

Momchil
Telerik team
 answered on 14 Sep 2023
1 answer
117 views

1. There is significant difference in edit expresion between Desktop Application and Web Designer.
For example Html TextBox in Desktop Application edit value is RichTextBox and Web Designer edit value is just textarea .

Is any workaround to use rich text box in edited value in web designer?

For example Can i bind to some event and open custom window (defined by me)

2. Its seems that localization strings dont work for this popup (edit value). (few strings are translated but many not)
I've changed all properties from https://docs.telerik.com/reporting/designing-reports/report-designer-tools/web-report-designer/localizing-the-web-report-designer




Additionaly can i translate content of notofifaction errors/warnings ?

Dimitar
Telerik team
 answered on 14 Sep 2023
1 answer
93 views

Hi,

I am creating a report which contains a map and I want to set the value of UrlTemplate on the TileProvider from a parameter which I have in the report. I try to set the value to = Parameters.p_map_url.Value, but this does not work. Is it not possible to have the value of UrlTemplate to a dynamic value which is not hardcoded into the report itself?

Todor
Telerik team
 answered on 14 Sep 2023
1 answer
390 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
146 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
56 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.2K+ 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
84 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
334 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
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?