Questions on Reporting Forum

2 answers

233 views

Not able to load large data in cross tab report

hello,

I am using telerik cross tab report but unable to load large data. Report generation proccess is too slow or result in out of memory exception. My stored procedure come up with all records in 1 min and 14 seconds but report don't come up after many minutes, but the same report working fine for 5000 records. Please share the solution?

Thanks

General Discussions

answered on 29 Jul 2011

1 answer

137 views

Export to PDF Excessive Whitespace

I have an issue with Telerik Reporting Q3 2009 when I export a report to PDF. The report has a textbox and a table. The textbox content takes up about 1/4 of a page and the table content takes up about a full page (or more).

What I want is the for table to start immediately after the textbox but I've found that unless the entire table fits on the same page as the textbox it starts rendering on the 2nd page.

Instead of:
[page 1] Textbox + Whitespace
[page 2] Table
[page 3] Table continued

I want:
[page 1] Textbox + Table
[page 2] Table continued

I've played with KeepTogether property but it didn't make a difference. Any help is appreciated! Thanks.

General Discussions

answered on 29 Jul 2011

2 answers

832 views

DateDiff?

Hi guys,

I have two fields on a report (start date and end date) and I'd like to create a calculated field showing the number of hours. I can't find any date formatting functions such as datediff, datepart etc that would allow me to do this. Any ideas? I guess I could add a field to the sql server view but it would cause complications in another tier...

General Discussions

answered on 29 Jul 2011

1 answer

252 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

425 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

253 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

81 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

116 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

210 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

104 views

generate PDF

delete that thread , sorry ;]

General Discussions

asked on 27 Jul 2011