Questions on Reporting Forum

3 answers

221 views

Automatically choose the optimal LabelStep in a scatter graph

Hi,

I'm trying to create a scatter graph with DateTime points on the x-axis. A problem here is that the labels on the x-axis overlap when there are to many data points.

A solution that I found was to manually determine my Labelsteps, this solutions doesn't work for all my use cases. Is there a way to auto-scale the labelsteps? I've read on the forum that the "Axis AutoStep Functionality" could be a solution. Is this feature available for reporting graph? I cannot seem to find this functionality.

Thanking you for your asssitance.

General Discussions

answered on 08 Apr 2019

4 answers

528 views

Changing The Report Rendering Settings Programmatically

Hi,

We have a requirement to set the NoHeader parameter value to true in some reports and false in others. Is there a way to do it from the code behind of the report? I have found a way for window forms application (https://www.telerik.com/forums/programmatically-set-noheader). But our requirement is for web application

Regards,

General Discussions

answered on 08 Apr 2019

1 answer

132 views

Style Sort Button In Telerik Reporting

I have enabled interactive sorting in the Telerik reporting but I now want to style the header of the table(reduce the size between button and the heading text) and the sort button. Is it possible to do this in the report viewer

Regards,

Majar

General Discussions

answered on 08 Apr 2019

1 answer

345 views

report viewer - Use Javascript selector instead of JQuery selector

In the html5 report viewer, we are using a jquery selector

$("reportViewer").telerik_ReportViewer({...});

But what if we want to use vanila javascript selector for it like,

document.getElementById("reportViewer").telerik_ReportViewer({...});

but when I am using this it is showing me an error: Uncaught TypeError: reportViewer1.telerik_ReportViewer is not a function

Report Designer (standalone)

answered on 05 Apr 2019

3 answers

309 views

Trying to add a Telerik Report

We are using the Telerik for MVC, and we have an MVC application we wish to actually add a report to. But when we do, we get the following error:

Error CS0012 The type 'ApiController' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Web.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.

I cannot seem to find a System.Web.Http.dll that is earlier than the v 5.2 on my system. I tried adding it via NuGet, but it won;t add it, giving me the following error:

PM> Install-Package System.Web.Http -Version 4.0.0
Attempting to gather dependency information for package 'System.Web.Http.4.0.0' with respect to project 'ReportTest', targeting '.NETFramework,Version=v4.6.1'
Attempting to resolve dependencies for package 'System.Web.Http.4.0.0' with DependencyBehavior 'Lowest'
Resolving actions to install package 'System.Web.Http.4.0.0'
Resolved actions to install package 'System.Web.Http.4.0.0'
Install failed. Rolling back...
Package 'System.Web.Http.4.0.0' does not exist in project 'ReportTest'
Package 'System.Web.Http.4.0.0' does not exist in folder 'C:\VensureApplications\ReportTest\packages'
Install-Package : Could not install package 'System.Web.Http 4.0.0'. You are trying to install this package into a project that targets '.NETFramework,Version=v4.6.1', but the package does not c
ontain any assembly references or content files that are compatible with that framework. For more information, contact the package author.
At line:1 char:16
+ Install-Package <<<< System.Web.Http -Version 4.0.0
+ CategoryInfo : NotSpecified: (:) [Install-Package], Exception
+ FullyQualifiedErrorId : NuGetCmdletUnhandledException,NuGet.PackageManagement.PowerShellCmdlets.InstallPackageCommand

So how do I get this thing to work?

Using VisualStudio 2015

Telerik v2018.1.117.545 (Kendo.mvc.dll)

General Discussions

answered on 05 Apr 2019

1 answer

151 views

Bug in Web Service Data Source in 13.0.19.222

When binding a table to a Web Service Data Source the parameter does not work in the report.

The configure wizard will successfully pull data using the "Download" button, but the report render does not properly pull the parameter value and insert it into the URL string. Using fiddler the report is sending the ToString of the object instead of the value. Have only tested this for "Query" type parameters. Works fine when used as the report Data Source, seems to only happen when you connect the data source to a table. (This build also has numerous bugs when applying conditional formatting to table rows, haven't had time to write up anything on them yet, not sure if related.)

I have connected to a web service "GetRequiredDataJson" that requires a parameter "workOrderId".

Redacted Request From Fiddler When Rendering Report:

GET <Deleted URL HERE>/GetRequiredDataJson?workOrderId=System.Object%5B%5D

General Discussions

answered on 04 Apr 2019

1 answer

194 views

Dynamic PageBreak

Hi

I'm trying to make a PageBreak in the detailReportGroup dynamic based on a parameter. If parameter is yes PageBreak should be 'After' else 'None'. But I can't add a IIF condition to the PageBreak property.

Thanks for all replies!

Joel

General Discussions

answered on 04 Apr 2019

2 answers

196 views

How to generate a report using a refined data source

Hello, I am a novice user using Telerik UI for ASP.NET MVC and Telerik Reporting.

To tell you the conclusion I wonder if I can create a report using a refined external data source.

=> I would like to use datasource which is calculated by c # calculation of the result of procedure obtained from grid retrieval and use it directly in report.

Is there such a way?

--------------------

Detail

The web page I'm creating now As a result of StoredProcedure Two select results are displayed.

result 1: james 29 LA john 25 Korea

result 2: 290,000

I do not know why the procedure creator caused the output to be output separately, but I need to output two results in succession.

Output as shown below.

james ...

john ...

290,000

To do this, we combine two result datasources in the c # section if the number of dataSet.Table is two.

The report did not find an approach to where the results of the procedure are stored.

I am not good at English, but I hope that my intentions are well communicated.

Thank you.

General Discussions

answered on 04 Apr 2019

1 answer

716 views

How can I add a (vertical) margin (i.e., padding) between page header and content on the second page with repeating table header in Telerik reporting

I am using Telerik Report Designer Software.
I have a problem: I want to set a margin between the page header and the table header when the table header is repeating.
On the first page it looks good, but on the second page it looks like this

(In attachment where the red represents the page header and the grey represents the table header.)
How can I put space/margin/line break between page header and table header on the second page of the report?

Report Designer (standalone)

answered on 03 Apr 2019

2 answers

418 views

Report showing blank and ignoring parameter

I am using a demo of the reporting software but I am having issues understanding parameters I have set up the parameter Invoice_Number on the report parameters screenshot as per image 1.1. On My menu click of my I have a report viewer with the report with the .

private void invoiceToolStripMenuItem_Click(object sender, EventArgs e)

{

Job job = jobsList.GetSelectedItem<Job>();

if (job != null)

{

InvoiceReports INV = new InvoiceReports();

INV.ReportParameters["Invoice_Number"].Value =job.InvoiceNumbers;

InvoiceViewer _invViewer = new InvoiceViewer();

_invViewer.Invoice_Number =job.InvoiceNumbers;

_invViewer.ShowDialog();

//var sageInvoiceCoordinator = new SageInvoiceCoordinator();

// sageInvoiceCoordinator.Print(job.ID);

}

In my invoice viewer have the following which is setting the invoice itself.

public string Invoice_Number { get; set; }

public InvoiceViewer()

{

InitializeComponent();

}

private void InvoiceViewer_Load(object sender, EventArgs e)

{

var report = new InvoiceReports();

report.ReportParameters["Invoice_Number"].Value = Invoice_Number.ToString();

// Use the InstanceReportSource to pass the report to the viewer for displaying

var reportSource = new Telerik.Reporting.InstanceReportSource();

// reportSource.Parameters.Add(new Telerik.Reporting.Parameter("Invoice_Number", 3));

reportSource.ReportDocument = report;

// Assigning the report to the report viewer.

reportViewer1.ReportSource = reportSource;

// Calling the RefreshReport method in case this is a WinForms application.

reportViewer1.RefreshReport();

}

And as you can see below I added it to my data connection. really at a loss as to what am doing wrong

SELECT INVOICE.INVOICE_TYPE, INVOICE.INVOICE_OR_CREDIT, INVOICE.ACCOUNT_REF, INVOICE.NAME, INVOICE.ADDRESS_1, INVOICE.ADDRESS_2, INVOICE.ADDRESS_4, INVOICE.ADDRESS_5, INVOICE.ADDRESS_3,

INVOICE.C_ADDRESS_1, INVOICE.C_ADDRESS_2, INVOICE.C_ADDRESS_3, INVOICE.C_ADDRESS_4, INVOICE.C_ADDRESS_5, INVOICE.DEL_NAME, INVOICE.DEL_ADDRESS_1, INVOICE.DEL_ADDRESS_3,

INVOICE.DEL_ADDRESS_2, INVOICE.DEL_ADDRESS_5, INVOICE.DEL_ADDRESS_4, INVOICE.ORDER_NUMBER, INVOICE.CONTACT_NAME, INVOICE.ORDER_NUMBER_NUMERIC, INVOICE.CUST_ORDER_NUMBER,

INVOICE.CUST_TEL_NUMBER, INVOICE.NOTES_1, INVOICE.NOTES_2, INVOICE.NOTES_3, INVOICE.FOREIGN_ITEMS_GROSS, INVOICE.FOREIGN_ITEMS_TAX, INVOICE.FOREIGN_ITEMS_NET, INVOICE_ITEM.ITEM_NUMBER,

INVOICE_ITEM.JOB_NUMBER, INVOICE_ITEM.SERVICE_FLAG, INVOICE_ITEM.DESCRIPTION, INVOICE_ITEM.TEXT, INVOICE_ITEM.STOCK_CODE, INVOICE_ITEM.COMMENT_1, INVOICE_ITEM.COMMENT_2,

INVOICE_ITEM.FOREIGN_UNIT_PRICE, INVOICE_ITEM.FOREIGN_DISCOUNT_AMOUNT, INVOICE_ITEM.TAX_RATE, INVOICE.INVOICE_NUMBER, INVOICE.INVOICE_TYPE_CODE, COMPANY.L_NAME, COMPANY.L_ADDRESS_1,

COMPANY.L_ADDRESS_2, COMPANY.L_ADDRESS_3, COMPANY.L_ADDRESS_4, COMPANY.L_ADDRESS_5, COMPANY.TELEPHONE, COMPANY.FAX, COMPANY.E_MAIL, COMPANY.DEL_TELEPHONE, COMPANY.DEL_FAX,

COMPANY.DEL_E_MAIL, COMPANY.VAT_REG_NUMBER, COMPANY.NAME AS Expr1, INVOICE.INVOICE_DATE, INVOICE_ITEM.FOREIGN_FULL_NET_AMOUNT, INVOICE_ITEM.FOREIGN_NET_AMOUNT,

INVOICE_ITEM.FOREIGN_TAX_AMOUNT, INVOICE_ITEM.FOREIGN_GROSS_AMOUNT, INVOICE.FOREIGN_INVOICE_GROSS, INVOICE.FOREIGN_INVOICE_NET, INVOICE.CURRENCY_TYPE, INVOICE.CURRENCY,

INVOICE.FOREIGN_AMOUNT_PREPAID, INVOICE.ANALYSIS_1

FROM INVOICE, INVOICE_ITEM, COMPANY

WHERE INVOICE.INVOICE_NUMBER = INVOICE_ITEM.INVOICE_NUMBER AND (INVOICE.INVOICE_NUMBER = @INVOICE_NUMBER)

Any Ideas

General Discussions