Questions on Reporting Forum

1 answer

739 views

Hi,

I am using Telerik ReportViewer. My report require both horizontal & vertical paging but only vertical paging is working. Can't see horizontal expanded data means horizontal paging is not shown. Do i have to set any property to show horizontal pages or is this a default setting.

I am binding my report viewer at runtime where xaml just refer to a UserControl.

Thanks.

General Discussions

answered on 22 Aug 2013

3 answers

231 views

Watermark on Report with Subreport

Hi All -

When creating a report with a subreport section (like an invoice where invoice items are created on a subreport), the is a challenge with correctly displaying a watermark image. If you embed it on the subreport it doesn't show and if you put it on the main report it is clipped.

Is there any known work around or way to address this?

Thanks,
Mark

General Discussions

answered on 22 Aug 2013

7 answers

323 views

Could not load type xxx from assembly when using chart

Hi,
I'm trying to create a chart in my report but getting:
An error has occured while processing Chart 'chart1':
Could not load type 'DO.ReportBars' from assembly 'DO, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'.

The class is very simple:

    
            namespace DO 
        
            { 
        
                public class ReportBars 
        
                { 
        
                    public ReportBars() 
        
                    { 
        
                    } 
        
                    public ReportBars(string name, int value) 
        
                    { 
        
                        _name = name; 
        
                        _value = value; 
        
                    } 
        
                    private string _name; 
        
                    public string Name 
        
                    { 
        
                        get { return _name; } 
        
                        set { _name = value; } 
        
                    } 
        
                    private int _value; 
        
                    public int Value 
        
                    { 
        
                        get { return _value; } 
        
                        set { _value = value; } 
        
                    } 
        
                } 
        
            }

And the chart code:

    
            private void chart1_NeedDataSource(object sender, EventArgs e) 
        
                    { 
        
                        Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)sender; 
        
                        Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition; 
        
                        List<DO.ReportBars> bars = new List<DO.ReportBars>(); 
        
                        bars.Add(new DO.ReportBars("Parka L", 120)); 
        
                        bars.Add(new DO.ReportBars("Parka M", 100)); 
        
                        bars.Add(new DO.ReportBars("Parka S", 132)); 
        
                        bars.Add(new DO.ReportBars("Wool Cap", 45)); 
        
                        bars.Add(new DO.ReportBars("Mittens", 67)); 
        
                        chartDef.Series.Clear(); 
        
                        ChartSeries s = new ChartSeries(); 
        
                        s.Type = ChartSeriesType.Bar; 
        
                        chartDef.Series.Add(s); 
        
                        s.DataYColumn = "Value"; 
        
                        s.DataLabelsColumn = "Name"; 
        
                        chart.DataSource = bars; 
        
                    }

The strange thing is that it works if I move the ReportBars class to the same namespace as the report so the ReportBars is not placed in a different assembly.

General Discussions

answered on 22 Aug 2013

1 answer

228 views

Making a Gantt Chart

Hello,

I'm trying for the life of me to make a Gantt chart using the new reporting graph thing and haven't had any luck, and can't find any help/examples online. The goal here is to make a day schedule - so you see from 8am to 9pm or so with bars representing when you have something on your schedule. If and when those bars overlap, I'd like them to appear in a second row. The bars should then have the title of the event in them.

To make it all simple, I made a simple class called "Test" with properties for "Category", "StartTime", "EndTime" and "Title". I've added three of them to a list and bound that to the graph's datasource in code on the "NeedDataSource" event.

Everything I try seems to just produce a graph with a single box on the right. I have the x value as start time and the y value as end time, but that doesn't seem to do anything or matter. I have series and category groups that both are the category field... which may not be right.

Can anybody help?

Thanks,

Mike

General Discussions

answered on 21 Aug 2013

3 answers

1.1K+ views

Cross Tab Reports - Hide Rows where groupname is null

I am running a report off a query that is using a LEFT OUTER JOIN to ensure that dates are included even if there is no data for the dates. (See the bottom of this post for the query).

I am displaying the data in a crosstab report, using the dates as columns. The ideal is that if there is no data for the date then each value in the column displays blank.

This is working. The problem is, if the crosstab has one or more blank columns, then a blank row with no header appears as well..

The attached image shows two crosstabs. The range "11 August to 17 August" has no empty dates, so subsequently there are no empty rows.
But the range "18 August to 21 August" happens to have empty dates. The columns are correctly empty, but there is one group row that has no header.

I can understand why this is so, but how can I make the blank row go away? My guess is that there's some filtering condition along the lines of "if VideoGroupName IS NOT NULL", but I can't seem to find a way to filter away nullness.



select
    date_range_all.Date, 
    values_in_range.VideoGroupName,
    values_in_range.VideoGroupKey,
    values_in_range.NumberOfPlayers,
    values_in_range.AveragePlaysPerHour
from
(
   select date_dimension.date
       from Date_Dimension
           where date_dimension.WeekStartingThuSeqNo IN
          (
                  select distinct Date_Dimension.WeekStartingThuSeqNo
                  from Date_Dimension
                     where Date_Dimension.Date >= @startDate
                    and Date_Dimension.Date < @endDateExclusive
           ) 
) date_range_all
left outer join
(
   -- More query here
) values_in_range
on date_range_all.Date = values_in_range.Date

General Discussions

answered on 21 Aug 2013

5 answers

161 views

Create Table that always has 5 rows

Hello All,

I wanted to create table that has 5 rows regardless of number of entries returned from database. For example if there are only two entries in the database, table should display those entries and also display three emptry rows.

I tried to add those rows manually, but it seems very hard and counter intuitive.

Your help would be greatly appreciated, thanks.

Kind regards,
Ben

General Discussions

answered on 21 Aug 2013

27 answers

2.9K+ views

Sub Reports

Hi,
     I have been evaluating Telerik reports for a few days now. I like what I have seen so far. I need to know one thing before I make a final decision. We have a requirement to merge different reports and export them in PDF format. The number of reports and type of reports vary depending on users search criteria.
    I know we can add sub report items programmatically. Is there a limit on the number of sub report items you can add programmaitcally. If so what is the limit. Also do you have any samples in C# that will show me how to add sub report items programmatically.
       I created a small sample that creates sub report items programmatically. In the report viewer it's showing okay. But when I export it to PDF format the sub report items are overlapping.

Thanks
Bhaskar

General Discussions

answered on 21 Aug 2013

4 answers

103 views

Pie Chart Question

Please see the attached pie chart - I've 14 possible different series in this chart - but there are chances that some of the series can have "0" as their value. On the graph I don't want to show 0.00%. Can you please help me achieve this - I used the graph wizard to generate this graph.

Thanks,

General Discussions

answered on 20 Aug 2013

7 answers

373 views

Localization in paging of RADGrid

How do i localize the text that is written in the bottom when pagination is done in the radgrid. For Example text which displays the page number "Page No. 1 2 3" or text of "Items"
The text in the given quotes need to be in local language selected by the user on the page.

General Discussions

answered on 20 Aug 2013

1 answer

85 views

Necessity of RadControls for Reporting

I see according to your documentation that references to Telerik.Windows.Controls, Telerik.Windows.Controls.Input, Telerik.Windows.Controls.Navigation, and Telerik.Windows.Data are all needed to use the ReportViewer within an WPF app.

Does that mean that I have to purchase a license for the RadControls in order to develop and ship my app using your Reporting app, or can I use the Trial versions of the RadControls to develop and ship my app?

According to this thread it looks as if I could just use the Trial versions, but that was from 2012 so I'm unclear as to how to proceed.

Thanks in advance.

General Discussions

answered on 19 Aug 2013