Questions on Reporting Forum

4 answers

277 views

Clear button on Multivalue parameter does not unselect values

I have a report that contacts a MultiValue parameter. It works as I would expect. The "<select all>" works as expected. All that is good. My question is this: There is a "Clear" button at the top of the dropdown. For a MultiValue parameter when I select "Clear" it doesn't do anything to the checked values. In other words the "Clear" doesn't really clear the selected values.

Questions:

Can I hide/remove the "Clear" button in the dropdown?
If I can't hide/remove the button, can I wire up the Clear button to make it do an unselect all action?

Thanks,
Chris

General Discussions

answered on 22 Aug 2013

3 answers

195 views

User Defined Functions

We have some internal staff using the Report designer to build different flavors of reports I have built in visual studio.

I previously provided them my report.dll so they could see those reports.

They have an expression in the report that slows down the processing of the report. I would like to build a user defined function that could handle some of this and then I can use "SELECT CASE" statements, etc. How can the current row of the dataset be based in a user defined function when it is called from an expression. The expression is below.

= IIf(Fields.AdjType1 = "ETR", "$" + " " + Fields.AdjAmount1,IIF(Fields.AdjType2 = "ETR", "$" + " " + Fields.AdjAmount2,IIF(Fields.AdjType3 = "ETR", "$" + " " + Fields.AdjAmount3,IIF(Fields.AdjType4 = "ETR", "$" + " " + Fields.AdjAmount4,IIF(Fields.AdjType5 = "ETR", "$" + " " + Fields.AdjAmount5,IIf

(Fields.AdjType1 = "ETR T", "$" + " " + Fields.AdjAmount1,IIF(Fields.AdjType2 = "ETR T", "$" + " " + Fields.AdjAmount2,IIF(Fields.AdjType3 = "ETR T", "$" + " " + Fields.AdjAmount3,IIF(Fields.AdjType4 = "ETR T", "$" + " " + Fields.AdjAmount4,IIF(Fields.AdjType5 = "ETR T", "$" + " " + Fields.AdjAmount5,IIf(Fields.AdjType1 = "PARKT", "$" + " " + Fields.AdjAmount1,IIF(Fields.AdjType2 = "PARKT", "$" + " " + Fields.AdjAmount2,IIF(Fields.AdjType3 = "PARKT", "$" + " " + Fields.AdjAmount3,IIF(Fields.AdjType4 = "PARKT", "$" + " " + Fields.AdjAmount4,IIF(Fields.AdjType5 = "PARKT", "$" + " " + Fields.AdjAmount5,IIF(Fields.OptSvcCust1Code = "ETR", "$" + " " + Fields.OptSvcCust1TotalAmt,IIF(Fields.OptSvcCust2Code = "ETR", "$" + " " + Fields.OptSvcCust2TotalAmt,IIF(Fields.OptSvcCust3Code = "ETR", "$" + " " + Fields.OptSvcCust3TotalAmt,IIF(Fields.OptSvcCust4Code = "ETR", "$" + " " + Fields.OptSvcCust4TotalAmt,IIF(Fields.OptSvcCust5Code = "ETR", "$" + " " + Fields.OptSvcCust5TotalAmt,IIF(Fields.OptSvcCust6Code = "ETR", "$" + " " + Fields.OptSvcCust6TotalAmt,IIF(Fields.OptSvcCust7Code = "ETR", "$" + " " + Fields.OptSvcCust7TotalAmt,IIF(Fields.OptSvcCust8Code = "ETR", "$" + " " + Fields.OptSvcCust8TotalAmt,IIF(Fields.OptSvcCust1Code = "ETR T", "$" + " " + Fields.OptSvcCust1TotalAmt,IIF(Fields.OptSvcCust2Code = "ETR T", "$" + " " + Fields.OptSvcCust2TotalAmt,IIF(Fields.OptSvcCust3Code = "ETR T", "$" + " " + Fields.OptSvcCust3TotalAmt,IIF(Fields.OptSvcCust4Code = "ETR T", "$" + " " + Fields.OptSvcCust4TotalAmt,IIF(Fields.OptSvcCust5Code = "ETR T", "$" + " " + Fields.OptSvcCust5TotalAmt,IIF(Fields.OptSvcCust6Code = "ETR T", "$" + " " + Fields.OptSvcCust6TotalAmt,IIF(Fields.OptSvcCust7Code = "ETR T", "$" + " " + Fields.OptSvcCust7TotalAmt,IIF(Fields.OptSvcCust8Code = "ETR T", "$" + " " + Fields.OptSvcCust8TotalAmt,IIF(Fields.OptSvcCust1Code = "PARKT", "$" + " " + Fields.OptSvcCust1TotalAmt,IIF(Fields.OptSvcCust2Code = "PARKT", "$" + " " + Fields.OptSvcCust2TotalAmt,IIF(Fields.OptSvcCust3Code = "PARKT", "$" + " " + Fields.OptSvcCust3TotalAmt,IIF(Fields.OptSvcCust4Code = "PARKT", "$" + " " + Fields.OptSvcCust4TotalAmt,IIF

(Fields.OptSvcCust5Code = "PARKT", "$" + " " + Fields.OptSvcCust5TotalAmt,IIF(Fields.OptSvcCust6Code = "PARKT", "$" + " " + Fields.OptSvcCust6TotalAmt,IIF(Fields.OptSvcCust7Code = "PARKT", "$" + " " + Fields.OptSvcCust7TotalAmt,IIF(Fields.OptSvcCust8Code = "PARKT", "$" + " " + Fields.OptSvcCust8TotalAmt,"")))))))))))))))))))))))))))))))))))))))

Report Designer (standalone)

answered on 22 Aug 2013

1 answer

717 views

Horizontal paging not working

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

225 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

313 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

220 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.0K+ 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

157 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.8K+ 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

101 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