Questions on Reporting Forum

1 answer

109 views

How can i get the field from the dataset?

hello, i'm a newbie for telerik..
i get the task which i need to get the field from dataset to put in my telerik report but i dont know how to do that. i tried to bind the dataset but still didnt work. can somebody help me? thanks..

General Discussions

answered on 27 Sep 2011

3 answers

221 views

Accessing Datasource.SelectComand via Report Viewer code

I have a series of reports that depend on a variety of differing SQL queries. They vary by joins and several other criteria, so simple parameter substitution is not an option. I need to set the SQL Select Command at the time the report is initiated on the ASPX page that contains the Report Viewer.

In another thread, I have found out how to access certain report variables using the following technique:

Dim report As Telerik.Reporting.Report = DirectCast(Me.ReportViewer1.Report, Telerik.Reporting.Report)

Dim txt As Telerik.Reporting.TextBox = TryCast(report.Items.Find("titleTextBox", True)(0), Telerik.Reporting.TextBox)

txt.Value = "

Updated Title Text"

How would I do the equivalent for the Datasource name, connection string or select command?

I need a clue as to the syntax and form, as the above "find" for a text control doesn't seem to apply.

General Discussions

answered on 27 Sep 2011

6 answers

411 views

Telerik reporting with class library vs web application

I have an existing .NET web application and currently working on implementing Telerik reports in it. Is it better to create reports in the same web application or to create a reports class library and then call them from the application? What are the pros and cons for each approach?

General Discussions

answered on 27 Sep 2011

4 answers

388 views

page height of report with table of dynamic content

I have laid out a table with the bottom row being empty. On the table_DataBound method, I am inserting text into that field. That field could be 50-100 lines of text. I am trying to align the report such that every item in the datasource (bound to my table) is on its own page (ie each processed table is on its own page).

I have attached some png's of the current output (each page of the resulting pdf).

Any help would be appreciated.

General Discussions

answered on 26 Sep 2011

2 answers

116 views

How to Get Multiple Report Catalogs

Hi all,
I need some inspiration to create a report catalog that would contain multiple catalogs, sort of a Report Book of Catalogs.
For ex: Catalog A is for Sales would contain 3 distinct reports, B is for Billing would contain 5 reports, C is for Receivables....
Any suggestions would be appreciated.

Jack

General Discussions

answered on 26 Sep 2011

0 answers

119 views

Master-detail report problem

Hi, guys I'm trying to create a master detail report like invoice report and I'm getting the next error mesagge when I try to set de subreport reportsource. "Constructor on type 'Reportes.CriterioReporte' not found". The main report is named "RepConcentrado" and the two reports that will be master and detail are named 'CriterioReporte' wich has 3 parameters(string status, DateTime date1,DateTime date2) and "reoTotales which has (int CountryId,DateTime date1, DateTime date2).

I followed the subreport video from telerik tv but in At the moment I try to set the report datasource the message comes out.
Here's the code for each report

using System;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

using ModeloSolicitudesGuarderias;

using System.Linq;

namespace Reportes

{

/// <summary>

/// Summary description for CriterioReporte.

/// </summary>

public partial class CriterioReporte : Telerik.Reporting.Report

{

short claveEdo, claveCd;

public CriterioReporte(string Estatus,DateTime fecha,DateTime fecha2)

{

InitializeComponent();

////

var bdsseguaReporte = new BD_SSEGUAEntities();

Report.DataSource = from m in bdsseguaReporte.Menores

where (m.Solicitud.CTEdoSolicitud.fcDescEdoSol == Estatus && (m.fdFchRegMenor>=fecha &&m.fdFchRegMenor<= fecha2 ))

select m;

textBox25.Value = "Periodo: del" +" "+ fecha.ToShortDateString() +" "+ "al" +" "+ fecha2.ToShortDateString();

textBox24.Value = "Fecha:"+" "+DateTime.Now.ToShortDateString();

textBox31.Value = "Registradas/En Lista de Espera";

// TODO: Add any constructor code after InitializeComponent call

//

}

private void textBox8_ItemDataBound(object sender, EventArgs e)

{

claveEdo = Convert.ToInt16((sender as Telerik.Reporting.Processing.TextBox).Value);

var bdinstContext = new BD_INSTEntities();

var estado = (from edo in bdinstContext.Cat_Edo

where edo.cve_edo == claveEdo

select edo).First();

(sender as Telerik.Reporting.Processing.TextBox).Value = estado.nom_edo;

}

private void textBox9_ItemDataBound(object sender, EventArgs e)

{

claveCd = Convert.ToInt16((sender as Telerik.Reporting.Processing.TextBox).Value);

var bdinstContext = new BD_INSTEntities();

var ciudad = (from cd in bdinstContext.Cat_cd

where (cd.cve_cd == claveCd) && (cd.cve_edo == claveEdo)

select cd).First();

(sender as Telerik.Reporting.Processing.TextBox).Value = ciudad.nom_cd;

}

This part willbe the master section
And this the detail section

namespace Reportes

{

using System;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

using System.Linq;

using ModeloSolicitudesGuarderias;

/// <summary>

/// Summary description for ReoTotales.

/// </summary>

public partial class ReoTotales : Telerik.Reporting.Report

{

public ReoTotales(int Circuito,DateTime fecha,DateTime fecha2)

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

////

var bdsseguaReporte = new BD_SSEGUAEntities();

Report.DataSource = from m in bdsseguaReporte.Menores

where (m.Solicitud.CTEdoSolicitud.fcDescEdoSol == "Registrada" && (m.fdFchRegMenor>=fecha &&m.fdFchRegMenor<= fecha2 )&& m.Solicitud.fiCircuito==Circuito)

select m;

textBox13.Value = "Solicitudes recibidas durante el periodo"+" "+"del" +" "+ fecha.Date.ToShortDateString() + "al" +" "+ fecha2.Date.ToShortDateString();

//table1.DataSource = Report.DataSource;

//table1.Visible = true;

//

// TODO: Add any constructor code after InitializeComponent call

//

}

Hope you could help.

General Discussions

asked on 26 Sep 2011

1 answer

87 views

same exact code on 2 different sites

One website the reports show up perfectly; however, on another website (because we have clients on the other side of the world so we have 2 sites with same exact code) i get the error "one or more parameters are not set or have invalid values".

I have compared the web.config files and they are the same also, except for sql server names based on which website it is...no cross domain stuff going on.

So why would this happen? Are there configuration issues that the website host needs to resolve or????

Other data displays work great it is just when I try to display a report.

Thanks,
Richard

General Discussions

answered on 26 Sep 2011

1 answer

124 views

Worksheet

Hi, telerik team.

i'm exploring the telerik reporting features and I have the follow doubt:
The scenario:I have a reporting with grouping items and separated by section.
I will like that, to the export, the items grouped should be placed in a separated worksheet, in excell, and separated pages in PDF files.

Kind regards,
Giuliano.

General Discussions