Telerik Forums
Reporting Forum
1 answer
101 views
Hello There,

I saw some articles where it discusses how to add a new total row, but how do i solve this problem with and existing one?

I have a report page where i have total and grand total values dispalyed in some of the row. How do i use the conditional formatting so if any row contains a word like 'total' it is highlighted in yellow

Thanks much in advance
Petio Petkov
Telerik team
 answered on 03 May 2012
1 answer
201 views
I would like to add te selected values of a multivalued parm to the header of my report. E.g. I have a drop down with doctors loaded with a sql data source where doctorid (Guid) is the value member, and name (string) the display member. In my report I want to show the selected doctors or all available in case of no selection. I do not want to show the guids (obviously) but the names...
Yet, only the value members are accessible,  where I would like the get my hands on the display members.

This is my (working) code:
Public Shared Function VoorschrijverLabels(ByVal selection As Object(), ByVal reportItem As Object) As String
 
        Dim labels As String = String.Empty
 
        Try
             Dim processingReport As Telerik.Reporting.Processing.Report = TryCast(reportItem, Telerik.Reporting.Processing.ReportItemBase).Report
             Dim report As rptDagstaat = TryCast(processingReport.ItemDefinition, rptDagstaat)
            Dim da As New SqlDataAdapter(report.dsVoorschrijvers.SelectCommand, report.dsVoorschrijvers.ConnectionString)
            Dim ds As New DataSet
            da.Fill(ds)
 
            For Each row As DataRow In ds.Tables(0).Rows
                If labels.Length > 0 Then labels += "; "
                If selection Is Nothing OrElse selection.Contains(row("VoorschrijverID").ToString) Then
                    labels += row("Voorschrijver")
                End If
            Next
 
        Catch ex As Exception
        End Try
 
        Return labels
 
    End Function
Basically I do an extra query to the database to get the paramater datasource values (again!), and compare them against the selected  value members.
But as you can see, it is not very generic... It's per parameter because I need to cast the report to access the parameter data source and the specific parameter data source properties. A separate function for each multivalued parameter with a separate database call...

The selection variable contains an ArrayList(Of string) These are casted value members of the parameter data source {CStr(VoorschrijverID)} The result of this function is a string with the names of the doctors semicolon separated.

My question is: Is there a more easy way to do this? Preferably without the database call and accessing the parameter data source directly.

Regards,
Raoul

Peter
Telerik team
 answered on 03 May 2012
1 answer
84 views
Hello,

Is it possible to manage dynamically the list of extensions the user can select in the asp.net report viewer at runtime?
We have a list of extensions configured in the Web.Config file. However for some reports only, we would like to change this list to one or two values.
Is there a way to do that?
Thanks for answer.
Regards

Joel
Steve
Telerik team
 answered on 03 May 2012
3 answers
286 views
Hi,
    I have a report in which I need to have a first page header image different than the second page header when exported into pdf.  Also, in html my reports are all on one long page so I don't get to see the second page at all even though I have multiple pages, one for each case # report.  Once it is exported into pdf, paging automatically space out each case # report into multiple pages which is when I need the first page of each report to have the company logo image, and subsequent page headers to be only the case # of the report.  Is there any method or event that tells me the report is rendering on the first page or the second page and beyond?  The page count and page number are for the whole report which I have multiple case # reports in it; is there some way that I can get the page count and page number for each case report? Can you show me some pointers or hints on how to get this done.  
    In summary, I need help on the following:
  1. How to display different header images on second page of the report
  2. Is there any method or event that tells me the report is rendering on the first page or the second page and beyond? 
  3. Is there some way that I can get the page count and page number for each case report? 
Thanks.
Steve
Telerik team
 answered on 03 May 2012
1 answer
69 views
I have a report that I display on the screen witht the report viewer but also the user can print to pdf or to a printer.  The cross tabe section alot of times spreads across two pages.  Is there a way to repeate the row groups on the new page?
Eric Klein
Top achievements
Rank 1
 answered on 02 May 2012
1 answer
97 views
I have a report thathas two groupings on the main report.  I want to put a cross tab in the detail section and have it create the cross table for the data that matches the groupings.  How do I bind the cross tabe table to the groupings on the reports?
Eric Klein
Top achievements
Rank 1
 answered on 02 May 2012
5 answers
742 views
Hi,

I just tried to add the Silverlight report viewer to my application but it fails to load the report.  Originally I tried to use the latest build but it failed completely due to a parse error which I believe was due to the fact that I am currently using version 209.3.1314.1030 version of the controls.  I am not yet in a position to upgrade them to the latest build due to some breaking changes.  I then went for an older version of the reporting tools, in this case 3.2.9.1211 in which the control loads correctly but the report doesn't.

The error I get in the report viewer is as follows...

"Error: Unable to cast object of type 'ReportsLibrary.UsageReport' to type 'Telerik.Reporting.IReportDocument'.

I followed the videos on how to integrate the reports but since this is my first attempt I am at a loss as to what to next.

Cheers,
Clint
Macloud
Top achievements
Rank 1
 answered on 02 May 2012
2 answers
97 views
Advice please.
I created a chart and pribindil. Y-axis indicated the binding property of the COUNTand have DATALABELSCOLUMN NAME. And the legend is not a list of the collection. 

http://i50.tinypic.com/2cxi635.png 

chart1.DataSource = linqToSQL.TableItems.GroupBy(g => g.ColumnInt)
.Select(s =>
new Item { count = s.Count(), name = s.First().Name })
.OrderByDescending(o => o.count).Take(10);

class Item 
{
    public int count { get; set; }
    public string name { get; set; }
}
That is, shows the schedule is correct, but the description of the legend is not correct. 
With respect, thanks 

tableitem
pavel
Top achievements
Rank 1
 answered on 02 May 2012
1 answer
145 views
Hi.  I am using Telerik Q1 2012.  I have a new report which works pulling in a small range of data.  However when I increase the date range of my data, I get the same error message:

"The process cannot access the file C:\Users\uswknp09\AppData\Local\Temp\yadayadayada\Page#157 because it is being used by another process"

As long as I pull less than 157 pages of info, the query completes and displays properly.  If I increase the data volume to where it hits page 157, the query completes, the data is intially displayed, but as the page counter spins through the pages, it stops everytime at page 157 and generates the same error.

I have tried different date ranges in different months, thinking perhaps there was a specific record causing an issue.  The behavior is always the same regardless of the date range selected, so I think this has something to do with Visual Studios or Telerik Reporting, not the data itself.

Can someone shed some light on why this is happening?

Thanks,
Kevin
Steve
Telerik team
 answered on 02 May 2012
3 answers
271 views
Hello,

I have added a pie-chart to my report.  For each "pie-slice", I have added a label that appears just outside the slice.  This works fine.

However, I am unable to add a "connecting-line" from the pie-slice to its label.  Regardless of what code I add (in chart1_NeedDataSource), no LabelConnector appears.  Is there some problem connecting labels to "pie-slices" or am I doing something wrong?

Here is some of the code I use to make the connecting-line appear but nothing helps:

serie.Appearance.LabelAppearance.Visible =
true;
serie.Appearance.LabelAppearance.LabelConnectorStyle.Visible = true;
serie.Appearance.ShowLabels = true;
serie.Appearance.LabelAppearance.LabelConnectorStyle.PenStyle = System.Drawing.Drawing2D.DashStyle.Solid;
serie.Appearance.LabelAppearance.LabelConnectorStyle.Width = 2;

 


Thanks in advance.
Steve
Telerik team
 answered on 02 May 2012
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?