Report1.vb

----------------
Partial Public Class Report1
    Inherits Telerik.Reporting.Report
    Public Sub New()
        InitializeComponent()
        Dim sqlConnection1 As New SqlConnection()
        sqlConnection1.ConnectionString = "Data Source=dbserver;Initial Catalog=StarflighteDecision;User ID=sa;Password=Admin123#"
        sqlConnection1.Open()
        sqlDataAdapter1 = New SqlDataAdapter("exec [daterange_report] '8/25/2009','8/27/2009' ", sqlConnection1)
        Dim dataSet As New DataSet()
        sqlDataAdapter1.Fill(dataSet)
        Me.DataSource = dataSet.Tables(0)
    End Sub
End Class

==========================================================
Default.aspx.vb

----------------------
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
      
        Dim report As IReportDocument
        report = New Report1()
        Me.ReportViewer1.Report = report
        ReportViewer1.DataBind()
       
End Sub

Please give any suggestions to solve it.

Thanks in advance.

Regards,
Ragavan

I need to consume an API and pass parameters using the POST method.

Placing a query via POST
Where I hope in the message body an object with an integer attribute PatioID.

When I configure the datasource, I inform the URL and Parameters via POST, when I command to execute of the error. (415 - unssupported media type )

Dear All,

I created a cross tab report that results in a single grid that is sometimes longer than one page. When it is less than one page, the cross-tab grid begins on page one. But when it is greater than one page, it leaves the first page blank and starts on the second page. How do I make it start on the First page regardless?
I removed the "keep together" in the section expert and I was told about a "Keep Object Together" in the Cross tab expert but I did not find it in there but I did find a "keep columns together". But none of that fix it.
Help?
Thanks.

I need to create a chart that contains a column chart and two line charts imposed over the column chart.  The data set that I am working with looks like the one I have attached in the data.jpg image and the chart should look similar to the one in the chart.jpg that is attached.  I have been trying to figure out how to make this work but all to no avail.  If someone has any tips on how to get the chart designed I would appreciate it.

James

This is for a .net core 2.2 razor page.

I've tried rerunning the vsix for vs2019, but nothing seems to work. How to get "The HTML5 Report Viewer item template is available in the Add New Item dialog box under the Web category" referenced in the docs at https://docs.telerik.com/reporting/html5-report-viewer-quick-start to show up?

I have found very little in the way of examples that are razor based. Does such an animal exist?

Thanks .... Ed

I have a question that is frustrating me.  I am trying to get up a column chart using the following query

SELECT COUNT(conversation.id) as total_chats, 
       COUNT(lead.id) as total_leads,
       (SELECT SUM(total_visits) 
FROM site_visit INNER JOIN site ON site.id = site_visit.site_id 
WHERE [date] BETWEEN DATEADD(DAY, DATEDIFF(DAY, 0, conversation.conv_start), 0) AND DATEADD(DAY, 1, DATEADD(DAY, DATEDIFF(DAY, 0, conversation.conv_start), 0)) AND site.client_id = @clientId) AS total_visits,
DATEADD(DAY, DATEDIFF(DAY, 0, conversation.conv_start), 0) as date,
        site.client_id
FROM conversation LEFT OUTER JOIN lead on conversation.lead_id = lead.id
                  INNER JOIN site on site.id = conversation.site_id
WHERE site.client_id = @clientId and conversation.conv_start BETWEEN DATEADD(DAY, 1, DATEADD(MONTH, -6, EOMONTH(@date))) AND DATEADD(DAY, 1, EOMONTH(@date))
GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, conversation.conv_start), 0), site.client_id that runs properly in the query configuration tool and populates the design view as expected as evidenced in the attached screenshots.  But when I attempt to run a preview I get the error shown in the third attachment.

I have checked all of the parameters and don't understand why this error would be coming up.

Thanks you for helping me understand this error.

James Wallace

Hello Telerik Team,

I wanted to install Telerik Reporting 12.2.18.912, but in the Progress Control Panel in Telerik Reporting under "View All Versions" I can only see 2 versions. (See in scrennshot). How can i install the version that I need?

Thank you in advance.

Tamara

Hello, I need to get the size of textbox programatically but when I use, for instance, textBox.Height.Value I get the rounded number. Is there any way to get the accurate value of textbox size?

Thanks!