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

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.

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

I have a dataset that is returning one row, with a field called [Percent of Total] the field is formatted like 0.75 (representing 75%)

I want to use this value in a pie chart with the pie chart filled 75% of the way, but I can't seem to figure out how to achieve this.
The chart builder in Telerik is not very user friendly...

Hi, support

I want to create a report viewer server and send a request from the website to url.

C:\Program Files (x86)\Progress\Telerik Reporting R2 2022\Examples\CSharp\.NET 6\Html5IntegrationDemo
I'm taking that into consideration
When I type http://localhost:51863/index.html, the screen appears, and the leaflet about the product is http://localhost:51863/goodsPop, and the information about people is http://localhost:51863/employee. I wonder what to do in this case.

            {
                endpoints.MapRazorPages();
                endpoints.MapControllers();
            });
            app.MapControllerRoute(
                name: "default",
                pattern: "{controller=Home}/{action=Index}/{id?}"
            );
            app.Run();

Also, we are going to send jsonData to the url in post format, and in this case, I wonder how to receive the value in the report viewer server and deliver it to the report.

And there are Html5IntegrationDemo and ReportingRestServiceCorsDemo in the folder of Net6, what is the difference between the two projects?

[Report Designer View]

[Report Explorer]

[Properties of ImageView(GoodsName)]

[Edit Expression(GoodsName)]

='<svg style="background-color:green">
    <text
        font-family="HY헤드라인M"
        fill="black" 
        x="0%" 
        y="50%" 
        textLength="100%"
        dominant-baseline="middle" 
        lengthAdjust="spacingAndGlyphs"   
    >
        '+ Fields.goodsName+'
    </text>
</svg>'

[Report Print View]

[Print View]

(When I push this Print Icon)

Hello, thank you for your reply to the previous inquiry.

I have a question while applying it.
(What I asked you before: https://www.telerik.com/forums/how-to-stretch-in-textbox)

1. Report Print View screen and Print View screen are different.
2. The green box on the Report Print View screen is the size and location of the goodsName currently set to the Report Parameter.
I'd like to stretch the goodsName in the green box. It's okay if the letters are crushed, so is there a way to put the letters in the green box exactly like this?