Telerik Forums
Reporting Forum
1 answer
660 views

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

 

Stef
Telerik team
 answered on 16 Dec 2016
8 answers
451 views
I am building a 1 page report, which requires that I have a few images along the entire length of the right side of the report.  It also requires that I display a field vertically along the right side of the report. Please look at attachment for example. 
I haven't seen how to do this, or if it is even possible ..
thanks for any help.
-Mike.
Katia
Telerik team
 answered on 16 Dec 2016
7 answers
234 views
Hi all,

  am using telerik reporting chart.

please tell me how to do mouse hover option in pie, line charts etc.

previously i used radchart. so i can able to do mouse hover option.

protected void chartPie_ItemDataBound(object sender, ChartItemDataBoundEventArgs e)
        {
           
                    e.SeriesItem.Name = ((DataRowView)e.DataItem)["lab_name"].ToString();
                    e.SeriesItem.ActiveRegion.Tooltip = ((DataRowView)e.DataItem)["lab_name"].ToString();
                }


But  in telerik reporting chart, the event does not contain ChartItemDataBoundEventArgs .so i cant do like as below..

How to do it in telerik reporting chart?


Thanks for any help


Stef
Telerik team
 answered on 16 Dec 2016
1 answer
62 views

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

Stef
Telerik team
 answered on 16 Dec 2016
3 answers
672 views

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.

 

Stef
Telerik team
 answered on 15 Dec 2016
5 answers
2.8K+ views

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 :-)

 

 

Katia
Telerik team
 answered on 15 Dec 2016
7 answers
536 views

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,

Shady
Top achievements
Rank 1
 answered on 14 Dec 2016
3 answers
229 views

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... 

 

 

 

Katia
Telerik team
 answered on 14 Dec 2016
11 answers
717 views

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?

 

Stef
Telerik team
 answered on 14 Dec 2016
2 answers
176 views

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. 

 

David
Top achievements
Rank 1
 answered on 14 Dec 2016
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?