Group data from different databand.

[Danilo Grasso]

Hello everyone, I'm a volunteer with Volunteer Ambulance Service, I have to do a report but I have difficulty.
I m in this situation: I have to add the values ​​of a DataBand1.COL1, sum the values ​​in a column and group them together according DataBand2.COL1 DataBand1.COL2. is it possible?
I tried to nest GroupHeaderBand but does not work, does anyone have a suggestion?
Thank you all for your help.
Danilo

[Alex K.]

Hello,

Can you please send us your report with test data for analysis.

Thank you.

[Danilo Grasso]

thanks for the answer. The reports are the following, the field contains NotePerpetue.Valore grouping of data to be added to UTIF.CODICEMEZZO. Thank you for your help.

REPORT ------------------>

StampaUtifMese.MRT








UTIF

ANNO,System.Int32
MESE,System.Int32
CODICEMEZZO,System.Int32
MARCA,System.String
CODICE,System.Int32
KILOMETRI,System.Int32
KMPARTENZA,System.Int32
KMARRIVO,System.Int32
UTIF,System.Boolean
TARGA,System.String
TIPO,System.String


UTIF
NewDataSet.UTIF


PARAMETRI

DADATA,System.DateTime
ADATA,System.DateTime
MESE,System.String
DaData,System.DateTime
aData,System.DateTime


PARAMETRI
NewDataSet.PARAMETRI


AZIENDA

Codice,System.Int32
Nominativo,System.String
Indirizzo,System.String
DataNascita,System.DateTime
CodiceFiscale,System.String
PartitaIva,System.String
Sesso,System.Int32
Telefono,System.String
TelefonoUfficio,System.String
TelefonoCellulare,System.String
TelefonoAbitazione,System.String
TelefonoAlternativo,System.String
NInterno,System.String
Fax,System.String
CercaPersone,System.String
EMail,System.String
SitoWeb,System.String
Carica,System.Int32
RepartoCommerciale,System.Int32
TipoContatto,System.Int32
Frequenza,System.Int32
InvioMateriale,System.Boolean
Trattamento,System.Boolean
Attivo,System.Boolean
Notes,System.String
Presentato,System.Int32
Fatturato,System.Double
PersonaRiferimento,System.String
DataPrimoContatto,System.DateTime
DataProssimoContatto,System.DateTime
DaContattare,System.Boolean
Raggruppamento,System.Int32
Provvigione,System.Decimal
NumeroSolleciti,System.Int32
NumeroInsoluti,System.Int32
ImportoInsoluti,System.Decimal
Valuta,System.Int32
IntraCEE,System.Boolean
Professione,System.String
DataAcquisizione,System.DateTime
Attivita,System.Int32
Attivita2,System.Int32
NoteMarketing,System.String
Comune,System.Int32
Banca,System.String
CondPag,System.String
Resa,System.String
LuogoResa,System.String
Porto,System.String
Spedizione,System.Int32
Vettore,System.Int32
CodIva,System.String
FormatRagSoc,System.String
FormatIndirizzo,System.String
NoteQualita,System.String
Logo,System.Byte[]
Magazzino,System.String
Sezionario,System.Int32
Magazzino2,System.String
CodiceEnte,System.Int32
CodiceAzienda,System.Int32
MaxKm,System.Int32
ABICODE,System.Int32
CABCODE,System.Int32
DESCRIZIONEBANCA,System.String
CONTOCORRENTE,System.String
DESCRIZIONECOMUNE,System.String
CAPCOMUNE,System.String
NAZIONECOMUNE,System.String


AZIENDA
NewDataSet.AZIENDA


Mezzi

Codice,System.Int32
Tipo,System.String
Marca,System.String
Attivo,System.Boolean
Notes,System.String
Cilindrata,System.String
Potenza,System.String
Combustibile,System.Int32
UTIF,System.Boolean
AnnoImmatricolazione,System.Int32
Targa,System.String
TipoAmbulanza,System.Int32
SiglaRadio,System.String
UltimaRevisione,System.DateTime
ContaChilometri,System.Decimal
UltimaUscita,System.Decimal
TIPOAMBULANZADESCRIZIONE,System.String
TIPOBENZINADESCRIZIONE,System.String


Mezzi
NewDataSet.Mezzi


NOTEPERPETUE

Maschera,System.String
Chiave,System.Int32
Progressivo,System.Int64
Evento,System.Int32
Descrizione,System.String
DaData,System.DateTime
AData,System.DateTime
Rinnovo,System.DateTime
Colore,System.String
KM,System.Int32
NotePerpetue,System.Int32
ChiaveNumerica,System.Int32
Valore,System.Decimal


NOTEPERPETUE
NewDataSet.NOTEPERPETUE




UtifMezzi

CODICEMEZZO



UtifMezzi
UtifMezzi

Codice




UtifNote

CODICEMEZZO



UtifNote
UtifNote

Chiave




UTIF

ChiaveNumerica



UTIF
Relazione

CODICEMEZZO







EngineV1




None;Black;2;Solid;False;4;Black
Transparent


Transparent
0,0.4,27.7,2.4


Transparent
0,0,4.8,1

Arial,8,Bold
Center
0,0,0,0
Testo34


CROCE VERDE GENOVA
SESTRI PONENTE
Black
Expression


Transparent
16.6,0,8.8,0.4

Arial,8,Bold
Right
0,0,0,0
Testo35


CONTEGGIO CHILOMETRI PER UTIF

Black
Expression


Transparent
25.4,0,2.2,0.4

Arial,8,Bold
Right
0,0,0,0
Testo36


Pag.{PageNumber}

Black
Expression


All;Black;1;Solid;False;4;Black
Gainsboro
0,1.2,1.6,1.2

Arial,8,Bold
Center
0,0,0,0
Testo5


Numero
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
1.6,1.2,3.4,1.2

Arial,8,Bold
Center
0,0,0,0
Testo16


Marca
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
5,1.2,3.4,1.2

Arial,8,Bold
Center
0,0,0,0
Testo32


Modello
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
8.4,1.2,2.2,1.2

Arial,8,Bold
Center
0,0,0,0
Testo33


Targa
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
10.6,1.2,6.8,0.6

Arial,8,Bold
Center
0,0,0,0
Testo25


Chilometri
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
10.6,1.8,2.2,0.6

Arial,8,Bold
Center
0,0,0,0
Testo26


di Partenza
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
12.8,1.8,2,0.6

Arial,8,Bold
Center
0,0,0,0
Testo27


di Arrivo
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
14.8,1.8,2.6,0.6

Arial,8,Bold
Center
0,0,0,0
Testo28


percorsi
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
17.4,1.2,5,0.6

Arial,8,Bold
Center
0,0,0,0
Testo19


Ammessi Utif
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
17.4,1.8,2.6,0.6

Arial,8,Bold
Center
0,0,0,0
Testo21


chilometri
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
20,1.8,2.4,0.6

Arial,8,Bold
Center
0,0,0,0
Testo22


viaggi
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
22.4,1.2,5.2,0.6

Arial,8,Bold
Center
0,0,0,0
Testo6


Non Ammessi Utif
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
22.4,1.8,2.8,0.6

Arial,8,Bold
Center
0,0,0,0
Testo17


chilometri
Black
Expression
Center


All;Black;1;Solid;False;4;Black
Gainsboro
25.2,1.8,2.4,0.6

Arial,8,Bold
Center
0,0,0,0
Testo18


viaggi
Black
Expression
Center


Transparent
25.4,0.8,2.2,0.4

Arial,8
a067af40fe444a4fa988849222a5f217
Right
0,0,0,0
Text2


{PARAMETRI.ADATA}
Black

dd/MM/yyyy

Expression


Transparent
23.4,0.4,2,0.4

Arial,8,Bold
63c8bef8f1f44b879dc199cc933bc8af
Right
0,0,0,0
Text3


Dal
Black

Expression


Transparent
23.4,0.8,2,0.4

Arial,8,Bold
4f08f11871e14c29981d43d46262be67
Right
0,0,0,0
Text4


al
Black

Expression


Transparent
25.4,0.4,2.2,0.4

Arial,12
0,0,0,0
Testo49


{PARAMETRI.DADATA}
Black
Expression



TitoloReport1




All;Black;1;Solid;False;4;Black
Transparent
0,3.6,27.7,0

{UTIF.CODICEMEZZO}

IntestazioneGruppo1




Transparent

True
0,4.4,27.7,0.6


All;Black;1;Solid;False;4;Black
Transparent
17.4,0,1.6,0.6

Arial,11
0,0,0,0
Testo8


{UTIF.UTIF}
Black


All;Black;1;Solid;False;4;Black
Transparent
16.2,0,1.2,0.6

Arial,11
0,0,0,0
Testo9


UTIF
Black


All;Black;1;Solid;False;4;Black
Transparent
1.6,0,4.6,0.6

Arial,11
0,0,0,0
Testo3


{UTIF.MARCA}
Black


All;Black;1;Solid;False;4;Black
Transparent
0,0,1.6,0.6

Arial,11
0,0,0,0
Testo10


MARCA
Black


All;Black;1;Solid;False;4;Black
Transparent
13.2,0,1.6,0.6

Arial,11
0,0,0,0
Testo11


{UTIF.KILOMETRI}
Black


All;Black;1;Solid;False;4;Black
Transparent
10.8,0,2.4,0.6

Arial,11
0,0,0,0
Testo12


KILOMETRI
Black


All;Black;1;Solid;False;4;Black
Transparent
7.8,0,1.6,0.6

Arial,11
0,0,0,0
Testo13


{UTIF.MESE}
Black


All;Black;1;Solid;False;4;Black
Transparent
6.4,0,1.4,0.6

Arial,11
0,0,0,0
Testo14


MESE
Black




UTIF
False

UTIF,EqualTo,true,,Boolean

DatiUTIF





Transparent
0,5.8,27.7,0.4


All;Black;1;Solid;False;4;Black
Transparent
1.6,0,3.4,0.4

Arial,7,Bold
0,0,0,0
Testo1


{UTIF.MARCA}
Black

,
.
1



All;Black;1;Solid;False;4;Black
Transparent
22.4,0,2.8,0.4

Arial,7,Bold
Right
0,0,0,0
Testo7


{SumIf(DatiUTIF,UTIF.KILOMETRI,UTIF.UTIF == false)}
Black

0
,
.
1
False

Totals


All;Black;1;Solid;False;4;Black
Transparent
0,0,1.6,0.4

Arial,7
0,0,0,0
Testo15


{UTIF.CODICEMEZZO}
Black


All;Black;1;Solid;False;4;Black
Transparent
25.2,0,2.4,0.4

Arial,7,Bold
Right
0,0,0,0
Testo20


{CountIf(DatiUTIF,UTIF.UTIF == false)}
Black

0
,
.
1
False

Totals


All;Black;1;Solid;False;4;Black
Transparent
20,0,2.4,0.4

Arial,7,Bold
Right
0,0,0,0
Testo23


{CountIf(DatiUTIF,UTIF.UTIF == true)}
Black

0
,
.
1
False

Expression


All;Black;1;Solid;False;4;Black
Transparent
17.4,0,2.6,0.4

Arial,7,Bold
Right
0,0,0,0
Testo24


{SumIf(DatiUTIF,UTIF.KILOMETRI,UTIF.UTIF == true)}
Black

0
,
.
1
False

Expression


All;Black;1;Solid;False;4;Black
Transparent
10.6,0,2.2,0.4

Arial,7,Bold
Right
0,0,0,0
Testo2


{Min(DatiUTIF,UTIF.KMPARTENZA)}
Black

0
,
.
1
False

Expression


All;Black;1;Solid;False;4;Black
Transparent
12.8,0,2,0.4

Arial,7,Bold
Right
0,0,0,0
Testo4


{Max(DatiUTIF,UTIF.KMARRIVO)}
Black

0
,
.
1
False

Expression


All;Black;1;Solid;False;4;Black
Transparent
14.8,0,2.6,0.4

Arial,7,Bold
Right
0,0,0,0
Testo29


{Max(DatiUTIF,UTIF.KMARRIVO) - Min(DatiUTIF,UTIF.KMPARTENZA)}
Black

0
,
.
1
False

Expression


All;Black;1;Solid;False;4;Black
Transparent
5,0,3.4,0.4

Arial,7
0,0,0,0
Testo30


{UTIF.TIPO}
Black


All;Black;1;Solid;False;4;Black
Transparent
8.4,0,2.2,0.4

Arial,7
0,0,0,0
Testo31


{UTIF.TARGA}
Black



PièPaginaGruppo1




Transparent
0,7,27.7,0.4


All;Black;1;Solid;False;4;Black
Transparent
20,0,2.4,0.4

Arial,8,Bold
Right
0,0,0,0
Testo37


{CountIf(DatiUTIF,UTIF.UTIF == true)}
Black

0
,
.
1
False

Totals


All;Black;1;Solid;False;4;Black
Transparent
25.2,0,2.4,0.4

Arial,8,Bold
Right
0,0,0,0
Testo38


{CountIf(DatiUTIF,UTIF.UTIF == false)}
Black

0
,
.
1
False

Totals


All;Black;1;Solid;False;4;Black
Transparent
17.4,0,2.6,0.4

Arial,8,Bold
Right
0,0,0,0
Testo39


{SumIf(DatiUTIF,UTIF.KILOMETRI,UTIF.UTIF == true)}
Black

0
,
.
1
False

Totals


All;Black;1;Solid;False;4;Black
Transparent
22.4,0,2.8,0.4

Arial,8,Bold
Right
0,0,0,0
Testo40


{SumIf(DatiUTIF,UTIF.KILOMETRI,UTIF.UTIF == false)}
Black

0
,
.
1
False

Totals



PièPaginaBanda1





f1a8f8cb80424544a53e5019e3c2f611
1,1,1,1
Page1
Landscape
21
29.7


Arial,100
[50:0:0:0]



None;Black;2;Solid;False;4;Black
Transparent


Transparent
0,0.4,20,3


Transparent
0,0,9,0.6

Arial,12
Center
0,0,0,0
Testo42


{AZIENDA.Nominativo}
Black
Center


Transparent
0,0.6,9,0.6

Arial,12
Center
0,0,0,0
Testo48


{AZIENDA.Indirizzo}
Black
Center


Transparent
0,1.2,9,0.6

Arial,12
Center
0,0,0,0
Testo41


{AZIENDA.CodiceFiscale}
Black
Center



Intestazione1




Transparent
0,4.2,20,2.6


White
True
0,0,20,2.6

Arial,10
0,0,0,0
Text11


- che la P.A. è proprietaria dell'autoambulanza marca {UTIF.MARCA} mod. {UTIF.TIPO} cilindrata targa {UTIF.TARGA} alimentata a {UTIF.UtifMezzi.TIPOBENZINADESCRIZIONE}
- che tale automezzo nel 1° trimestre 2012 ha percorso in totale km {Max(DataUTIF,UTIF.KMARRIVO) - Min(DataUTIF,UTIF.KMPARTENZA)} lettura iniziale del contachilometri {Min(DataUTIF,UTIF.KMPARTENZA)} lettura finale {Max(DataUTIF,UTIF.KMARRIVO)} di cui km {SumIf(NOTEPERPETUE.UTIF.KILOMETRI,NOTEPERPETUE.UTIF.UTIF == true)} per viaggi di trasporto ammalati e feriti con un consumo di litri {Sum(NOTEPERPETUE.Valore)} di {Mezzi.TIPOBENZINADESCRIZIONE} e km {SumIf(DataUTIF,UTIF.KILOMETRI,UTIF.UTIF==false)} per percorrenza non aventi diritto di agevolazione;
- che nello stesso trimestre sono stati effettuati sull'ambulanza rifornimenti per complessivi {Format("{0:N0}", Sum(DataNOTEPERPETUE,NOTEPERPETUE.Valore))} litri di carburante.


Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Expression


{UTIF.CODICEMEZZO}

GroupHeaderBand1


True


Transparent

True
0,7.6,20,0.8


Transparent
True
0,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_ANNO


{UTIF.ANNO}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
1.8,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_MESE


{UTIF.MESE}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
3.6,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_CODICEMEZZO


{UTIF.CODICEMEZZO}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
5.4,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_MARCA


{UTIF.MARCA}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
7.2,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_CODICE


{UTIF.CODICE}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
9,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_KILOMETRI


{UTIF.KILOMETRI}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
10.8,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_KMPARTENZA


{UTIF.KMPARTENZA}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
12.6,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_KMARRIVO


{UTIF.KMARRIVO}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
{UTIF.UTIF}
14.4,0,1.8,0.8

Black
DataUTIF_UTIF


Black


Transparent
True
16.2,0,1.8,0.8

Arial,8
0,0,0,0
DataUTIF_TARGA


{UTIF.TARGA}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
18,0,2,0.8

Arial,8
0,0,0,0
DataUTIF_TIPO


{UTIF.TIPO}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center




UTIF
False

CODICEMEZZO,GreaterThan,_x0030_,,Numeric

DataUTIF



ASC
CODICEMEZZO



Transparent

True
0,9.2,20,0.8


Transparent
True
0,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Maschera


{NOTEPERPETUE.Maschera}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
1.6,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Chiave


{NOTEPERPETUE.Chiave}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
3.2,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Progressivo


{NOTEPERPETUE.Progressivo}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
4.8,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Evento


{NOTEPERPETUE.Evento}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
6.4,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Descrizione


{NOTEPERPETUE.Descrizione}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
8,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_DaData


{NOTEPERPETUE.DaData}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
9.6,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_AData


{NOTEPERPETUE.AData}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
11.2,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Rinnovo


{NOTEPERPETUE.Rinnovo}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
12.8,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Colore


{NOTEPERPETUE.Colore}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
14.4,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_KM


{NOTEPERPETUE.KM}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
16,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_NotePerpetue


{NOTEPERPETUE.NotePerpetue}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
17.6,0,1.6,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_ChiaveNumerica


{NOTEPERPETUE.ChiaveNumerica}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center


Transparent
True
19.2,0,0.8,0.8

Arial,8
0,0,0,0
DataNOTEPERPETUE_Valore


{NOTEPERPETUE.Valore}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center



Relazione
NOTEPERPETUE
False

DataNOTEPERPETUE





Transparent
0,10.8,20,0


GroupFooterBand1





b95a1146f6584e88aa5a47393075d873
0.5,0.5,0.5,0.5
Page2
29.7
21
A4


Arial,100
[50:0:0:0]





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
6/7/2012 10:26:16 AM
10/9/2006 1:42:23 PM
D:\SORGENTI\PROGETTINET\RONDINE\BIN\DEBUG\REPORT\StampaUtifMese.MRT
c0f2b2eb5c3e444685fe1b00df646237
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.ReportControls;
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

[Alex K.]

Hello,

Could you please explain your issue in more details?
Also please send us a test data for your report.

Thank you.

[Danilo Grasso]

Thanks for the reply.
Unfortunately I do not know how to send a data file because the report is supported to a sql server 2008 db, I can send a. Bak directly to the database.
I'll try to explain.
We have these tables: NotePerpetue, UTIF. MEZZI.
The datri are calculated as follows:
UTIF: contains the trips that were made ​​by the MEZZI.
MEZZI: contains the list of resources.
NotePerpetue: contains data relating to supplies made ​​by the MEZZI.
The report should present me all the means in separate pages, each State shall submit the counts of travel and supplies made ​​for that medium.
I came to do the first two phases of the report but when I add the supplies I get a strange thing, and as if the value is added in NotePerpetue.Valore many times as the number of trips made​​.
For example: If two supplies are from 1000 instead of 2000 I wrote to present, if there were 500 trips, 500000, which is a valroe wrong.
Sorry for bad English.
I'm at a dead end, I would not change because I think that this product is really the most extensible report generator, but I have to do this report for taxes.
Thank you all for your help.

[Alex K.]

Hello,

It is difficult to say something without test data for report.

Thank you.

[Danilo Grasso]

Thanks for the reply.
I managed to attach the XML schema files, please explain how I can also export the data into xml?
Thanks for the help.

[Alex K.]

Hello,

You can try to get data from the sql server with help the export tools in any format (xml, access, excel).
We will try to use it.

Thank you.

[Danilo Grasso]

Hello everyone, I did the export of data to xml, I hope that works. I'm really stuck, I did more tests, I attach a new version of the report that I prepared last night. Thanks for the help

[Alex K.]

Hello,

We could not connect data from this .xml file.
Please try to export data in another format.

Thank you.