Telerik Forums
Reporting Forum
7 answers
1.1K+ views
I'm using a parameter editor to create calendar controls to select a date range for reports. All reports share the same Index.cshtml page, and hence, all inherit the same calendar controls. Is there a way to limit the selectable date range for individual reports via the Report Designer or would I have to create separate parameter editors for each report?
Stef
Telerik team
 answered on 08 Mar 2016
8 answers
1.1K+ views
Hello there, I have this report that is basically a table with 64/128 elements that I want to show its headers every 8 items as shown in preview_old.jpg, the design mode for the report can be found at design_old.jpg.

The problem is this report breaks into two pages(or more) when I do the html preview, I do not want that, as this report is part of a report book, and creates "ghost" extra report(s) in the list of reports in the report book. Most of my other reports are made with list objects so they do not break in many pages at html preview, ONLY when I do the print preview, which is just fine.

The map of objects for the current report is shown in map_old.jpg

Find the desired report's output at desired_preview.jpg (I did some image editing to get this)

I would like to use a list object of some sort to accomplish something similar, so that the html preview (or just interactive preview) DOES NOT break into multiple pages. 

How do I do that?.


Stef
Telerik team
 answered on 08 Mar 2016
1 answer
150 views

the warning message I am getting is below. I am a novice and I appreciate if you can help me with this. the original code used telerik reporting before 2012 , and I see some changes were made in 2012

Warning 1 'Public Shared Widening Operator CType(report As Telerik.Reporting.Report) As Telerik.Reporting.ReportSource' is obsolete: 'The implicit Telerik.Reporting.Report to Telerik.Reporting.ReportSource conversion is now obsolete. Please, use a Telerik.Reporting.InstanceReportSource object instead. For more information, please visit: http://www.telerik.com/support/kb/reporting/general/q2-2012-api-changes-reportsources.aspx#reportprocessor.'. 

here is the code

Me.SubReport1.Location = New Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(0), Telerik.Reporting.Drawing.Unit.Inch(0.000078757606388535351))
Me.SubReport1.Name = "SubReport1"
Me.SubReport1.ReportSource = Me.Items_1prev_3future1
Me.SubReport1.Size = New Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(10.69283390045166), Telerik.Reporting.Drawing.Unit.Inch(1.4924474954605103))

 

 

Stef
Telerik team
 answered on 07 Mar 2016
2 answers
214 views
The trial message is showing on production server, I had trial version installed earlier, then I uninstalled it and installed Full version. Build my solution and moved to production. No message on Dev systems?
Stef
Telerik team
 answered on 07 Mar 2016
2 answers
201 views

Hi

We're adding interactive functionality to our reports and would like to run a javascript function when an item is clicked on. Is this possible?

We've been reviewing report actions and can add a URL link (http://docs.telerik.com/reporting/designing-reports-interactivity-how-to-add-hyperlink) but a much improved user experience can be implemented with a javascript function.

Is there a way to do this?

Thanks

Stef
Telerik team
 answered on 07 Mar 2016
3 answers
192 views

Hi,

 

it is possible to obtain page numbers per line. I need to save the current page number in the database per line.
Right now I have a report where I determine the line and page numbers, but page numbers are generated after printing, so I can only save the scope of pages.

Thank you.

Andreas

Nasko
Telerik team
 answered on 07 Mar 2016
1 answer
167 views

We are using the Report Designer (standalone) tool and have noticed that our report parameters requiring a single value come up with an error message as soon as the report loads as if it is attempting to run without first allowing the user to input a value.

"Missing or invalid parameter value. Please input valid data for all parameters."

I have read through documentation which seems to indicate that as long as a default value is not being provided then it should not try to execute. An example parameter and its propertiers is below:

*******************************

AllowBlank = False

AllowNull = False

AutoRefresh = False

AvailableValues = (none)

Mergeable = True

MultiValue = False

Name = dt_datetime_start

Text = Datetime Start

Type = DateTime

Value =

Visible = True

*******************************

As you can see, there is nothing defined in the Value field, yet the report tries to execute as soon as it is loaded, giving an error that this field is not populated. I have found other references about custom JavaScript that can be put in, but this was unsuccessful.

I'd like to know within the standalone Report Designer tool, how we can ensure that the report does not execute before the user has a chance to enter values.

Nasko
Telerik team
 answered on 07 Mar 2016
1 answer
95 views

New user and a couple of things I noticed that would be nice to see in the next version.

1. Ctrl C and Ctrl V. Yes I am old. When setting up reports. I will copy and paste objects many times. Having to use the right click really slows me down. Think of adding boxes around fields. You want to set the box up once, and then copy and resize as needed.

2. Select all/Copy on the "configure data source command" window. Numerous times when developing reports I realize that I need to alter my query. I have to use the mouse to select all the text, right click, copy and then back into SQL to modify it. Would be nice to have a faster way of doing that.

3. Drag and Drop of Data Explorer Fields. Yes you can drag and drop fields to the report canvas. However, there are 2 things that would be nice. First, the scroll bar resets its position so you now have to scroll through the list of fields to figure out where you last left off. Finally, there is no visual indicator such as a check mark of color to indicate that you have already added this field to the report.

4. Suppress blank fields. This is a Crystal Reports feature that I loved (sorry..had to say it). I could create a container, stack vertically numerous fields and if any field as empty, it would hide it and move the rest up. I read the article you have on this and it does work. However, having to manually shrink all fields, then set the Can Shrink and Can Grow attribute...really cumbersome.

 

Nasko
Telerik team
 answered on 07 Mar 2016
2 answers
208 views
I set the reportSource parameters in Javascript and they get passed to the WebApi, but when the method my Report's ObjectDataSource is wired up to is called, the parameters are null. I setup the report parameters and the objectdatasource parameters and made sure they all have the same name. I have been used JustDecompile to see why the parameters don't get passed all the way through and it seems as though in the end the reportsource parameters are empty.
Dustin
Top achievements
Rank 1
 answered on 04 Mar 2016
1 answer
316 views
I am working on Telerik Report and i want to add filtering on report parameter. I have two multi value dropdowns. When multiple values from one box is selected data in other multi value box is  filtered. I am having issue with FilterOperator.In as not getting how to pass multiple comma seperated values to it. Below is my code:
 var calendarPara = new ReportParameter(FacilityScheduleParameter.Calendar, ReportParameterType.String, null);
            calendarPara.Visible = true;
            calendarPara.AvailableValues.DataSource = calendarList;
            calendarPara.AvailableValues.DisplayMember = "=Fields.CalendarName";
            calendarPara.AvailableValues.ValueMember = "=Fields.ID";
            //calendarPara.AvailableValues.Filters.Add("=Fields.BookingType=Parameters.Event OR Parameters.Event='" + GetDataSourceSql.AllValue + "' OR Fields.BookingType='" + GetDataSourceSql.AllValue + "'",
            //            Telerik.Reporting.FilterOperator.Equal, "=True");

            calendarPara.AvailableValues.Filters.Add("=Fields.Category", Telerik.Reporting.FilterOperator.In, " ='Acat','11111','Xyz' ");


Filter is not working, i am not getting correct syntax.
Please help as stuck in it and have very important delivery to wind up
Stef
Telerik team
 answered on 03 Mar 2016
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?