Hi,

I have created a report using table. 
At present:I am getting

column1  column2  column3
-----------------------------
fruit         apple         red
fruit        banana       green
fruit        mango       yellow
car         toyota       black
car         nissan        silver

What I want is:

column1  column2  column3
-----------------------------
fruit         apple         red
              banana       green
              mango       yellow
car         toyota       black
              nissan        silver

So as you can see, grouped column is getting repeated for all grouped rows. However I want it to appear only once.
Heres my code :


 Any suggestions ?

Hello All,
    I am creating a bar chart. The datasource is a datatable having values. The X-Axis has the date and the Y-Axis has values. When done this way the Datapoints are being displayed on top of each bar. I do not want to display the Datapoint value. How do I disable this? I had check the example they had given "chartSeries.Appearance.LabelAppearance.Visible = false;"(doesnot support). Is there any way the I can remove the datapoints.
    Any how I am able to disable if I create series and populate by giving " chart1.Series[1].Appearance.LabelAppearance.Visible = false;" but the problem in this is that I am not able to populate the X-axis with date it asks for a double " item1.XValue = Convert.ToDateTime(TableValues.Rows[i]["StartTime"]).ToOADate();" in this the displayvalue in the chart comes as year 1899, the value passed was “TableValues.Rows[i]["StartTime"]= 2011-11-10 17:10:00". How do I plot values for relevant date?

 

Code:

Telerik.Reporting.Charting.ChartSeries chartSeries1 = new Telerik.Reporting.Charting.ChartSeries();

            for (int i = 0; i < TableValues.Rows.Count; i++)

            {

                Telerik.Reporting.Charting.ChartSeriesItem item1 = new Telerik.Reporting.Charting.ChartSeriesItem();

                item1.YValue = Convert.ToDouble(TableValues.Rows[i]["AlarmCount"]);

                item1.XValue = Convert.ToDateTime(TableValues.Rows[i]["StartTime"]).ToOADate();

 

                chartSeries1.Items.Add(item1);

            }

 

            this.InitiatedChart.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {

            chartSeries1});

 

       The other is that what is the max number of values the graph can hold. The graph does not display for 16,000 points.

I am using visual studio 2010, Telerik Reporting (licensed -TV446243)

Hi there,

I have a report with 2 groups and want to use a count from the inner group in the grouping of the outer group.

For example, the raw data is like this:

Customer          Order ID
Customer A        Order 1
Customer B        Order 2
Customer B        Order 3
Customer C        Order 4
Customer C        Order 5
Customer D        Order 6
Customer D        Order 7
Customer D        Order 8

I can group by customer and use the COUNT aggregate function to get the following:

Customer          Order Count
Customer A        1 order
Customer B        2 orders
Customer C        2 orders
Customer D        3 orders           

However, I want to add another group outside this where the grouping is based on the Order Count from the inner group:

Order Count        Customer Count
1 order                    1 customer
2 orders                  2 customers
3 orders                  1 customer

But you can't use an aggregate function in the grouping field when you set a group up.

Do you know of any work arounds?

Thanks, Jon

Telerik reports doesn't support Segoe UI Symbol & Segoe UI Semibold fonts by default. Can we add these fonts to the reports? Can anybody guide me on this?

I'm using a couple of SQL data sources to populate parameters for a Telerik report. Some of these queries are loaded on very large databases and take upwards of of a minute to execute. I don't have a problem with that, but once values are selected by a user and the Preview button is clicked (in the Web Viewer) it takes even longer to generate the report. I couldn't understand why this was happening, as the resulting queries execute in a couple of seconds, so I started SQL profiler and discovered that the initial queries to populate the SQL data sources assigned to the parameters execute unnecessarily when you click that Preview button. 

Is this expected behavior? Is there a way to prevent this from happening? I'd appreciate any help you could offer on the subject.

Thanks.

I have a single report viewer that I use to show multiple reports. In each of the reports I have a text box called FooterTextBox which places text with the footer of the report at run time. I get errors in the Error List: 'FooterTextBox' is not  a member of 'Telerik.Reporting.Report' of the VS 2010 IDE.

If I ignore the errors during build time the program runs fine and can change the footer text with no issues. However when I am building additional reports the build fails (in the preview) unless I comment out these lines ?        

If Me.FooterTextbox.Text <> "" Then
            myReport.FooterTextBox.Value = Me.FooterTextbox.Text
        Else
            myReport.FooterTextBox.Value = "Printed copies are uncontrolled documents."
        End If 


Report code:

        Dim myReport As Telerik.Reporting.Report = Nothing
        Select Case ReportDDL.SelectedItem.Value
            Case "OSHAItembyPersonnelReport"
                myReport = New OSHAItembyEmployeeReport
                Exit Select
            Case "OSHAItems"
                myReport = New OSHAItems
                Exit Select
            Case "OSHAItemDue"
                myReport = New OSHAItemDue
                Exit Select
        End Select
        Me.ReportViewer1.Report = myReport

        If Me.FooterTextbox.Text <> "" Then
            myReport.FooterTextBox.Value = Me.FooterTextbox.Text
        Else
            myReport.FooterTextBox.Value = "Printed copies are uncontrolled documents."
        End If

        Me.ReportViewer1.RefreshReport()
        Me.ReportViewer1.Report = myReport

I have a report that show due dates. When a due date is within a certain amount of days, I need the report to format the date in a red font. Example:

Item X due date is 2012-04-01 is with in 90 days of today (2012-03-12) so the report will need to show it in a red font
Item Y due date is 2012-08-01 is not within 90 days so the font should be black.

I tried to compare dates using   = Fields.due >=DateAdd("d", 90, now()) but I get an error has occurred while processing textbox The expression contains undefined function call DateAdd()

 

I am currently using telerik reporting, and I need to have a barcode printed.  I need to replace an existing barcode using what was told to me to be encoded with Code 128B.  An example text I need to encode is “D00100235373”
When I go to this site and select barcode type 128 and put D00100235373 in the Enter Code Text it generates the barcode exactly the way I want.  Meaning it looks exactly the same as the bar on a document I am replacing.  
http://www.dbautotrack.com/demo/WebDemoBW/Default.aspx

Though, I would love to use Telerik’s barcode control, because it is simpler to use, and I have already paid for Telerik.  
I have tried several things such as below, but I cannot seem to get the same barcode as the one from the above website.  
Symbology = Code128 and Checksum = False
Symbology = Code128 and Checksum = true
Symbology = Code128B and Checksum = False
Symbology = Code128B and Checksum = true

Any help on this would be much appreciated.
Thanks, Tommy

Hi,

Great job with the Report Designer but can you clarify licencing for it? Product documentation still lists "Products that expose the design-time functionality of the Telerik reports." as "Examples of Uses that Require Discussion", can I provide "the business" (for internal projects) with Report Designer or do they need licence for Reporting too? Same with clients (for external projects) can they use Report Designer without purchasing Telerik Reporting licence?

Regards,

Tomashiba