How do I set the data type of the fields of XML data file?
Or how I convert string to decimal to sum function wokrs?
Code: Select all
{Sum(data.field)}Thank you!
Data type fields / Sum function
Data type fields / Sum function
Hello again!!
How do I set the data type of the fields of XML data file?
Or how I convert string to decimal to sum function wokrs?
This code is concatenating decimal value!
Thank you!
How do I set the data type of the fields of XML data file?
Or how I convert string to decimal to sum function wokrs?
Thank you!
Data type fields / Sum function
Hello,
You can specify the column type in the data source editor:
Thank you.
You can specify the column type in the data source editor:
Thank you.
- Attachments
-
- 745.ds.png (23.66 KiB) Viewed 6325 times
Data type fields / Sum function
Hello
Changing data type by data source editor do not works.
It stills concatenating like strings.
We changed the way of registering data to the report. Now we are using dataTables, specifying data type on dataTable.
Although the designer's data source editor stills showing data type as string, the sum function is working!
Thank you.
Changing data type by data source editor do not works.
It stills concatenating like strings.
We changed the way of registering data to the report. Now we are using dataTables, specifying data type on dataTable.
Although the designer's data source editor stills showing data type as string, the sum function is working!
Thank you.
Data type fields / Sum function
Hello,
Could you give us an example of a code to see how do you register XML data? We will recheck the algorithms, because the columns type specified in the data dictionary should be applied.
Thank you.
Could you give us an example of a code to see how do you register XML data? We will recheck the algorithms, because the columns type specified in the data dictionary should be applied.
Thank you.
Data type fields / Sum function
Here it goes
Report
Data
Thank you.
Report
Code: Select all
dados
numero,System.String
dataEmissao,System.String
dataEntrega,System.String
corteNumero,System.String
corteTipo,System.String
corteTipoSequencial,System.String
corteParado,System.String
rolNumero,System.String
lote,System.String
loteDataEntrega,System.String
observacao,System.String
tipoTransferencia,System.String
colecao,System.String
celulaDestino,System.String
celulaOrigem,System.String
empresa,System.String
tabelaPrecoOrigem,System.String
tabelaPrecoDestino,System.String
empresaOrigem,System.String
empresaDestino,System.String
depositoOrigem,System.String
depositoDestino,System.String
logUsuario,System.String
logData,System.String
logHora,System.String
detTipo,System.String
detQuantidade,System.String
detValorOrigem,System.String
detValorDestino,System.String
detReduzido,System.String
detParte,System.String
detPadrao,System.String
dados
dados.dados
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
True
16.2,2.8,2,0.2
Arial,8
0,0,0,0
Text51
{dados.detReduzido}
Black
Transparent
-5.1,4.3,1.1,0.2
Arial,8
0,0,0,0
Text50
soma
Black
Transparent
0,0.2,7.49,0.6
Transparent
0,0,6,0.4
Arial,24
0,0,0,0
Text1
Relatório de Cópia de Transferência
Black
Transparent
6.5,0.4,1,0.2
Arial,8
Right
0,0,0,0
Text2
Pág. {PageNumber}
Black
ReportTitleBand1
Transparent
0,1.2,7.49,1.2
Transparent
True
0.7,0,0.7,0.2
Arial,8
0,0,0,0
Text39
{dados.numero}
Black
Transparent
True
0,0,0.7,0.2
Arial,8,Bold
0,0,0,0
Text3
NrTRANSF :
Black
Transparent
True
3.2,0,2,0.2
Arial,8
0,0,0,0
Text4
{dados.tipoTransferencia}
Black
Transparent
True
2.8,0,0.4,0.2
Arial,8,Bold
Right
0,0,0,0
Text5
Tipo :
Black
Transparent
True
5.7,0,0.6,0.2
Arial,8
0,0,0,0
Text6
{dados.dataEmissao}
Black
Transparent
True
5.3,0,0.4,0.2
Arial,8,Bold
0,0,0,0
Text7
Data :
Black
Transparent
True
6.9,0,0.6,0.2
Arial,8
0,0,0,0
Text8
{dados.loteDataEntrega}
Black
Transparent
True
6.3,0,0.6,0.2
Arial,8,Bold
0,0,0,0
Text9
Previsão :
Black
Transparent
True
3.2,0.2,0.6,0.2
Arial,8
0,0,0,0
Text10
{dados.corteNumero}
Black
Transparent
True
2.6,0.2,0.6,0.2
Arial,8,Bold
Right
0,0,0,0
Text17
Ord.Corte :
Black
Transparent
True
0.7,0.2,0.4,0.2
Arial,8
0,0,0,0
Text18
{dados.empresa}
Black
Transparent
True
0,0.2,0.7,0.2
Arial,8,Bold
0,0,0,0
Text19
Empresa :
Black
Transparent
True
1.6,0.2,1,0.2
Arial,8
0,0,0,0
Text20
{dados.colecao}
Black
Transparent
True
1.1,0.2,0.5,0.2
Arial,8,Bold
0,0,0,0
Text21
Coleção :
Black
Transparent
True
3.2,0.4,0.6,0.2
Arial,8
0,0,0,0
Text22
{dados.tabelaPrecoOrigem}
Black
Transparent
True
2.5,0.4,0.7,0.2
Arial,8,Bold
Right
0,0,0,0
Text23
Tab.Origem :
Black
Transparent
True
3.2,0.6,0.6,0.2
Arial,8
0,0,0,0
Text24
{dados.tabelaPrecoDestino}
Black
Transparent
True
2.5,0.6,0.7,0.2
Arial,8,Bold
Right
0,0,0,0
Text25
Tab.Destino :
Black
Transparent
True
4.3,0.4,0.4,0.2
Arial,8
0,0,0,0
Text26
{dados.empresaOrigem}
Black
Transparent
True
3.9,0.4,0.4,0.2
Arial,8,Bold
0,0,0,0
Text27
Emp :
Black
Transparent
True
4.3,0.6,0.4,0.2
Arial,8
0,0,0,0
Text28
{dados.empresaDestino}
Black
Transparent
True
3.9,0.6,0.4,0.2
Arial,8,Bold
0,0,0,0
Text29
Emp :
Black
Transparent
True
5,0.4,0.4,0.2
Arial,8
0,0,0,0
Text30
{dados.depositoOrigem}
Black
Transparent
True
4.7,0.4,0.3,0.2
Arial,8,Bold
0,0,0,0
Text31
Dep:
Black
Transparent
True
5,0.6,0.4,0.2
Arial,8
0,0,0,0
Text32
{dados.depositoDestino}
Black
Transparent
True
4.7,0.6,0.3,0.2
Arial,8,Bold
0,0,0,0
Text33
Dep:
Black
Transparent
True
6.2,0.4,1.3,0.2
Arial,8
0,0,0,0
Text34
{dados.celulaOrigem}
Black
Transparent
True
5.5,0.4,0.7,0.2
Arial,8,Bold
0,0,0,0
Text35
CélOrigem :
Black
Transparent
True
6.2,0.6,1.3,0.2
Arial,8
0,0,0,0
Text36
{dados.celulaDestino}
Black
Transparent
True
5.5,0.6,0.7,0.2
Arial,8,Bold
0,0,0,0
Text37
CélDestino :
Black
Transparent
True
0.7,0.8,0.8,0.2
Arial,8
0,0,0,0
Text38
{dados.logUsuario}
Black
Transparent
True
0,0.8,0.7,0.2
Arial,8,Bold
0,0,0,0
Text40
Usuário :
Black
Transparent
True
1.6,0.8,0.6,0.2
Arial,8
0,0,0,0
Text41
{dados.logData}
Black
Transparent
True
2.2,0.8,0.6,0.2
Arial,8
0,0,0,0
Text43
{dados.logHora}
Black
Transparent
True
0,1,0.4,0.2
Arial,8
0,0,0,0
lblOrigem
Origem
Black
Transparent
True
6.9,1,0.6,0.2
Arial,8
0,0,0,0
lblTotalPecas
TotPçs
Black
Transparent
True
0.4,1,4.5,0.2
Arial,8
0,0,0,0
lblCodDescReferencia
Cód.Referência - Descrição
Black
Transparent
True
4.9,1,1.5,0.2
Arial,8
0,0,0,0
lblCodDescPadrao
Código Desc. Padrão
Black
Transparent
True
6.4,1,0.5,0.2
Arial,8
0,0,0,0
Text46
$ Unit
Black
Transparent
True
4.7,0.6,0.7,0.2
Arial,8
0,0,0,0
Text47
{dados.soma}
Black
Transparent
True
3.6,0.6,1.1,0.2
Arial,8
0,0,0,0
Text48
soma
Black
0,1,7.5,0.01
Black
Black
HorizontalLinePrimitive2
Black
{dados.numero}
GroupHeaderBand2
Transparent
0,2.8,7.49,0.3
{dados.detReduzido}
GroupHeaderBand1
Transparent
0,3.5,7.49,0.2
Transparent
True
0,0,0.4,0.2
Arial,8
0,0,0,0
Text11
{dados.detTipo}
Black
Transparent
True
6.9,0,0.6,0.2
Arial,8
0,0,0,0
Text13
{dados.detQuantidade}
Black
Transparent
True
0.4,0,4.5,0.2
Arial,8
0,0,0,0
Text15
{dados.detReduzido}
Black
Transparent
True
4.9,0,1.7,0.2
Arial,8
0,0,0,0
Text42
{dados.detPadrao}
Black
Transparent
True
6.4,0,0.5,0.2
Arial,8
0,0,0,0
Text45
{dados.detValorOrigem}
Black
dados
DataBand1
Transparent
0,4.1,7.49,0.4
Transparent
True
6.9,0.2,0.6,0.2
Arial,8
0,0,0,0
Text12
{Sum(dados.detQuantidade)}
Black
Transparent
True
6.9,0,0.6,0.2
Arial,8
0,0,0,0
Text14
Total Pçs
Black
Transparent
0,0.2,6.9,0.2
Arial,8
0,0,0,0
Text16
Text16
Black
GroupFooterBand2
Transparent
0,4.9,7.49,0.4
Transparent
1.4,0,6.1,0.2
Arial,8
0,0,0,0
Text44
Text44
Black
0,0.2,7.5,0.01
Black
Black
HorizontalLinePrimitive1
Black
GroupFooterBand1
True
f3eec2d3965e8ccd8213f4ffba6f0013
0.39,0.39,0.39,0.39
Page1
11.69
8.27
A4
Arial,100
[50:0:0:0]
Report
12/22/2010 0:54:30 AM
12/22/2010 0:54:30 AM
e431766685e17f15934ff4ffba64ab33
Report
Inches
CSharp
Code: Select all
28
14/12/2010
29/12/2010
21
M
1
N
21
21
29/12/2010
apagar
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
14/12/2010
09:14
Ambos
45
55.66
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
10
15
20
P
M
G
9
25/11/2010
29/11/2010
4
M
1
N
4
4
29/11/2010
NAO APAGAR - MASSI \n transferência 9
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
25/11/2010
10:31
Ambos
6
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
1
2
3
P
M
G
13
29/11/2010
01/12/2010
6
M
1
N
0
0
NAO APAGAR - MASSI \ntransferência 13
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
29/11/2010
14:46
Ambos
60
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
30
20
10
P
M
G
14
29/11/2010
30/11/2010
7
M
1
N
7
7
30/11/2010
NAO APAGAR - MASSI \n transferência 14
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
29/11/2010
16:01
Ambos
19
59.59
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
7
8
4
P
M
G
17
03/12/2010
28/12/2010
17
M
1
N
0
17
28/12/2010
transferência 17
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
03/12/2010
17:30
Ambos
6
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
3
2
1
P
M
G
17
03/12/2010
28/12/2010
17
M
1
N
0
17
28/12/2010
transferência 17
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
03/12/2010
17:30
Ambos
9
899.95
0
108200 CONJUNTO OXFORD MELANGE
PÇ
34 LI-MILITAR
9
M
19
06/12/2010
30/12/2010
18
M
1
N
18
19
30/12/2010
transferência 19
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
06/12/2010
11:13
Ambos
65
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
15
20
30
P
M
G
21
07/12/2010
31/12/2010
19
M
1
N
0
21
31/12/2010
transferência 21
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
07/12/2010
14:03
Ambos
60
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
10
20
30
P
M
G
29
14/12/2010
27/12/2010
22
M
1
N
0
22
27/12/2010
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
BEATRIZ
14/12/2010
09:20
Ambos
9
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
2
3
4
P
M
G
39
20/12/2010
31/12/2010
23
M
1
N
0
0
31/12/2010
1
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
MASSI
20/12/2010
16:28
Ambos
9
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
3
3
3
P
M
G
41
20/12/2010
21/12/2010
25
M
1
N
41
156
21/12/2010
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
MASSI
21/12/2010
08:23
Ambos
12
15.15
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
2
4
6
P
M
G
42
21/12/2010
21/12/2010
26
M
1
N
0
42
21/12/2010
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
MASSI
21/12/2010
11:17
Ambos
6
9.99
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
1
3
2
P
M
G
43
21/12/2010
21/12/2010
27
M
1
N
0
0
21/12/2010
100 Start
100 Coleção 100
4 Corte
3 Etiquetagem
01.001
MASSI
21/12/2010
15:17
Ambos
231
0
0
108200 CONJUNTO OXFORD MELANGE
PÇ
19 LI-GRAFITE
12
45
78
96
P
M
G
GG
Data type fields / Sum function
Hello,
We checked the report sent by you. After setting the correct data type, the Sum function works correctly, the data type is defined correctly. Please see the attached screenshot and the corrected report template.
Thank you.
We checked the report sent by you. After setting the correct data type, the Sum function works correctly, the data type is defined correctly. Please see the attached screenshot and the corrected report template.
Thank you.
- Attachments
-
- 748.data.png (58.38 KiB) Viewed 6288 times
-
- 747.Data.xml
- (16.5 KiB) Downloaded 247 times
-
- 746.Report1.mrt
- (35.99 KiB) Downloaded 368 times
Data type fields / Sum function
I'm also having issues with the Sum function. I have set my data types to decimal and for some reason it's concatenating. For example if I have two rows in a group and each of the columns that I want to add up both have 80.00, instead of showing 160.00 it's showing 8080. If I change the 80.00 to say 80.55, it then displays NaN.
I have attached test XML data that I'm using for testing and the report:
I have attached test XML data that I'm using for testing and the report:
Code: Select all
284
1-ygp - 1 Year Gym Pass
290
3-mgp - 3 Month Gym Pass
288
5-fpp - 5 Family Pool Pass
291
golf-1 - Golf
289
p-pass - Pool pass
287
tc-1 - Tennis Courts
284
Smith, Dan
0.00
80.32
10.43
288
Jones, Tom
0.00
80.32
10.43
284
Bocker, Bob
0.00
80.32
10.43
289
Bocker, Dave
0.00
80.32
10.43
289
Jones, Tom
0.00
80.32
10.43
291
Bocker, Bob
0.00
80.32
10.43
Code: Select all
membership_types
type_item_id,System.String
type_name,System.String
membership_types
report_data.membership_types
header_data
organization_name,System.String
organization_logo,System.String
report_start_date,System.String
report_end_date,System.String
header_data
report_data.header_data
membership_sales
person_name,System.String
phone_num,System.String
membership_total,System.Decimal
membership_paid,System.Decimal
membership_balance,System.Decimal
type_item_id,System.String
membership_sales
report_data.membership_sales
footer_data
footer_data
report_data.footer_data
membership_types
type_item_id
membership_types
membership_types_membership_sales
type_item_id
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,10.71,7.49,0.2
Transparent
6.1,-0.01,1.4,0.2
Arial,8
Right
0,0,0,0
Text2
{PageNofM}
Black
PageFooterBand1
Transparent
0,0.2,7.49,1.2
Transparent
4.6,0,2.9,0.2
Arial,12,Bold
Right
0,0,0,0
Text4
Membership Sales Report
Black
All;Black;1;Solid;False;4;Black
Transparent
0,0,1,1
Image1
Transparent
4.9,0.2,2.6,0.2
Arial,8
Right
0,0,0,0
Text6
Date Printed: {Time}
Black
Transparent
3.1,1,4.4,0.2
Arial,8
Right
0,0,0,0
Text13
Date Range: {header_data.report_start_date} - {header_data.report_end_date}
Black
Center
Transparent
0.1,0.4,0.8,0.2
Arial,8
Center
0,0,0,0
Text14
Logo
Black
HeaderBand1
Transparent
0,1.8,7.49,0.2
Transparent
0,0,4.9,0.2
Arial,8,Bold|Underline
0,0,0,0
Text1
{membership_types.type_name}
Black
{membership_sales.membership_types.type_item_id}
GroupHeaderBand1
Transparent
0,2.4,7.49,0.2
Transparent
0.1,0,3.7,0.2
Arial,8
0,0,0,0
Text3
{Line}) {membership_sales.person_name}
Black
Transparent
3.9,0,1,0.2
Arial,8
0,0,0,0
Text7
{membership_sales.membership_total}
Black
Transparent
5.1,0,1,0.2
Arial,8
0,0,0,0
Text8
{membership_sales.membership_paid}
Black
Transparent
6.3,0,1,0.2
Arial,8
0,0,0,0
Text9
{membership_sales.membership_balance}
Black
membership_types_membership_sales
membership_sales
DataBand1
Transparent
0,3,7.49,0.4
Transparent
0.1,0,2.6,0.2
Arial,8,Bold
0,0,0,0
Text5
Total Memberships: {Count()}
Black
Center
Transparent
3.9,0,1,0.2
Arial,8,Bold
0,0,0,0
Text10
{Sum(membership_sales.membership_total)}
Black
Center
Transparent
5.1,0,1,0.2
Arial,8,Bold
0,0,0,0
Text11
{Sum(membership_sales.membership_paid)}
Black
Center
Transparent
6.3,0,1,0.2
Arial,8,Bold
0,0,0,0
Text12
{Sum(membership_sales.membership_balance)}
Black
Center
0,0,7.5,0.01
Black
Black
HorizontalLinePrimitive1
Black
0,0.2,7.5,0.01
Black
Black
HorizontalLinePrimitive2
Black
GroupFooterBand1
8db6a4b2ec1cfe5550eb19927669da34
0.39,0.39,0.39,0.39
Page1
11.69
8.27
Arial,100
[50:0:0:0]
Report
12/28/2010 1:0:30 AM
12/28/2010 1:0:30 AM
c9e70941a4896d83ee581992765ae265
Report
Inches
CSharp
Data type fields / Sum function
I put the xml test data that I was sending from flex and put it into a xml file and used that as the datasource and it worked fine.
This is the code I use in flex to register my xml data:
This is the code I use in flex to register my xml data:
Code: Select all
var report:StiReport = new StiReport();
report.loadReportFromString(this.reportString);
report.regDataXML("report_data", "report_data", this.xmlData);
report.showDialog(null, "Report Viewer", true, true);
Data type fields / Sum function
Hello,
We reproduced this error. It occurs only when the report.regData() methods is used. We will try to fix this error within a week.
At the current moment you can use the following way:
Thank you.
We reproduced this error. It occurs only when the report.regData() methods is used. We will try to fix this error within a week.
At the current moment you can use the following way:
Code: Select all
284
1-ygp - 1 Year Gym Pass
290
3-mgp - 3 Month Gym Pass
288
5-fpp - 5 Family Pool Pass
291
golf-1 - Golf
289
p-pass - Pool pass
287
tc-1 - Tennis Courts
284
Smith, Dan
0.00
80.32
10.43
288
Jones, Tom
0.00
80.32
10.43
284
Bocker, Bob
0.00
80.32
10.43
289
Bocker, Dave
0.00
80.32
10.43
289
Jones, Tom
0.00
80.32
10.43
291
Bocker, Bob
0.00
80.32
10.43
Thank you.
Data type fields / Sum function
Thanks, that worked perfectly.