Telerik Forums
Reporting Forum
1 answer
460 views

Hey all, so I have this report which is basically to show how many staff members (count) are working inside a company on different characteristics like gender, city and education level.

For example:

                   ------  School 1  ------                 ------  School 2    ------                  ------  School3  ------  

                Male       ------        Female         Male       ------        Female           Male       ------        Female

City 1       box                          box                 box                             box             box                         box

City 2      box                          box                 box                             box             box                         box

City 3       box                          box                 box                             box             box                         box

So as seen above, I have 3 parameters (school, gender, city) which I'm feeding my oracle sql query with, and 1 data field (count) which I get as a result of the feed.

My fast and easy approach/plan was to put the field (count) in all of the boxes and change the parameters dynamically with multivalues etc. based on the boxes column/row values to automatically populate parameters, but there are no documentation on how to do that, or can it even be done?

How can I do that, or is there any other possible approach?

1 answer
2.4K+ 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.5K+ 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
442 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
482 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
329 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
163 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
494 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
241 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
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
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?