Questions on Reporting Forum

1 answer

248 views

How to fill a subreports datasource with a list of objects?

Hi,

I need show data of three different datasources in the same report. I'm trying to use a subreport but I don´t have success.

public class ViagemInfo

{

public int IDEmpresa { get; set; }

public int AnoViagem { get; set; }

public int IDViagem { get; set; }

public int IDConta { get; set; }

public List<MotoristaViagemInfo> MotoristasViagem { get; set; }

}

public class MotoristaViagemInfo

{

public int IDMotorista { get; set; }

public int Nome { get; set; }

}

private void LoadData(int IdEmpresa, int AnoViagem, int IdViagem)

{

ViagemInfo viagemInfo;

try

{

using (PedidoProxy.Pedido svcProxy = new PedidoProxy.Pedido())

{

//load the ViagemInfo with a List<MotoristaViagemInfo>

viagemInfo = svcProxy.ObterViagemDetalhada(IdEmpresa);

}

CertificadoViagem reportCertificado = new CertificadoViagem();

reportCertificado.ReportParameters["IdEmpresa"].Value = IdEmpresa;

reportCertificado.DataSource = viagemInfo;

}

catch

{

throw;

}

How am I set a datasource of subreport with a MotoristasViagem property of viagemInfo?

General Discussions

answered on 28 Jul 2011

3 answers

414 views

Conditional Formatting for Chart?

I have a bar chart in my report, X-axis is the employee name, Y-axis is the sales amount. If sales amount over X, I would like to color the bar "Green". If they are below X, color the bar "Red". How can I do this? I tried looking at Conditional Formatting but it's not working.

Please guide me into right direction.

Thanks!

General Discussions

answered on 28 Jul 2011

5 answers

247 views

Access textbox from chart needdatasource method

Hello,

How can I access the a textbox value from chart needdatasource method?
My code:

private void Pie_NeedDataSource(object sender, EventArgs e)

{

Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;

//Telerik.Reporting.Chart defChart = (Telerik.Reporting.Chart)chart.ItemDefinition;

//Processing.TextBox textBox21 = (defChart.Items["textBox21"] as Processing.TextBox);

Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition;

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

series.Type = ChartSeriesType.Pie;

Telerik.Reporting.Charting.ChartLegend legend = new Telerik.Reporting.Charting.ChartLegend();

string CoverDescription;

int itemValue;

string commandText = string.Empty;

SqlConnection connection = new SqlConnection(global::QTaskReporting.Properties.Settings.Default.QTDbConnString);

commandText = "SELECT COUNT(*) AS ItemCount, SDesc FROM vwSubTasksAndStatuses where TaskID=" + textBox21.Value + " GROUP BY SDesc";

SqlCommand cmd = new SqlCommand(commandText, connection);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

foreach (DataRow rowView in ds.Tables[0].Rows)

{

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

//The chart Y value will be based on the Value amount

seriesItem.YValue = Convert.ToInt32(rowView["ItemCount"]);

seriesItem.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;

//The chart item label should be set to the Value amount

itemValue = Convert.ToInt32(rowView["ItemCount"]);

seriesItem.Label.TextBlock.Text = itemValue.ToString("##");

seriesItem.Label.Appearance.LabelLocation = Telerik.Reporting.Charting.Styles.StyleSeriesItemLabel.ItemLabelLocation.Inside;

seriesItem.Label.TextBlock.Appearance.TextProperties.Color = System.Drawing.Color.FromArgb(((int)(((byte)(28)))), ((int)(((byte)(58)))), ((int)(((byte)(112)))));

//Assign the chart item description

CoverDescription = rowView["SDesc"].ToString();

seriesItem.Name = CoverDescription.Trim();

//Give the "Shortfall in Cover" chart item an exploded appearance

if (seriesItem.Name == "New")

{

seriesItem.Appearance.Exploded = true;

}

series.AddItem(seriesItem);

}

//Display the legend

series.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.ItemLabels;

series.Appearance.Border.Color = System.Drawing.Color.White;

series.Appearance.Border.Visible = false;

series.Appearance.DiameterScale = .90;

series.Appearance.ExplodePercent = 10;

chartDef.Series.Clear();

chartDef.Series.Add(series);

chartDef.Legend.Appearance.Position.AlignedPosition = Telerik.Reporting.Charting.Styles.AlignedPositions.TopRight;

}

In the above code I need to use the textbox value in the sql syntax.
Both chart and textbox are placed within a table (Please view the attached screen-shot).

Please, I need your help,
It is appreciated to send me the modified code.

Regards,
Bader

General Discussions

answered on 28 Jul 2011

2 answers

78 views

Report 2009 Q3 reset reportbook page count

I have referred to the ReportBook (Q2 2011), that it can be done by

reportBook.Reports(2).PageNumberingStyle = PageNumberingStyle.ResetNumberingAndCount

My version is 2009 Q3. How can I do this?

I have mutliple reports which are added to a report book.
For instace,
Report A: total pages: 3
Report B: total pages: 2
Report C: total page: 1

I want to show like this:
Report A: page 1 of 3
Report B: page 1 of 2
Report C: page 1 of 1

ie. the report will reset the page count.

If it cannot be achieved with my version, then may I ask how to :
add "Continue" at Report A, page 1 and 2, then Total Page: 3
add "Continue" at Report B, page 1, then Total Page: 2
add "Continue" at Report C, Total Page: 1

Thanks.

General Discussions

answered on 27 Jul 2011

1 answer

110 views

Point Chart Overlap

Hello, I have a Point Chart in my report. Some points will be in the same location, or very close to eachother and the point labels overlap. Currently nothing is done about the overlap and it looks messy. Does the Telerik Chart have a solution for this? SSRS draws arrows to the points when there is overlap so all labels are readable. Does Telerik have something like this? If so, what property do I have to set in the chart (or series)?

Thanks,
Justin

General Discussions

answered on 27 Jul 2011

3 answers

206 views

Busy Indicator while waiting for print dialog

Is it possible to pop up a busy indicator while waiting for the print dialog to show up in the Silverlight Report Viewer. This is an issue with larger reports that take a while to render since users have no real indication that the application is doing anything. We get an indicator when you select one of the export options (i.e pdf export).

General Discussions

answered on 27 Jul 2011

0 answers

101 views

generate PDF

delete that thread , sorry ;]

General Discussions

asked on 27 Jul 2011

3 answers

120 views

Chart continues to set autosize

Hello,
I've created a chart dragging it from the toolboxes, I need to use totally the space it offers so, no margin, no padding, no title.... I set Elements->Plot Area->Appearance->Dimension->Auto size to false and set the margins/paddings to zero....when I close the designer then reopen it I got all the margin and padding set and also the autosize to true..... how can I set it to false?
Thanks

General Discussions

answered on 27 Jul 2011

1 answer

291 views

Telerik Report Viewer Height 100% not working

Hi,

I have got a report viewer control in one of the tab. It does not stretch to 100% height. Please remember the page sits inside Master page layout.

I have follow the link http://www.telerik.com/help/reporting/faq-web-viewer-100-percent-height.html but it does not seem to help. Attachment shows the partial view of the report being rendered with scroll bars at the right hand side.

Following is the code-snippet

<telerik:RadPageView ID="RptView" runat="server" Width="100%" Height="100%">
<table style="width: 100%; height: 100%;">
<tr>
<td>
 
</td>
</tr>
<tr>
<td>
<div id="content" style="width: 100%; height: 100%;">
<telerik:ReportViewer ID="rptViewer" runat="server" Width="100%" Height="100%" Visible="true">
</telerik:ReportViewer>
</div>
</td>
</tr>
</table>
</telerik:RadPageView>

Many thanks.

General Discussions

answered on 27 Jul 2011

1 answer

770 views

Horizontal data in tables

Hi,
I've excactly the same problem as described in another post (want to achieve horizontal data) here:

http://www.telerik.com/community/forums/reporting/telerik-reporting/vertical-data.aspx

I downloaded the sample but it doesn't work with the latest release (missing datasource, other design time errors without stakc trace...). It would be nice to have a description of how to solve an issue in addition to code samples.

Can you point me to the documentation page where this is described. I can only find the general desciption of Table/CrossTable/List items. Is it really neccessary to dig into all the complicated inner group / outer group / parent call... concepts if I just want to create a simple table? Well, I am sure the CrossTable item is an excellent component if you need such a complexity, but I am not sure that melting such a complex component with a standard table or easy list was such a smart idea.

Its always the same problem "complexity vs. easy-to-handle" controls. However, I am evaluating the telerik reporting tool for three days now and I spent a lot of time reading forum posts and documentation. Here is my conclusion:

First, the reporting framework is probably the best you can get on market today. You can generate and customize almost all types of reports with it. However, for someone which is new to this framework, it is incredibly hard to build a simple table from scratch (not using the wizzard). With regards to a future "end-user-designer" tool I don't think any end-user would be able to create a table this way.

Best regards,

Stefan

General Discussions

answered on 27 Jul 2011