Hello,

I installed latest version of Reporting and trying to create a report based on an Oracle table.
Can you please provide instructions about how connect to the Oracle database?

I see the following screen in the connection wizard:
I need to connect to 
server: OTNE25
database: BTUDEV
user: NTHOMAS

Where do I enter this information on the screen below?
In order to connect to Oracle I need to provide three pieces on information, i.e. server, schema and user name. There is no "schema" box on this screen.

Maybe it relies on TNSNAMES.ORA that I have in my Oracle Client folder? I have an entry in this file that describes the connection but how to use it?

Please advise.
Regards,
M.R.

Hello

I'm now trying to use Telerik report with Angular and .Net Core 3.1 API.

I create a simple trdp file testing, I got below error when open report.

Error loading the report viewer's templates. 
(trvTemplateUrl = 'https://localhost:5001/api/reports/resources/templates/telerikReportViewerTemplate-15.1.21.716.html/').

In browser developer tool, the response of https://localhost:5001/api/reports/resources/templates/telerikReportViewerTemplate-15.1.21.716.html/
{"type":"https://tools.ietf.org/html/rfc7231#section-6.5.4","title":"Not Found","status":404,"traceId":"|b64dba21-4b4e19b16ff25004."}

I found this html under C:\Program Files (x86)\Progress\Telerik Reporting R2 2021\Html5\ReportViewer\templates.
Do I need to copy these html to my project ? 

Other report api requests like formats, clients, sessionTimeout, parameters, instances, documents, info are working well without error. 
Below is sample response of https://localhost:5001/api/reports/clients/4f2581fd685/instances/f7bdb99a53a/documents/03f002a37748eb4d9ae868/info
{"documentReady":true,"pageCount":0,"documentMapAvailable":false,"bookmarkNodes":null,"documentMapNodes":[],"containsFrozenContent":false,"renderingExtensions":[{"name":"PDF","localizedName":"Acrobat (PDF) file"},{"name":"CSV","localizedName":"CSV (comma delimited)"},{"name":"RTF","localizedName":"Rich Text Format"},{"name":"IMAGE","localizedName":"TIFF file"}]}

My angular report viewer version is "@progress/telerik-angular-report-viewer": "^13.21.716",

Please help.

 

 

Hi,

I'm creating a report using the standalone report designer. The report is supposed to contain a long table that's narrow enough to fit on half the width of the page so in order to save space I set the report columnCount to 2 and it works great. My problem is that I want to add another table to the report that is too wide to fit in one column. The columnCount setting appears to apply to the entire report and I was unable to figure out how to limit it to only one part of the report. Is there something I'm missing? 

Hello,

In angular report viewer menu bar, Is there any possibility to customize the export button text-content ('Excel 2007')? 

Please refer the screenshot herewith.

Regards
Susumi

I'm trying to add a SQL Data Source which uses the MySQL Data Provider. When I enter the Connection string it displays the error:

Connection unsuccessful. Check the connection string and try again. Details: SSL Connection error.

 

The connection string should work because I copied from an appsettings.json file. I can also use the server name, user, and password in the connection string to connect with HeidiSQL successfully. Is there any way to find more information about the error?

Under Windows Logs, there are several Application Warnings that look like this:

Aborted connection 1747 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)

Not sure why this error is happening at the same time as those are not the values for db, user, and host that I'm using. The connection string looks like this:

Server=Juneau;Database=live_ztj;User=John;Password=OldTim3r#;ConvertZeroDateTime=true;

Thanks,

Tim

When running a report I want the start and end date parameters to default to the most recent Monday as the start and the next Sunday as the end date?

This is what I have working for something similar which is the first day of last month and the last day of last month...

First Day of Last Month

= Today().AddDays(CDbl(1 - Today().Day)).AddMonths(-1)

 

Last Day of Last Month

= Today().AddDays(CDbl(- Today().Day))

And this is how I did the weekly defaults in SSRS, but I cannot figure out if the same is possible with Telerik...

 

Set First Day of previous week (Monday)

=DateAdd(DateInterval.Day, -6,DateAdd(DateInterval.Day, 1-Weekday(today),Today))

 

Set Last Day of previous week (Sunday)

=DateAdd(DateInterval.Day, -0,DateAdd(DateInterval.Day, 1-Weekday(today),Today))

Hi - not sure if this is common or not, but I just can't find a way to fix this issue - see attached graph. The "Position" vertical axis line is drawn on the left edge of the graph, but I want it to appear on the right edge of the data plot. The axis's labels and title appear in the correct location, just the axis line itself is in the wrong position and cannot find a property or method to correct it.

This graph can support up to 3 Y axes but only 2 are displayed at a time - one on the left, one on the right, and they are programmatically controlled/positioned.

Very desperate for help on this one. Thanks!

Hi,

I am using telerik report designer. I want to insert in my report a section with text and image that wil be different based on the value of a field. This field is a location and I want the section to show a map (can be picture only) and instructions how to get there.

What would be the best way to do that?

I have tried doing a subreport but I have not managed to make it work yet.

Any tips are welcomed!

I'm creating a report using the standalone report designer where I'm using a crosstab (column group) to aggregate data by date over a certain range of dates which is given as a parameter to the report. I would like to display all the dates in the given range in the crosstab, even if some of those dates have no data. I have been banging my head against a wall trying to achieve this for a while, are you able to suggest a solution? I figured I could manipulate my SQL query to ensure that each date has at least one row by doing an outer join with a calendar table but I was wondering if some more convenient solution existed without me having to modify the query itself.

I have a table report with a percentage in one column. I'd like to add a column with a horizontal bar as a visual indicator of the percent value, something like this:

<progress max="100" value="70"> 70% </progress>

I've tried using HtmlEncode and HtmlDecode but it doesn't display correctly. Is there a way to use formatted raw HTML for the value of a column like this?

"<progress max='100' value='" + Fields.Percent + "'> " + Fields.Percent + " % </progress>"

Thanks