I need to perform a calculation and show the result in the Page Header of my report.
The calculation comes from 3 different data sources: The report-scoped data source, and 2 separate data sources that are being bound to 2 tables in the Report Footer.
I'm able to get the values I need from the report-scoped data source, as follows:
= exec("ReportName", sum(Fields.Amount))
I have not been able to determine how to access the fields from the other 2 data sources. I've tried numerous ways to access the scope, but I always get "invalid scope" error. I've tried:
= exec ("My2ndDataSourceName", sum(Fields.Amount))
= exec ("My2ndTableName", sum(Fields.Amount))
= exec ("ReportName.My2ndTableName", sum(Fields.Amount))
I can't find good examples in the documentation that describe how to access scopes other than the top-level "report" scope.
Thanks
Hi there,
after updating our reporting service to 10.2.16.914 we found this issue:
if using TextFields (like txtPeriodHeader) and set Value in a NeedDataSource event, they are empty.
After resetting to 9.2.16.1216 everything worked as expected.
txtPeriodHeader.Value = String.Format(
"{0} - {1}"
, StartDatum.ToShortDateString(), periodEnd.AddMonths(1).AddDays(-1).ToShortDateString());
This works in 9.2.16.1216 as expected, in 10.2.16.914 we got empty fields.
Best regards
Manfred
Hi,
I need To print 2 headers respectively to there data in a report.
i.e.: - print the first Header on every page until it's data section all printed
- then break the page and start the next page with the 2nd Header and keep going with the second Header until the end of the report.
I tried binding in the Header Section and set
"PrintOnEveryPage" to : PageExec( "DetailSection...and other Items", Count(Fields.TriedManyItemFromDataObject)>0)
but it is returning a 0 all the way. I checked your invoice example to understand the function specially the scope parameter and I see that you are using "lineTotalDataTextBox" as scope in you examples. Could you explain why you are choosing only this textBox ?
I will appreciate any help in Advance.
Thanks.
I must be missing something obvious but I am unable to create a 'simple' grouped table according to the following layout:
-------------------
| GROUP1
| -item1
| -item2
| GROUP2
| -item3
| -item4
-------------------
The datasource i am using is flat.( Item1 { Group ="GROUP1", Name = "item1"}) etc.
Is it even possible to do this with a single table? I've been going at it for about two hours now, i've seen all kinds of results, but not what i need :-)
Hi, I am using VB.NET web application with Telerik Reporting (standalone designer) where I am passing some parameters from VB.net code to the Telerik report, as shown below.
ReportViewer1.ReportSource.Parameters.Add(New Telerik.Reporting.Parameter("FromDate", dtpFromDate.SelectedDate))
ReportViewer1.ReportSource.Parameters.Add(New Telerik.Reporting.Parameter("ToDate", dtpToDate.SelectedDate))
This works fine for a single-value parameter, however, how can I pass on a multivalue parameter from VB.net to the Report. For instance, I am using a radCheckBoxList where the user can select more than one selection. How to pass the radCheckBoxList selected items/values to the multivalued parameter.
Thanks in advance,
Hi,
I want to set the detail height of the section in Telerik Report ..........
For Example :- In detail section it must accomodate 10 records in this section, if the report contain 1 record ,9 empty records will be inserted in the detail section...
I created a report
using sqlDataSource with parametrized store procedure,
Is
it possible to show a "no data exists" message if the query returns no data?
Having a problem with one of my reports, it either gets blank or shows the same data regardless of which value I set the (using only one parameter) report parameter to.
I have discovered that if I set the parameter to a value in the "Configure data source parameters" it will allways show a report with data based on that value. Even if I set another parameter by source code.
If I don't set the value of the parameter in "Configure data source parameters" the report shows up blank, regardless of which value I put into it at designtime (Preview) or runtime (by code).
It's like the value set by designtime or at runtime gets overrided by the value in "Configure data source parameters". If I leave value in "Configure data source parameters" blank the report will be blank.
I've checked all the things mentioned in "http://www.telerik.com/support/kb/reporting/details/problem-telerik-reporting-renders-blank-pages". I've tried re-create the data source.