Telerik Forums
Reporting Forum
3 answers
196 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
171 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
101 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
213 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
330 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
1 answer
155 views

Hello,

Is it possible to suppress a section so that datasources bound only to element(s) inside the section will not be loaded? Crystal Reports has this feature and it is very handy for debugging reports with datasources that take some time to load. 

 

Best regards,

Magnus

Katia
Telerik team
 answered on 03 Mar 2016
1 answer
639 views

Hello,

Could someone provide me steps to bind a data set from Main Report Datasource to a SubReport Datasource?

I'm using 6.1.12.823 version of telerik reporting integrated with Visual Studio.

Best Regards,
Emídio Teixeira

Stef
Telerik team
 answered on 03 Mar 2016
5 answers
313 views
I've read the article at Telerik Blog regarding using a function to UPPER any text for a filter.  My Filter does work when the case is correct, ie. 'Framework' but 'framework' does not.  I'm doing this in code and i'm using the StringToUpper() function from the above blog.  When I apply, no records are found at all.

My code looks like this.

Telerik.Reporting.Filter newfilter = new Telerik.Reporting.Filter();
newfilter.Expression = StringToUpper("=Fields.AgreementName");
newfilter.Operator = Telerik.Reporting.FilterOperator.Like;
newfilter.Value = "%" + filter.ToString()) + "%";
table1.Filters.Add(newfilter);

The resulting Expression looks like this
{=FIELDS.AGREEMENTNAME Like %FRAMEWORK%}

This returns 0records....Ideas?
Stef
Telerik team
 answered on 03 Mar 2016
4 answers
273 views

Hi everyone

We are building a WindowsForms application and we would like to include a Report Designer control. Basically give the user the ability to draw up basic reports themselves.

Is there a Telerik Control that can replicate the reporting designer as a windows forms control?

Any other 3rd party designers you know?

Thank you.

Jako
Top achievements
Rank 1
 answered on 03 Mar 2016
1 answer
122 views

Hi,

on my report  I have some report parameter (Visible = true) and I would like to avoid the report preview until at least one of those 3 parameters is been choosen.

If it is possible I also would like to show a message to remind to the user that he has to choose at least one of those parameters

Please, see the printscreen

Thank you
Nasko
Telerik team
 answered on 02 Mar 2016
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?