Questions on Reporting Forum

3 answers

128 views

Report Chart add up values DataGroupColumn

Hi Guy,

I have a problem with the next chart inside my report.

I have the following data

Name	Year	Amount
Company A	2009	5
Company A	2009	5
Company B	2009	5
Company B	2009	5

I want two bars, one for Company A at X-axis value 2009 and Y value: 10, second is Company B with X-axis value 2009 and Y value 10.

The current situation is that I get two bars, for company A, one company B with both value: 5

How can I add up these values?

            this.chart1.DataGroupColumn = "Name";
            this.chart1.DataSource = this.sqlDataSource1;
            this.chart1.PlotArea.XAxis.AutoScale = false;
            this.chart1.PlotArea.XAxis.DataLabelsColumn = "Year";

Thank you,
Robert

General Discussions

answered on 06 May 2011

1 answer

114 views

Creating a report programatically and Details splitting.

Hi,

I create a report programatically like this:

Dim report As New myrpt

Dim adapter As New System.Data.SqlClient.SqlDataAdapter(sql, GetConnectionString())

report.DataSource = adapter

Me.ReportViewer1.Report = report

Me.ReportViewer1.RefreshReport()

Then if i set the value of a text box (in the designer) to [=Fields.Data], it will display [=Fields.Data] when I display the report instead of displaying the data from the database. The connection is correct. What do i need to do differently?

I figured out why the details were splitting.

Thanks

General Discussions

answered on 05 May 2011

1 answer

88 views

Silverlight Reporting

I’m confused about how the reporting works for Silverlight. Is the viewer the only thing available on the Silverlight side? I have data in my Silverlight application that resides on the client side, but the Telerik report seems to be created on the server side (ASP.Net). Does that mean I need to push my client data (in the form of a List, Dictionary, or

SortableCollectionView)

to the server side (probably using a WCF service) to view it in Silverlight. In other words can the Silverlight viewer look at a Silverlight report or must it always be a report created in straight ASP.Net.

General Discussions

answered on 05 May 2011

1 answer

255 views

Using Scopes

I'm trying to use Exec:
=Sum(Fields.Total)/Exec('rptName', Sum(Fields.Total))

to calculate %.

But I'm getting 0.

Order and Sample are the result of the grouping

If I use only = Exec('rptName', Sum(Fields.Total)) I'm getting 64.

Can someone help me, please...

General Discussions

answered on 05 May 2011

1 answer

171 views

Problem at setting the width of TextBox dynamically basing on the retrieving data from source

Hi

I read the post at http://www.telerik.com/help/reporting/understanding-events.html to know how to retrieve the value of the data from datasource before rendering all of the parts of the report

However, no matter what i tried to set the width of my TextBoxSeg ... the FIRST row data won't be reformatted correctly
Basically i want to display something similar to this XX-XX-XXXX-XXX-XXX . But i don't know EXACTLY how many characters for each segment. And that information only available when the data has been bounded to the textbox.
So I use the ItemDataBound event. Inside that event , I will find the length of the Data of the TextBox and set the width of the textBox corresponding to the Length.
Then i just need to move the Location of other segments correspondingly
That's the whole idea

I also attach the image of my report result to let you see the problem of rendering
this is the code

private Unit oneUnit = new Unit(100/8);

private Unit originalTextSeg1Width;

private Unit originalTextSeg2Width;

private Unit originalTextSeg3Width;

private Unit originalTextSeg4Width;

private Unit originalTextSeg5Width;

private Unit originalTextDash1X;

private Unit originalTextDash2X;

private Unit originalTextDash3X;

private Unit originalTextDash4X;

private Unit originalTextSeg2X;

private Unit originalTextSeg3X;

private Unit originalTextSeg4X;

private Unit originalTextSeg5X;

public GLIncomeStatementDT()

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

//Original Width

originalTextSeg1Width = textSeg1.Width;

originalTextSeg2Width = textSeg2.Width;

originalTextSeg3Width = textSeg3.Width;

originalTextSeg4Width = textSeg4.Width;

originalTextSeg5Width = textSeg5.Width;

//Original X location

originalTextDash1X = textDash1.Location.X;

originalTextDash2X = textDash2.Location.X;

originalTextDash3X = textDash3.Location.X;

originalTextDash4X = textDash4.Location.X;

originalTextSeg2X = textSeg2.Location.X;

originalTextSeg3X = textSeg3.Location.X;

originalTextSeg4X = textSeg4.Location.X;

originalTextSeg5X = textSeg5.Location.X;

//

textSeg1.ItemDataBound += new EventHandler(textSeg1_ItemDataBound);

textSeg2.ItemDataBound += new EventHandler(textSeg2_ItemDataBound);

textSeg3.ItemDataBound += new EventHandler(textSeg3_ItemDataBound);

textSeg4.ItemDataBound += new EventHandler(textSeg4_ItemDataBound);

textSeg5.ItemDataBound += new EventHandler(textSeg5_ItemDataBound);

this.DataSource = null;

this.NeedDataSource += new EventHandler(FilteredReport_NeedDataSource);

//

// TODO: Add any constructor code after InitializeComponent call

//

}

#region Setup Seg's Width dynamically

void textSeg5_ItemDataBound(object sender, EventArgs e)

{

Telerik.Reporting.Processing.TextBox textSeg5Position = (Telerik.Reporting.Processing.TextBox)sender;

textSeg5.Style.BackgroundColor = Color.Purple;

textSeg5.Width = originalTextSeg5Width * (textSeg5Position.Text.Length);

}

void textSeg4_ItemDataBound(object sender, EventArgs e)

{

Telerik.Reporting.Processing.TextBox textSeg4Position = (Telerik.Reporting.Processing.TextBox)sender;

textSeg4.Style.BackgroundColor = Color.Yellow;

textSeg4.Width = originalTextSeg4Width * (textSeg4Position.Text.Length);

textDash4.Location = new PointU() { X = originalTextDash4X + textSeg4.Width - oneUnit, Y = textDash4.Location.Y };

textSeg5.Location = new PointU() { X = originalTextSeg5X + textSeg4.Width - oneUnit, Y = textSeg5.Location.Y };

}

void textSeg3_ItemDataBound(object sender, EventArgs e)

{

Telerik.Reporting.Processing.TextBox textSeg3Position = (Telerik.Reporting.Processing.TextBox)sender;

textSeg3.Style.BackgroundColor = Color.Green;

textSeg3.Width = originalTextSeg3Width * (textSeg3Position.Text.Length);

textDash3.Location = new PointU() { X = originalTextDash3X + textSeg3.Width - oneUnit, Y = textDash3.Location.Y };

textSeg4.Location = new PointU() { X = originalTextSeg4X + textSeg3.Width - oneUnit, Y = textSeg4.Location.Y };

textDash4.Location = new PointU() { X = originalTextDash4X + textSeg3.Width - oneUnit, Y = textDash4.Location.Y };

textSeg5.Location = new PointU() { X = originalTextSeg5X + textSeg3.Width - oneUnit, Y = textSeg5.Location.Y };

}

void textSeg2_ItemDataBound(object sender, EventArgs e)

{

Telerik.Reporting.Processing.TextBox textSeg2Position = (Telerik.Reporting.Processing.TextBox)sender;

textSeg2.Style.BackgroundColor = Color.Blue;

textSeg2.Width = originalTextSeg2Width * (textSeg2Position.Text.Length);

textDash2.Location = new PointU() { X = originalTextDash2X + textSeg2.Width - oneUnit, Y = textDash2.Location.Y };

textSeg3.Location = new PointU() { X = originalTextSeg3X + textSeg2.Width - oneUnit, Y = textSeg3.Location.Y };

textDash3.Location = new PointU() { X = originalTextDash3X + textSeg2.Width - oneUnit, Y = textDash3.Location.Y };

textSeg4.Location = new PointU() { X = originalTextSeg4X + textSeg2.Width - oneUnit, Y = textSeg4.Location.Y };

textDash4.Location = new PointU() { X = originalTextDash4X + textSeg2.Width - oneUnit, Y = textDash4.Location.Y };

textSeg5.Location = new PointU() { X = originalTextSeg5X + textSeg2.Width - oneUnit, Y = textSeg5.Location.Y };

}

void textSeg1_ItemDataBound(object sender, EventArgs e)

{

Telerik.Reporting.Processing.TextBox textSeg1Position = (Telerik.Reporting.Processing.TextBox)sender;

textSeg1.Style.BackgroundColor = Color.Red;

textSeg1.Width = originalTextSeg1Width * (textSeg1Position.Text.Length);

textDash1.Location = new PointU() { X = originalTextDash1X + textSeg1.Width - oneUnit, Y = textDash1.Location.Y };

textSeg2.Location = new PointU() { X = originalTextSeg2X + textSeg1.Width - oneUnit, Y = textSeg2.Location.Y };

textDash2.Location = new PointU() { X = originalTextDash2X + textSeg1.Width - oneUnit, Y = textDash2.Location.Y };

textSeg3.Location = new PointU() { X = originalTextSeg3X + textSeg1.Width - oneUnit, Y = textSeg3.Location.Y };

textDash3.Location = new PointU() { X = originalTextDash3X + textSeg1.Width - oneUnit, Y = textDash3.Location.Y };

textSeg4.Location = new PointU() { X = originalTextSeg4X + textSeg1.Width - oneUnit, Y = textSeg4.Location.Y };

textDash4.Location = new PointU() { X = originalTextDash4X + textSeg1.Width - oneUnit, Y = textDash4.Location.Y };

textSeg5.Location = new PointU() { X = originalTextSeg5X + textSeg1.Width - oneUnit, Y = textSeg5.Location.Y };

}

General Discussions

answered on 04 May 2011

4 answers

119 views

Is it possible to dsitribute report file

Hi
I'm new to telerel reporting. I know telerik reports are created as .cs file and compiled with my web applications. I would like to know if it is possible for me to create a report in some format so that I can distribute this report to users later and they can use their current web application to run the report without re-compiling the whole thing. Can this be done with telerik reporting?
Thanks
Edwin

General Discussions

answered on 04 May 2011

1 answer

129 views

Master-detail crosstab

Hello, I'm trying to do a master-detail kind of report. I have tried to put my data in a crosstab, but the detail cell only shows me the first entry for every group, instead of showing a list of entries.

I am trying to do some kind of schedule, having a row grouping on the resources and a column group on the date. Since a resource can do multiple jobs in a day, in the detail cell I would like to show a list of those jobs.

For example:
Data:
Entry1: Resource1 Day1 Activity1
Entry2: Resource1 Day2 DayOff
Entry3: Resource1 Day1 Activity2
Entry4: Resource2 Day1 Activity1
Entry5: Resource2 Day2 Activity2

Output:
Day1 Day2
Resource1 Activity1 DayOff
Activity2
Resource2 Activity1 Activity2

I have tried multiple things, but none did exactly what I need:
- Create a child Detail row group on the resource group, but that doesn't work because it puts me every activity as a unique entry, like this:
Day1 Day2
Resource1 Activity1
Activity2
DayOff
Resource2 Activity1
Activity2

- Put a table or list in my detail cell, but I am not able to bind its data source to its parent's grouped data (ex. for Resource1, Day1).

Has anybody ever tried to do such report?
Can you help me?

Thanks

General Discussions

answered on 04 May 2011

1 answer

678 views

How to generate a bulleted list in a Telerik report

Hi,

I am looking for a way to create a bulleted list from a SQL data source on a Telerik report. When the report is exported to Word, the bulleted list will behave similarly as the bulleted list in Word.

Thank you very much for your help and support. It is much appreciated.

Guangxi Wu
gwu@critigen.com

General Discussions

answered on 04 May 2011

3 answers

141 views

Hide panel by number of rows

There is a Table which is hosted in a panel. I want to hide the panel when the table is empty. I can add a parameter to pass the number of rows at runtime and add rule to hide the panel. Just wondering is there a better way to do it.

Best Regards

General Discussions