Questions on Reporting Forum

1 answer

129 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

166 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

166 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

671 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

376 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

330 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

303 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

364 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

174 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