Telerik Forums
Reporting Forum
2 answers
193 views

Hello,

I build a Report with the standalone ReportDesigner.

The report is connected with a Ms Access database with Microsoft.ACE.OLEDB.12.0 .The datasource is "embedded".

When i launch the preview in the designer it works fine.

 

Now I want to view the report in my WpfCore app (compile in x86 mode).

I have a 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 -------------
Keyword not supported: 'provider'.

 

I try differents things :

- add an appsetting.

- Changing the connection string dynamically (with the sample code in the KB, which work fine with a SqlServer connection)...

- change driver by Jet4.0 driver...

And it doesn't work...  How can I make it works ??

I know that ms access is not the best database engine but i can't change it...

Guittier
Top achievements
Rank 1
 answered on 07 Aug 2020
3 answers
220 views

Hi!

Please answer:

How to display linear objects on the map, such as roads, power lines, pipelines. In your examples, only point and polygon objects are shown. We also need to show linear objects whose geographic data are represented in WKT format in the form: LINESTRING (), not POLYGON (())

It is also interesting - whether it is possible to display all types of objects(points, lines, polygons)  on the map at the same time.

Tom
Top achievements
Rank 2
 answered on 07 Aug 2020
3 answers
2.9K+ views

I have recently started using Telerik reporting my team is using ASP.net Webforms can I have implemented the  Telerik Reporting REST service as detailed here  http://docs.telerik.com/reporting/telerik-reporting-rest-conception and tested the web API which returned the json file. But when using the report viewer to call a trdp file saved on my project folder I get the following error  "Unable to get report parameters.Report 'BarcodesReport.trdp' cannot be resolved". Below is my code for the page, snippet of the error  and API controller. Any feeback is greatly appreciated

 

Report.aspx.cs

public partial class Report : Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var clientReportSource = new Telerik.ReportViewer.Html5.WebForms.ReportSource();
clientReportSource.IdentifierType = IdentifierType.UriReportSource;
clientReportSource.Identifier = "BarcodesReport.trdp";
ReportViewer1.ReportSource = clientReportSource;
}

}

}

 

ReportsController.cs

public class ReportsController : ReportsControllerBase
{


static ReportServiceConfiguration configurationInstance;
static ReportsController()
{
var appPath = HttpContext.Current.Server.MapPath("~/");
var reportsPath = Path.Combine(appPath, @"..\..\..\Report");
var resolver = new ReportFileResolver(reportsPath)
.AddFallbackResolver(new ReportFileResolver());
configurationInstance = new ReportServiceConfiguration
{
HostAppId = "Application1",
Storage = new FileStorage(),
ReportResolver = resolver,
// ReportSharingTimeout = 0,
// ClientSessionTimeout = 15,
};
}
public ReportsController()
{
this.ReportServiceConfiguration = configurationInstance;
}
}

 

 

Neli
Telerik team
 answered on 07 Aug 2020
13 answers
297 views

I have a pretty simple bar chart and the first label on the X Axis is ALL. Where does this come from? It is not in the data.

 In the attached screenshot you will also see the bars are not centered above each label, why is this?

 And finally, the bars are very narrow, why is this and how can I make them wider?

Vas
Top achievements
Rank 1
Veteran
 answered on 07 Aug 2020
1 answer
452 views

Good day,

I hope you can help me as I am battling getting the report viewer that is working well in another html/javascript project.

Now converting the application to Angular (8).

This loads the report viewer fine:

  <tr-viewer #viewer1 
  [containerStyle]="viewerContainerStyle"
  [serviceUrl]="http://localhost/RepService/ReportViewer/api/reports"
  [templateUrl]="'http://localhost/RepService/ReportViewer/templates/telerikReportViewerTemplate.html'"
  [viewMode]="'INTERACTIVE'"
  [scaleMode]="'SPECIFIC'"
  [scale]="1.0"
  >
</tr-viewer>

 

But this would need to be reconfigured when deploying, so to do that, this get's the closest:

In html file:

  <tr-viewer #viewer1 
  [containerStyle]="viewerContainerStyle"
  [serviceUrl]="serviceUrl"
  [templateUrl]="'http://localhost/RepService/ReportViewer/templates/telerikReportViewerTemplate.html'"
  [viewMode]="'INTERACTIVE'"
  [scaleMode]="'SPECIFIC'"
  [scale]="1.0"
  >
</tr-viewer>

 

In .ts file:

ngAfterViewInit() {
    this.serviceUrl = "'http://localhost/RepService/api/reports/'";

 

But getting the following:

The serviceUrl is not specified.

 

When I move that line to ngOnInit:

ngOnInit() {
    this.serviceUrl = "'http://localhost/XRSReportingService/api/reports/'";

Getting: Cannot access the Reporting REST service. (serviceUrl = ''http://localhost/XRSReportingService/api/reports/''). Make sure the service address is correct and enable CORS if needed. (https://enable-cors.org)

 

So this doesn't look like a CORS issue to me.

Thanks very much

Neli
Telerik team
 answered on 06 Aug 2020
0 answers
343 views

I have created a new report and enable the ToolTip.  When the user rolls over the graph in the report.  The ToolTip comes up and shows the title and the text.  I want to add a second line to the text.  However, I can't seem to get it to work.  This is what I am doing.

I go into Visual Studio.  I select the desired graph.  Then Series - barSeries1 - ToolTip - Text.  I select to edit the expression.  I have added the following expressions and can't get the words "Encounter Count" to go on a second line.  I have tried the following expressions.

{Format('Month: {{1:MMMM yyyy}} {{0}} Encounter Count', "<br />", Fields.reportMonth)}
{Format('Month: {{1:MMMM yyyy}} {{0}} Encounter Count', "\n\r", Fields.reportMonth)}

{Format('Month: {{0:MMMM yyyy}}\nEncounter Count', Fields.reportMonth)}

Nothing seems to work. 


 

 

Rich Schone
Top achievements
Rank 1
Veteran
 asked on 06 Aug 2020
1 answer
535 views

I have recently purchased a new PC and would like to download the standalone executable for 2019 R1.

How do I do this?  Later releases introduced breaking changes which will no longer support my deployed reports.

Yana
Telerik team
 answered on 06 Aug 2020
3 answers
369 views

When there are both ascii characters and non-ascii characters (such as Chinese) in the text box, the position of line wrapping in Docker is incorrect.And some data lost.

The code: 

<?xml version="1.0" encoding="utf-8"?>
<Report Width="17cm" Name="Report2" xmlns="http://schemas.telerik.com/reporting/2020/2.0">
  <Items>
    <PageHeaderSection Height="2cm" Name="pageHeaderSection1" />
    <DetailSection Height="5cm" Name="detailSection1">
      <Items>
        <TextBox Width="2.9cm" Height="1.3cm" Left="0cm" Top="0cm" Value="textbox1113333333测试测试测试123456789" Name="textBox1" />
      </Items>
    </DetailSection>
    <PageFooterSection Height="2cm" Name="pageFooterSection1" />
  </Items>
  <PageSettings PaperKind="A4" Landscape="False">
    <Margins>
      <MarginsU Left="2cm" Right="2cm" Top="2cm" Bottom="2cm" />
    </Margins>
  </PageSettings>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
  </StyleSheet>
</Report>
Todor
Telerik team
 answered on 06 Aug 2020
2 answers
141 views

I was testing out the reporting tools from Telerik and I added a Telerik Report Viewer form. When I did so, it replaced one of my main user controls in my main winForm with a Telerik ReportViewer. I removed it and tried to put back my user control but now I am getting an error that says...

Failed to create component UserControl1... System.IO.FileNotFoundException…. Microsoft.Extensions.DependencyInjection.Abstrations was not found… or one of it's dependencies.

The only thing I did was add a Telerik Report Viewer winForm to my project. The wizard did kick off added a sample report and created a report folder with the sample. But nothing else. I don't understand what the Telerik template or wizard might have done to replace my user control and what happened to the DI.Abstractions reference. Does the template or wizard make changes to my references, something that might have caused a conflict?

It all seems a bit odd, like the Telerik template or wizard did something it was not supposed to. So I need to know how to get it back to where it was before. Then maybe I can start looking at Telerik Reporting options.

One thing I did notice is that whatever happened, the key is that it broke my user control. Then .NET seems to have substituted it with the Telerik Report Viewer control when I tried to view and identify the issue. SO the issue, it seems to have to do with breaking my control, not substituting the user control. I think that was .NET. 

 

Thanks,

Jon

 

Eric R | Senior Technical Support Engineer
Telerik team
 answered on 05 Aug 2020
22 answers
3.5K+ views
hi!

i have a report that use the Crosstable item. I have defined a group that can have many items below it. If a group must split on two pages, is there a property to tell the crosstable to repeat the group details? and if there's a function to do that, is it possible to add something to the group details? on the following example, the second page will continue to print the Group2 details and i would like to add "group2 (continued)"

                   | col1   | col2   | col3
group1
   item1      1           2           3
   item2      1           2           3
   item3      1           2           3
   item4      1           2           3

group2
   item1      1           2           3
   item2      1           2           3

===== change page =====

                 | col1    | col2   | col3
group2 (continued)
   item3      1           2           3
   item4      1           2           3






alex
Todor
Telerik team
 answered on 04 Aug 2020
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?