The following code:
Code: Select all
var report = new StiReport();
Uri url = Config.Instancia().PegarUri("../relatorio.php?rel=RelatNotas&curso=005&serie=2&turma=a&materia=007&professor=001");//return a XML
Uri urlxsd = Config.Instancia().PegarUri("../relatorios/Relatorio.xsd");
string xsd = urlxsd.ToString().Substring(0, urlxsd.ToString().IndexOf("&d="));//Return a XSD
MemoryStream streamMrt = new MemoryStream(byteArrayMrt);
report.Load(streamMrt);
StiXmlDatabase data = new StiXmlDatabase("Dados", xsd, url.ToString());
report.Dictionary.Clear();
report.Dictionary.Databases.Add(data);
report.Dispose();
if (report.IsRendered)
{
report.Render();
}
PreviewControl.Report = report;
My file is loaded by mrt download and then do the following conversion:
Code: Select all
byteArrayXsd = Encoding.UTF8.GetBytes(e.Result);The first picture is when I use report.LoadDocument () and second, when using only the report.Load (). I hope this is relevant.
more,
my XSD File
Code: Select all
Code: Select all
005
ENSINO MÉDIO 1º E 2º
A
002
2010
M
008517
ANA CAROLINA LEITE DINIZ JUNQUEIRA
BIOLOGIA
LAERT MANTOVANI JUNIOR
Code: Select all
Delta
Delta
RelatNotas
IdCurriculo,System.Int32
NomeCurriculo,System.String
AnoLetivo,System.String
EtapaAtiva,System.String
DataInicioBim,System.DateTime
DataFinalBim,System.DateTime
IdCurso,System.Int32
CursoSequencia,System.Int32
CursoCodigo,System.Int32
CursoNome,System.String
CursoNomeAbreviado,System.String
Coordenador,System.String
GradeCoordenador,System.String
CursoNomeContrato,System.String
AreaCurso,System.String
IdSerie,System.Int32
SerieSequencia,System.Int32
SerieCodigo,System.String
TituloSerie,System.String
IdTurma,System.Int32
TituloTurma,System.String
DataInicioTurma,System.DateTime
DataFimTurma,System.DateTime
Sala,System.String
Turno,System.String
TurmaDiaSemana,System.String
TurmaHorario,System.String
LaboratorioCodigo,System.String
LaboratorioNome,System.String
LaboratorioNomeAbrev,System.String
LaboratorioLimite,System.Int32
IdTurmaDep,System.Int32
IdTipoMateria,System.Int32
TurmaCodigoDep,System.String
TurmaTituloDep,System.String
AlunoIdInstituicao,System.Int32
AlunoCodigoInstituicao,System.Int32
AlunoNomeInstituicao,System.String
IdAluno,System.Int32
Sexo,System.String
Codigo,System.String
Nr,System.String
NrChamada,System.Int32
NomeAluno,System.String
EmailAluno,System.String
LoginAluno,System.String
SenhaAluno,System.String
DataNascimento,System.DateTime
RgAluno,System.String
DataMatricula,System.DateTime
DtPrimeiraMatricula,System.DateTime
DtUltimaMatricula,System.DateTime
DtUltimaMatriculaReingresso,System.DateTime
sDtUltimaMatriculaReingresso,System.String
AnoMatricula,System.String
MatriculaConfirmada,System.Boolean
IdSituacaoMatricula,System.Int32
SituacaoMatricula,System.String
SituacaoMatriculaAbrev,System.String
SituacaoAtiva,System.Boolean
DataSaida,System.DateTime
IdMateria,System.Int32
IdTiposMateria,System.Int32
Sequencia,System.Decimal
CodigoMateria,System.Int32
NomeMateria,System.String
NomeAbrevMateria,System.String
ImprimirBoletim,System.Boolean
Agrupada,System.Boolean
SubMateria,System.Boolean
AulasDadas,System.Int32
AulasPrevistas,System.Int32
TotalAulasDadas,System.Int32
TotalAulasPrev,System.Int32
CargaHorariaMateria,System.Int32
DataIniMateria,System.String
DataFimMateria,System.String
DataDossie,System.String
DataRecDossie,System.String
DataNota,System.String
DataRec1,System.String
DataRec2,System.String
IdNota,System.Int32
MediaFinal,System.String
TotalFalta,System.Int32
Frequencia,System.Decimal
IdSituacaoMateria,System.Int32
SituacaoMateria,System.String
SituacaoMateriaAbrev,System.String
SituacaoMateriaII,System.String
TipoAprovacao,System.String
TipoAprovacaoAbreviado,System.String
IdAvaliacao,System.Int32
SequenciaAvaliacao,System.Int32
NomeAvaliacao,System.String
NomeAbrevAvaliacao,System.String
DtDuracaoBimIni,System.String
DtDuracaoBimFim,System.String
Etapa,System.Boolean
TipoAvaliacao,System.Int32
Nota,System.String
Falta,System.Int32
IdProfessorMateria,System.Int32
IdProfessor,System.Int32
NomeProfessor,System.String
EscolaridadeProf,System.String
ProfessorEmail,System.String
ProfessorRG,System.String
ProfessorCPF,System.String
ProfessorRegente,System.String
ProfessorRegenteEmail,System.String
DiasLetivos,System.Int32
TotalHora,System.Int32
MateriaPrincipalCodigo,System.Int32
MateriaPrincipalNome,System.String
Coluna1,System.String
Coluna2,System.String
RelatNotas
Delta.RelatNotas
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,19.7,2.6
Transparent
0.4,0,2,1.5
DadosInstituicao.LogoEscola
Image1
False
True
Transparent
2.6,0,14.6,0.6
Times New Roman,11,Bold
0,0,0,0
Text1
{DadosInstituicao.Nome}
Black
Transparent
2.6,0.4,14.6,0.6
Times New Roman,10,Bold
0,0,0,0
Text2
{DadosInstituicao.Titulo}
Black
Center
Transparent
2.6,1,14.6,0.4
Times New Roman,10
0,0,0,0
Text3
{DadosInstituicao.Endereco} {DadosInstituicao.Numero} Fone: {DadosInstituicao.Telefone} Fax: {DadosInstituicao.Fax} CEP: {DadosInstituicao.Cep}
Black
Center
Transparent
2.6,1.4,14.6,0.4
Times New Roman,10
0,0,0,0
Text4
{DadosInstituicao.NomeCidade}
Black
Center
Transparent
2.6,1.8,14.6,0.4
Times New Roman,10
0,0,0,0
Text5
CNPJ: {DadosInstituicao.Cnpj}
Black
Center
Transparent
17.4,0,2.2,0.4
Times New Roman,8
0,0,0,0
Text6
Data: {Today.ToString("dd/MM/yyyy")}
Black
Center
Transparent
17.4,0.5,0.9,0.4
Times New Roman,8
0,0,0,0
Text7
Hora:
Black
Center
Transparent
18.2,0.5,1.4,0.4
Times New Roman,8
0,0,0,0
Text8
{Time}
Black
t
Center
Transparent
17.4,0.9,2.2,0.6
Times New Roman,8
0,0,0,0
Text9
Página: {PageNumber}
Black
Center
Black
15.2,1.8,4.4,0.6
Times New Roman,12,Bold
Center
0,0,0,0
Text10
Registro de Frequência
White
Center
PageHeaderBand1
Transparent
0,26.3,19.7,1.6
Top;Black;1;Solid;False;4;Black
Transparent
0,0.5,7.8,0.6
Times New Roman,9
Center
0,0,0,0
Text88
Professor(a) da Disciplina
Black
Center
Transparent
7.7,0.1,4,0.6
Times New Roman,9
Center
0,0,0,0
Text89
Data: _____/_____/_____
Black
Center
Top;Black;1;Solid;False;4;Black
Transparent
12,0.5,7.6,0.6
Times New Roman,9
Center
0,0,0,0
Text90
Coodemador(a) do Curso
Black
Center
PageFooterBand1
Transparent
0,3.8,19.7,2
Transparent
0.4,0,1,0.6
Times New Roman,10,Bold
0,0,0,0
Text11
Ano:
Black
Center
Transparent
0.4,0.6,1.8,0.6
Times New Roman,10,Bold
0,0,0,0
Text12
Disciplina:
Black
Center
Transparent
11.8,0,1.3,0.6
Times New Roman,10,Bold
0,0,0,0
Text13
Turno:
Black
Center
Transparent
11.8,0.6,1.2,0.6
Times New Roman,10,Bold
0,0,0,0
Text14
Prof.:
Black
Center
Transparent
16.2,0,1.4,0.6
Times New Roman,10,Bold
0,0,0,0
Text15
Turma:
Black
Center
Transparent
4.2,0,1.2,0.6
Times New Roman,10,Bold
0,0,0,0
Text16
Curso:
Black
Center
Transparent
5.4,0,6.2,0.6
Times New Roman,10
0,0,0,0
Text17
{RelatNotas.CursoCodigo} - {RelatNotas.CursoNome}
Black
Center
Transparent
17.6,0,2,0.6
Times New Roman,10
0,0,0,0
Text18
{RelatNotas.TituloTurma}
Black
Center
Transparent
2.2,0.6,9.4,0.6
Times New Roman,10
0,0,0,0
Text19
{RelatNotas.NomeMateria}
Black
Center
Transparent
13,0.6,6.7,0.6
Times New Roman,10
0,0,0,0
Text20
{RelatNotas.NomeProfessor}
Black
Center
Transparent
1.4,0,2.6,0.6
Times New Roman,10
0,0,0,0
Text21
{RelatNotas.AnoMatricula}
Black
Center
All;Black;1.5;Solid;False;4;Black
Transparent
0.4,1.2,0.5,0.8
Times New Roman,8
0,0,0,0
Text54
Nr.
Black
Bottom
All;Black;1.5;Solid;False;4;Black
Transparent
0.9,1.2,1.3,0.8
Times New Roman,8
0,0,0,0
Text55
Matrícula
Black
Bottom
All;Black;1.5;Solid;False;4;Black
Transparent
2.2,1.2,5.8,0.8
Times New Roman,8
0,0,0,0
Text56
Nome
Black
Bottom
All;Black;1.5;Solid;False;4;Black
Transparent
8,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text57
Black
All;Black;1.5;Solid;False;4;Black
Transparent
8.4,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text58
Black
All;Black;1.5;Solid;False;4;Black
Transparent
8.8,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text59
Black
All;Black;1.5;Solid;False;4;Black
Transparent
9.2,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text60
Black
All;Black;1.5;Solid;False;4;Black
Transparent
9.6,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text61
Black
All;Black;1.5;Solid;False;4;Black
Transparent
10,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text62
Black
All;Black;1.5;Solid;False;4;Black
Transparent
10.4,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text63
Black
All;Black;1.5;Solid;False;4;Black
Transparent
10.8,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text64
Black
All;Black;1.5;Solid;False;4;Black
Transparent
11.2,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text65
Black
All;Black;1.5;Solid;False;4;Black
Transparent
11.6,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text66
Black
All;Black;1.5;Solid;False;4;Black
Transparent
12,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text67
Black
All;Black;1.5;Solid;False;4;Black
Transparent
12.4,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text68
Black
All;Black;1.5;Solid;False;4;Black
Transparent
12.8,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text69
Black
All;Black;1.5;Solid;False;4;Black
Transparent
13.2,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text70
Black
All;Black;1.5;Solid;False;4;Black
Transparent
13.6,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text71
Black
All;Black;1.5;Solid;False;4;Black
Transparent
14,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text72
Black
All;Black;1.5;Solid;False;4;Black
Transparent
14.4,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text73
Black
All;Black;1.5;Solid;False;4;Black
Transparent
14.8,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text74
Black
All;Black;1.5;Solid;False;4;Black
Transparent
15.2,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text75
Black
All;Black;1.5;Solid;False;4;Black
Transparent
15.6,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text76
Black
All;Black;1.5;Solid;False;4;Black
Transparent
16,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text77
Black
All;Black;1.5;Solid;False;4;Black
Transparent
16.4,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text78
Black
All;Black;1.5;Solid;False;4;Black
Transparent
16.8,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text79
Black
All;Black;1.5;Solid;False;4;Black
Transparent
17.2,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text80
Black
All;Black;1.5;Solid;False;4;Black
Transparent
17.6,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text81
Black
All;Black;1.5;Solid;False;4;Black
Transparent
18,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text82
Black
All;Black;1.5;Solid;False;4;Black
Transparent
18.4,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text83
Black
All;Black;1.5;Solid;False;4;Black
Transparent
18.8,1.6,0.4,0.4
Times New Roman,10
0,0,0,0
Text84
Black
All;Black;1.5;Solid;False;4;Black
Transparent
19.2,1.6,0.5,0.4
Times New Roman,8
Center
0,0,0,0
Text85
T.F.
Black
Center
All;Black;1.5;Solid;False;4;Black
Transparent
8,1.2,11.7,0.4
Times New Roman,8,Bold
Center
0,0,0,0
Text86
Frequência / {Mes.Text}
Black
Center
Transparent
13,0,3,0.6
Times New Roman,10
0,0,0,0
Text87
{RelatNotas.Turno}
Black
Center
0.4,0,0,0
StartPointPrimitive1
2e2156de6bb54037a5b39ce9dc0ce621
19.7,1.2,0,0
EndPointPrimitive1
2e2156de6bb54037a5b39ce9dc0ce621
{RelatNotas.Sequencia.ToString() RelatNotas.IdMateria.ToString()}
GroupHeaderBand1
True
True
Transparent
0,6.6,19.7,0
{RelatNotas.NrChamada}
GroupHeaderBand2
Transparent
0,7.4,19.7,0
RelatNotas
DataBand1
Transparent
0,8.2,19.7,0.4
All;Black;1.5;Solid;False;4;Black
Transparent
0.4,0,0.5,0.4
Times New Roman,7
0,0,0,0
Text22
{RelatNotas.NrChamada}
Black
Center
All;Black;1.5;Solid;False;4;Black
Transparent
0.9,0,1.3,0.4
Times New Roman,7
0,0,0,0
Text23
{RelatNotas.Codigo}
Black
Center
All;Black;1.5;Solid;False;4;Black
Transparent
2.2,0,5.8,0.4
Times New Roman,7
0,0,0,0
Text24
{RelatNotas.NomeAluno}
Black
Center
All;Black;1.5;Solid;False;4;Black
Transparent
8,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text25
Black
All;Black;1.5;Solid;False;4;Black
Transparent
8.4,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text26
Black
All;Black;1.5;Solid;False;4;Black
Transparent
8.8,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text27
Black
All;Black;1.5;Solid;False;4;Black
Transparent
9.2,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text28
Black
All;Black;1.5;Solid;False;4;Black
Transparent
9.6,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text29
Black
All;Black;1.5;Solid;False;4;Black
Transparent
10,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text30
Black
All;Black;1.5;Solid;False;4;Black
Transparent
10.4,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text31
Black
All;Black;1.5;Solid;False;4;Black
Transparent
10.8,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text32
Black
All;Black;1.5;Solid;False;4;Black
Transparent
11.2,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text33
Black
All;Black;1.5;Solid;False;4;Black
Transparent
11.6,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text34
Black
All;Black;1.5;Solid;False;4;Black
Transparent
12,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text35
Black
All;Black;1.5;Solid;False;4;Black
Transparent
12.4,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text36
Black
All;Black;1.5;Solid;False;4;Black
Transparent
12.8,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text37
Black
All;Black;1.5;Solid;False;4;Black
Transparent
13.2,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text38
Black
All;Black;1.5;Solid;False;4;Black
Transparent
13.6,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text39
Black
All;Black;1.5;Solid;False;4;Black
Transparent
14,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text40
Black
All;Black;1.5;Solid;False;4;Black
Transparent
14.4,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text41
Black
All;Black;1.5;Solid;False;4;Black
Transparent
14.8,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text42
Black
All;Black;1.5;Solid;False;4;Black
Transparent
15.2,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text43
Black
All;Black;1.5;Solid;False;4;Black
Transparent
15.6,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text44
Black
All;Black;1.5;Solid;False;4;Black
Transparent
16,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text45
Black
All;Black;1.5;Solid;False;4;Black
Transparent
16.4,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text46
Black
All;Black;1.5;Solid;False;4;Black
Transparent
16.8,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text47
Black
All;Black;1.5;Solid;False;4;Black
Transparent
17.2,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text48
Black
All;Black;1.5;Solid;False;4;Black
Transparent
17.6,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text49
Black
All;Black;1.5;Solid;False;4;Black
Transparent
18,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text50
Black
All;Black;1.5;Solid;False;4;Black
Transparent
18.4,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text51
Black
All;Black;1.5;Solid;False;4;Black
Transparent
18.8,0,0.4,0.4
Times New Roman,10
0,0,0,0
Text52
Black
All;Black;1.5;Solid;False;4;Black
Transparent
19.2,0,0.5,0.4
Times New Roman,10
0,0,0,0
Text53
Black
GroupFooterBand2
Transparent
0,9.4,19.7,0
GroupFooterBand1
0.4,3.8,19.3,1.2
Black
2e2156de6bb54037a5b39ce9dc0ce621
RectanglePrimitive1
1.5
307ab853d37746c7a807a1b777cce263
0.5,0.8,0.8,1
Page1
29.7
21
Arial,100
[50:0:0:0]
Control
Control
8,16,216,24
Microsoft Sans Serif,8,Bold
Black
8, 16
LabelControl1
216, 24
ESCREVA O MÊS DE REFERÊNCIA:
MiddleLeft
Window
8,40,215,20
Microsoft Sans Serif,8
Black
8, 40
Mes
215, 20
Janeiro
16,96,72,24
True
OK
Microsoft Sans Serif,8
Black
16, 96
ButtonControl1
72, 24
OK
True
144,96,72,24
Cancel
Microsoft Sans Serif,8
Black
144, 96
ButtonControl2
72, 24
Cancelar
Microsoft Sans Serif,8
b5da5f7d6e604954a36f1e272415d52f
0, 0
Form1
240, 160
INFORMAÇÕES
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Report
3/28/2012 11:27:24 AM
7/26/2007 2:20:31 PM
C:\Projetos\ModuloProfessorWeb2\ModuloProfessor\ModulosOnlinePHP\professor\relatorios\RelatorioTemp.mrt
0d2a6764cc5f4af68039d5359e4d4e35
Report
Centimeters
2011.3.1200
using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;
namespace Reports
{
public class Report : Stimulsoft.Report.StiReport
{
public Report()
{
this.InitializeComponent();
}
#region StiReport Designer generated code - do not modify#endregion StiReport Designer generated code - do not modify
}
}
CSharp