Hello. I'm in the middle of creating a report that requires some report controls to be rotated. I see in the Telerik Reporting Tutorial that control rotation is available by a property called Angle, and is directly editable in the designer indicated by 'small curved lines around each corner.' I'm using Telerik Reporting Q3 2012 release, and I see no angle property or small curved lines. Any ideas?

We are upgrading a project and moved .net version to 4.0 from 2.0.  Project is working fine, except that the reportviewer only displays many instances of "Submit Query" instead of the reportview toolbar, and the report does not run.

Any ideas how to get around it?  Windows server 2008.  Telerik.ReportViewer.WebForms  7.0.13.220, Asp.Net 4.0 app pool

I've done a few reports using OpenAccess ORM that allow me to use a sql stored procedure that returns multiple datasets of complex type; however, I've been assigned to do these using EF5 only instead of using OpenAccess ORM since the rest of our app uses EF5.

The report is set up during design time and report params are assigned as sql stored proc params when the sqlDataSource is created. We are then using mvvm, so the report params are being passed in the viewmodel and then the report is run. I've successfully done this for reports using stored procedures returning only one dataset. However, I have not been successful figuring out how to configure a sqlDataSource with multiple data sets returned. It appears that the Data Explorer is only seeing the first return and the others cannot be accessed in any of the setups or explorer windows. I haven't been able to find any documentation to possibly set this in the viewmodel either.

Do any of you have any tips on how to go about setting up the sqlDataSource for multiple returns if this can even be done?

Hi,
I want to design  telerik report like below attachment. How to  create tables in reports?. Also the data source is from a data set, containing multiple tables like basic details,qualification details and travel details. How to set all of the data table's as a data source for report?.

Thanks & Regards
Anzar.M

You can see my report layout/design/structure on report_design.jpg (attached)
You can see this report's output on report_1stpage.jpg and report_2ndpage.jpg (attached)

as you can see there's lightgray bottom borders for the elements in the table, I would like
to change the border for the bottom elements in the table to black line. I simulated that
behavior on the 1st page by adding a text box after the table with bottom border line black, 
but I don't think this covers the second page..... so a better solution would be to add a 
conditional style for those bottom rows (like biding???) .... but how do I do that? is this
even possible?

I already have row groups and column groups for the elements and as you can see,
that's how I spread the data vertically and horizontally across the pages... 

thanks for your help.

Just writing this here for anyone else who gets stuck by this.

My function was:
public static string CalculateFieldDescription(DateTime deliveredDate)
{
....
}

If deliveredDate was null in the data, I would get error:
"An error has ocured while procesing TextBox: The expression contains undefined function call CalculateFieldDescription() .

Now here:
http://www.telerik.com/support/kb/reporting/designing-reports/the-expression-contains-undefined-function-call-myuserfunction-error.aspx
Telerik in their wisdom say "3.A field specified as function argument is null. Make sure that such cases are handled in the user function.
Um, you don't get the opportunity dude, it is ERRORING BEFORE IT IS GETTING CALLED.
So your point #3 is clearly bogus and wrong.

A solution is simply, change your function to have Object parameter:
public static string CalculateFieldDescription(Object deliveredDate)
{
  if (deliveredDate != null)
  {
     // Do conversion and use it.
  }
}

Hope this is more helpful then Telerik's doco.

Pat.

Hello Everyone,

I am using a Telerik Report Control and it solved lots of Technical problems while dealing with complex report data.
However after some time we got one major issue related to layout and alignments of the data.
The textboxes were getting miss aligned when there is a huge data in some fields which was looking quite messy in the web browser.

After release of Q3 2012, we decided to go with the Table based layout provided by telerik and we hope it will solve our problem for sure.
Ref:  http://www.telerik.com/help/reporting/table-working-with-table-cross-table-list-items.html
While working with the trial version of the Q3 we assumed that Table based layout will solve the issue and we will be able to get a well aligned data from the Telerik Report in browser. But here we got another issue related to paging.
As the Table renders all records on the one page and doesn't presents the data with multiple pages irrespective of row count.
I set all Page Settings properly for the report but still not getting the expected results.
It seems telerik renders paging on the basis of repeated details section in it but in my case i have added a Table Control on the details Section it self and have assigned Datasource property of Table control.
Can anybody suggest how to make it to display data page wise :) Or how to get rid of this Miss alignment issue in the report viewer?

Also is there any way we can have command over rendering HTML for report fields? So it will be easy to customize the rendered output and add some Html in it?

I am adding two Screenshots 
1) Miss aligned stuffs: to show the existing report which is miss aligned due to excess data
2) table based trial : to show the things which i tried along with the output which contains data of about 100 Rows but getting displayed on single page in report

Please Help,

Thank You

I have a telerik report (converted from Crystal Reports) which uses a dataset of user logon information.

Fields included are IP address, User Account, Time of Logon, Logon Success, etc.

There are two groupings currently.  The first grouping is by IP Address.  Then within that there is a group by User Account.

An example report would look like this:

192.168.1.1

            Admin
                        Admin        1/1/2001        Success
                        Admin        1/2/2001        Fail
           Total for this User: 2                                   [back to top link]*

            User52
                        User52        3/1/2001       Fail
                        User52        4/1/2001       Success
                        User52        4/1/2001       Success
            Total for this User: 3                                   [back to top link]*

Total for this IP Address: 5                                     [back to top link]


192.168.2.2
            Admin
                        Admin          5/1/2001       Success
            Total for this User: 1                                    [back to top link]*

Total for this IP Address: 1                                      [back to top link]

---------------------------------

The issue I'm encountering is the "back to top" hyperlink I have in the "User Account" footer (the ones with the astericks) are navigating to the first instance of that User Account value in the entire report.  I want the hyperlinks to navigate to the first instance of that User Account within the current User Account group.  The hyperlinks themselves are necessary for our clients as each IP address listed (and User Accounts within) may span multiple pages.

I have the "Action" on my "back to top" textbox set to "Navigate to Bookmark" and I've tried: 
a) setting the bookmark action to the actual "User Account" field (=Fields.[fld1]) from the drop-down list.
b) setting the "User Account" group (not header) bookmark ID to the actual "User Account" field (=Fields.[fld1]) and then setting the "Navigate to Bookmark" to the same.
c) setting the "User Account" group (not header) bookmark ID to "UserBookmark" and then setting the "Navigate to Bookmark" to "UserBookmark".

All three result in the same issue of it the link navigating to the first instance of that User Account within the report instead of the first instance of that User Account within the group..

The help says for adding bookmarks to a group: "Typically for a group, the expression you type should be the group expression".  If this is not what I tried in B) above, can someone please let me know what to do?

The help also mentions "The BookmarkId can be any string, but it must be unique in the report. If the BookmarkID is not unique, an action to the bookmark finds the first matching bookmark." - which I assume is what I am encountering.  I'm guessing it hasn't been an issue in most of my reports because they do not use secondary grouping where a secondary group header may exist within more than one primary group headers.

Any help would be appreciated. I'm still trying to learning telerik, but I keep running into things that were possible in Crystal but are proving difficult (or impossible) here.

Thanks,

James

Well,

Can you tell me why all my reports become "out of order" when I update to the 7.0. 13.220?  More, It's impossible to edit in design!

See attachement...

I hope I don't have to recreate from scrach !

Hey,

We have updated our controls to Q1 2013. Since this update all the paramater values are null in code behind.  
Our report has a chart and a table.
The table is bound to a Objectdatasource. The function behind this ObjectDatasource gets al the params correct.
The chartseries are set from the code in the function OnNeedDataSource here the parameters (ReportParameters["SelectedBeginMonth"].value) aren't set since the new update.

Below the code we use.

The client code from silverlight

The code behind of the report 

(the params aren't correct)

protected override void OnNeedDataSource(object sender, EventArgs e)

        {

            base.OnNeedDataSource(sender, e);

 

            SetColumnWidth();

            SetColumnWidthRemarks();

 

            DateTime selectedBeginMonth = new DateTime(DateTime.Today.Year,DateTime.Today.Month,1);

            if (ReportParameters["SelectedBeginMonth"].Value != null)

            {

                DateTime.TryParse(ReportParameters["SelectedBeginMonth"].Value.ToString(), out selectedBeginMonth);

            }          

 

            int selectedDuration = 0;

            if (ReportParameters["SelectedDuration"].Value != null)

            {

                int.TryParse(ReportParameters["SelectedDuration"].Value.ToString(), out selectedDuration);

            }          

 

            keyFiguresChart.Series.Clear();

            for (int i = 0; i < selectedDuration; i++)

            {

                var serie = new ChartSeries

                {

                    DataYColumn = "Year" + (i + 1),

                    Name = selectedBeginMonth.AddYears(i).ToString("dd/MM/yyyy") + " - " + selectedBeginMonth.AddYears(i + 1).AddDays(-1).ToString("dd/MM/yyyy"),

                };

 

                serie.Appearance.ShowLabels = false;

                keyFiguresChart.Series.Add(serie);               

            }           

        }

The method that is bound to the objectdatasource of the table(the params are correct)
public IQueryable<KeyFiguresDto> GetKeyFiguresDtoForOtherData(bool showNewEmployees, bool showPercentageFemales,bool showPercentageMales,bool showPercentageUnknownGender, bool showPercentageInflow, bool showPercentageOutflow,
                                                            bool showPercentageParttimeEmployees, bool showPercentageXYearsSeniority, bool showPercentageYoungEmployees,
                                                            int keyFigureReportAge, int keyFigureReportSeniority, DateTime selectedBeginMonth, int selectedDuration)
        {
             
            selectedBeginMonth = selectedBeginMonth.AddYears(-selectedDuration).AddMonths(1);
            var endMonth = selectedBeginMonth.AddYears(selectedDuration).AddDays(-1);
 
            List<KeyFiguresDto> result = new List<KeyFiguresDto>();
            List<KeyFiguresEmployeesDto> employeeAtServiceForPeriod = new List<KeyFiguresEmployeesDto>();
 
........

Sodi We