Telerik Forums
Reporting Forum
2 answers
231 views

Hi 

I am getting this error when i load a report in designer

Could not load file or assembly 'Telerik.Reporting.Design.Interfaces,
Version=6.0.12.215, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of
its dependencies. The system cannot find the file specified.

I have attached the screenshot for this error

Can you please help me figure this issue..

Todor
Telerik team
 updated answer on 17 Nov 2022
1 answer
90 views

Hello team 

Good afternoon! Is there any settings to have zero line in center of the visual, attached visual has all -ve % for items 

I am looking for property that helps to align bars from center of the visual , not from top

Todor
Telerik team
 answered on 17 Nov 2022
1 answer
215 views

Hi, 

I need to make a report with several PNG images and generate a PNG file with transparency in a Winforms application.
So I made a report with the background 'Transparent' and some PictureBox.
this.Style.BackgroundColor = System.Drawing.Color.Transparent;

this.detail.Style.BackgroundColor = System.Drawing.Color.Transparent;

Then I export to PNG with Telerik ReportProcessor and RenderingResult.
But the background is white. :-(

How can I export this report with transparent background ?

Thanks

Frederic

Todor
Telerik team
 answered on 15 Nov 2022
1 answer
392 views

i'm following this example: https://docs.telerik.com/reporting/embedding-reports/program-the-report-definition/access-report-items-programmatically

when it comes to this:

protected void Button1_Click(object sender, EventArgs e)
{
    Telerik.Reporting.InstanceReportSource instanceReportSource = (Telerik.Reporting.InstanceReportSource)this.reportViewer1.ReportSource;
    Telerik.Reporting.Report report = (Telerik.Reporting.Report)instanceReportSource.ReportDocument;
    Telerik.Reporting.TextBox txt = report.Items.Find("productNameDataTextBox", true)[0] as Telerik.Reporting.TextBox;
}

but in my situation I have a UriReportSource,
how can i get InstanceReportSource from a UriReportSource?

 

 

Dimitar
Telerik team
 answered on 14 Nov 2022
1 answer
110 views
I am trying to repeat a doughnut graph for each row returned in my data source in the visual studio report designer. Is this possible? It's currently combining all the rows into a single doughnut graph.
Momchil
Telerik team
 answered on 11 Nov 2022
1 answer
203 views
I have attached the Telerik report design SS, as I have used 2 tables Lease and credit, and from this, I want to subtract the subtotal between lease and credit and show it in the grand total. But I am stuck in that, I have tried lots of solutions but I am not achieving my result.
Please share your suggestions, it will be very helpful.

Thank you in advance.

Todor
Telerik team
 answered on 11 Nov 2022
1 answer
223 views

On Telerik report Designer R3 2020 I noticed a bug when using the custom format (MMMM dd, yyyy) to show any dates for December.

it would write Desember instead of December.

Please advise

Thank you,

Moe Moussa

Dimitar
Telerik team
 answered on 09 Nov 2022
1 answer
143 views

Hi, I make a TestProject with Telerik reporting Rest service R3 2022,

But it shows just Telerik Reporting REST Service is up and running.

I think I need to modify that part to call the report file, what should I do? And if I called the file, how do I set the report parameter in the file?


        $(document).ready(function () {
            const url = '/api/reports/formats';

            $.getJSON(url, function () {
                $("#content").text("Telerik Reporting REST Service is up and running.");
            })
                .fail(function (data) {
                    $("#content").html("Telerik Reporting REST Service is NOT running: <br />" + data.responseText);
                });
        });

 

 

 

 

Dimitar
Telerik team
 answered on 08 Nov 2022
3 answers
437 views

My environment

  1. Telerik Report Designer, v16.2.22.914, Target Framework: NET 6.0
  2. database: PostgreSQL
  3. data provider: Npgsql version: 6.0.7
  4. 1 database table named 'facilities' with columns:
    • billing_month: timestamp
    • facility_id: varchar(16)
  5. 1 report parameter defined as
    1. name: BillingMonth
    2. type: DateTime
    3. Value: 6/1/2019
  6. 1 data source defined as
    1. name: facilities
    2. sql: "select billing_month schema.facilities where billing_month = @BillingMonth"
  7. 1 data source parameter defined as:

    1. name: @BillingMonth

    2. DbType: DateTime2

    3. value: = Parameters.BillingMonth.Value

  8. 1 design time parameter defaulted to

    1. name: @BillingMonth

    2. Constant Value: 6/1/2019

The Issue

When I click "Execute Query" on the preview data source results screen in the configure SQL Data Source wizard am presented with an error such as: Can't write CLR type System.String with handler type TimestampTzHandler or Can't write CLR type System.String with handler type TimestampHandler.

If I dismiss the error and hit "Finish" Data explorer will not show the data fields but instead displays the same error with a rather long stack trace.

Interestingly enough, the report may still work, but design time assistance is unavailable. For example I cannot drag data source fields to the report. To validate I created another data source for the list of unique billing months, assigned that to "AvailableValues" of the BillingMonth report parameter, and set Visible to True. I can then select from an appropriate month in the report Preview and run the report.

My Question

What is the appropriate format to specify a DateTime constant value in the design time parameters window of the Configure SQL Data Source wizard?

Previously, when we were targeting oracle specifying M/D/YYYY worked fine but as we're retargeting PostgreSQL we find ourselves with this mystery.

 

 

 


Dimitar
Telerik team
 answered on 07 Nov 2022
3 answers
286 views

Hello,

I have a project in .NET Framework 4.6.1 with a web page that use a ReportViewer telerik control. To make everything clearer i have to change the parameter section from ListView to ComboBox. I'm using the library Telerik.ReportViewer.Html5.WebForms v.14.1.20.618 for reporting, while the rest of the projecxt is Telerik for AJAX.

Mi first question is: can you confirm me that with this setting i can activate the ComboBox?

The second question is: how can i do that? In ReportViewer I can't see the element Parameters also after adding in the project the file jquery-3.3.1.min.js

Thanks

Dimitar
Telerik team
 answered on 07 Nov 2022
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?