Telerik Forums
Reporting Forum
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
1 answer
434 views

Hello

I'm trying to add telerik report view in my Angular project. 

I would like to know how can I add Authorization Bearer token in request header of report view API call?

My Angular project use HttpInterceptor to inject Bearer token on every request to API. 

Backend API is .Net core 3.1 . 

Thanks

Zaw Myo Naing

Dimitar
Telerik team
 answered on 10 Aug 2021
1 answer
474 views
How to get the Report Level data source value inside the list control and this list control is also assigned to another data source?
Neli
Telerik team
 answered on 09 Aug 2021
1 answer
317 views

Hi,

I just spent approximately 4 hours wondering why a report I was creating kept inserting pagebreaks after a row group in a crosstab even though I had set GroupKeepTogether=False. I discovered that some old parent row group that I had since deleted was still visible (but greyed out) via the report explorer even though you couldn't see it in the group explorer. This deleted parent row group had its GroupKeepTogether set to True and it was still having an effect on the report layout even though I had deleted the group long since. Why is this happening? It's quite unintuitive and confusing that deleted groups don't seem to be truly deleted and can still have effects on the report.

follow up: Is there any way for me to "clean up" the groups in the report explorer view without having to recreate the entire crosstab from scratch? There does not seem to be an option to delete them. I had some trouble creating the desired layout so I ended up creating and deleting lots of groups so it looks like a total mess and apparently can also have unintended side effects.

Dimitar
Telerik team
 answered on 09 Aug 2021
0 answers
159 views

Hey all, I built my SQL query elsewhere and want to pass parameters to it with @param style. I inserted it in "Select Statement" window and created parameters in reporting with values, yet it doesnt map. If I do it with built-in query builder, it maps and works, simply because in next page it allows you to put the parameter location like @param will be equal to '= Parameters.slevel.Value'

But I can't use built-in query builder in this project, how can I make this work?

Thanks!

 

1 answer
488 views

Since the connection string contains a username and password, it is encrypted in the appsettings.json file. The Startup class decrypts it and makes it available where needed through dependency injection.

Is it possible to have the reporting web viewer get the connection string programmatically? If so how would this be accomplished?

Thanks,

Tim

Neli
Telerik team
 answered on 04 Aug 2021
1 answer
235 views

Hi,

I have the requirement to have a vector based picture (SVG) on the right bottom of every page of a report which is rendered as a PDF (other rendering destinations are not relevant). The picture has to be rendered exactly on the page bounds ignoring any page margins.

Is this possible?

I have tried:

  1. PictureBox with SVG in Footer
    I can't ignore the page margins for this specific picturebox. And I don't want to remove the page margin for every other element.
    Is there something equivalent to CSS "position: absolute" which ignores document flow?
  2. Background Image
    Does not support SVG images

  3. Watermark with PictureBox and Watermark with BackgroundOverlay
    Does support SVG but rasterizes it
Dimitar
Telerik team
 answered on 04 Aug 2021
7 answers
2.2K+ views
I am trying to make the report datasource dynamic by binding the "DataSource" property to a report parameter but it doesn't seem to accept no matter what i put in the Binding expression.

As per the online documentation http://www.telerik.com/help/reporting/ui-edit-bindings.html, DataSource is a valid property path.

I tried binding it to the literal name of my datasource (instead of parameter or expression) but still doesn't work.
<Bindings>
  <Binding Path="DataSource" Expression="MySQLSourceName" />
</Bindings>


Has anyone tried this before and can confirm that it worked?

Thanks!


navi
Top achievements
Rank 1
Iron
 updated answer on 04 Aug 2021
14 answers
817 views

If I create a report book with 10 pages it works fine.But if I try again with 11 ​pages, It throw exception "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"

After deleting all temp files it work for 11 pages

anon
Top achievements
Rank 1
Iron
 answered on 04 Aug 2021
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?