Telerik Forums
Reporting Forum
5 answers
171 views
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
Stef
Telerik team
 answered on 14 Mar 2013
1 answer
145 views
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
Elian
Telerik team
 answered on 14 Mar 2013
1 answer
80 views
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 !

Peter
Telerik team
 answered on 14 Mar 2013
4 answers
548 views
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
.........
reportViewer.Parameters[
"SelectedBeginMonth"] = selectedBeginMonth;
 reportViewer.Parameters["SelectedDuration"] = selectedDuration;
 
if (string.IsNullOrEmpty(reportViewer.Report))
            {
                //first time => setting the report will automatically load it
                reportViewer.Report = "Anton.Server.Reports.M01_OrganisationModule.KeyFigures.KeyFigures, Anton.Server.Reports, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
            }
            else
            {
                reportViewer.RefreshReport();
            }

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
Licenses
Top achievements
Rank 1
 answered on 14 Mar 2013
1 answer
169 views
I tried tutorial put report in MVC http://www.youtube.com/watch?v=t-iA05KpDFM

I have this error for my report

c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\40275438\83dd9ced\App_Web_testreport.aspx.34631e4.fdgmfmtb.0.cs(247): error CS0234: The type or namespace name 'Reporting' does not exist in the namespace 'Telerik' (are you missing an assembly reference?)

I already have telerik.reporting and telerik.reportviewer.webforms in my reference folder.

Anyone has any idea what goes wrong?
Obi-Wan Kenobi
Top achievements
Rank 1
 answered on 14 Mar 2013
1 answer
87 views
i sue Telerik_Reporting_Q3_2012_v6_2_12_1017_Dev.
 i sue multi sub report  (file :sub1.png ) but when export file PDF then format error(file 2:format.png).
please help me.
Petio Petkov
Telerik team
 answered on 14 Mar 2013
3 answers
129 views
I'm using the WPF ReportViewer control. When a user clicks the Print button in the toolbar, the print dialog shows. In the Print Range section, "All" pages is selected and it cannot be changed. I'd like to be able to print a range of pages from a report. Is that possible?
Petio Petkov
Telerik team
 answered on 14 Mar 2013
1 answer
134 views
I need to bind reports to untyped datasets.  With another reporting software, I could output the untyped dataset to xsd and xml and then use them with the report designer at design time to get the schema for the report layouts and even have sample records to preview with the designer.  How can that be done with the Telerik reports.
Stef
Telerik team
 answered on 14 Mar 2013
2 answers
117 views
Hi Telerik team,

I need to pass some of my entities as parameters to my report and then propagate them down to my subreport.

i tried something like this: 

var instanceReportsource = new InstanceReportSource();
instanceReportsource.ReportDocument = new InventoryReport
instanceReportsource.Parameters.Add("location", location);
instanceReportsource.Parameters.Add("filters", filters);
ReportViewer2.ReportSource = instanceReportsource;
ReportViewer2.RefreshReport();
ReportViewer2.Update();

The problem is when i hook to the item binding events I see no parameters in the processing items. 

What am I doing wrong. What is the best way to pass the entities to the report and subreport?

thanks.
Ivan
Top achievements
Rank 1
 answered on 14 Mar 2013
2 answers
105 views
Hi,
When i adding Telerik reports to my web application, I can't create the new data source. Error Image attached.

Thanks & Regards
Anzar.M
Anzar
Top achievements
Rank 2
 answered on 14 Mar 2013
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?