Questions on Reporting Forum

2 answers

390 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

answered on 03 Apr 2019

3 answers

341 views

Report Viewer Parsing Url Issue

We have our reports hosted on Azure Blob Storage and would need to provide SAS token in the Url for them to open correctly. The behavior we are noticing with Report Viewer is very peculiar.

The token we pass in the Url looks like this: sp=r&st=2019-03-26T21:39:32Z&se=2019-03-27T05:39:32Z&spr=https&sv=2018-03-28&sig=6BSlZTyohlqKSSHFRCSj2Y%2BpmIiQ4LOB2M%2FmHnKrIdc%3D&sr=b

We looked at the request made by Report Viewer to download the file using Fiddler and it shows: sp=r&st=2019-03-26T21:39:32Z&se=2019-03-27T05:39:32Z&spr=https&sv=2018-03-28&sig=6BSlZTyohlqKSSHFRCSj2Y+pmIiQ4LOB2M/mHnKrIdc=&sr=b

If you notice %2F is being translated as +, but for Azure that's how the SAS tokens work and the call gets rejected with 403.

We thought maybe we can encode the Url but doing that we are running into this limitation.

Unable to get report parameters.

An error has occurred.
The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

Any suggestions?

Thanks,

Harsimrat

General Discussions

answered on 03 Apr 2019

1 answer

321 views

Disable Double Click In Report Viewer

Hi,

I'm using the Telerik report viewer for angular (https://docs.telerik.com/reporting/angular-report-how-to-use-with-angular-cli). Is there a way to disable the zoom on double click?

Regard,

General Discussions

answered on 03 Apr 2019

2 answers

389 views

Automated Unit Tests for Reports

Hi there,

I'm going to be building some reports based on a Web Service data source and I was wondering if there's any way to build some unit tests so we can identify if a change to the underlying data / a missing sub-report etc has broken anything.

Thanks in advance,

Mat

General Discussions

answered on 03 Apr 2019

2 answers

192 views

404 not found when deployed to Azure Server

We have our trdp files available using external link and since we deployed this from local machine to Azure server, we started to get this 404 Not found and it's super uninformative on what's happening. We don't have CORS issue, as you can see the server is being hit in Fiddler logs and it goes as far as render the document.

Any help will be much appreciated.

General Discussions

answered on 02 Apr 2019

5 answers

1.3K+ views

Problem with merged cells in excel

Hi!
I have a problem with merged cells in excel. When I export from Report Designer R1 2017 to excel and turn on filter by selected cell's value in excel. As result it shows only first row of data.

Best Regards, Max.

Report Designer (standalone)

answered on 02 Apr 2019

1 answer

261 views

adding vertical line in chart as separator

is it possible to add a vertical line in a column chart to separate previous year values from current year values?

Report Designer (standalone)

answered on 02 Apr 2019

1 answer

198 views

Set pagebreak using a parameter

I have a report and I need to set a group '' property to 'after' if a parameter on the report is 'true'. Is there a way of doing it?

I am using the report designer for WPF.

General Discussions

answered on 01 Apr 2019

1 answer

1.7K+ views

Convert String value to Float

Hello,

in my project i need to sum values from DB column which contains string values too (column Value (type String)). I have information about type of Value (column Type).

Please is possible to write expression for conversion Value from type String to type Float and then SUM all this numeric values?

Simplified model:

ID Value Type

================

1 5,21 number

2 text 1 string

3 4,56 number

4 text 2 string

And i need summary: 5,21 + 4,56 = 9,77

Thanks for any idea.

Lukas

Telerik Report Designer v11.2.17.1025

General Discussions

answered on 29 Mar 2019

1 answer

81 views

Get report ItemCollection and change their value

Hello,

We have a Win Forms project with a Telerik Report and at the same project we have a Form where we added the report viewer. What we want to do is to get the item collection of the Report to our main Form and change their values before we display the report at the viewer.

Thanks in advance for your time.

General Discussions

answered on 29 Mar 2019