| Crosstab and count problem [message #253506] |
Mon, 27 August 2007 05:13  |
Eclipse User |
|
|
|
Originally posted by: marc.doerflinger.diligent-it.com
This is a multi-part message in MIME format.
--------------040806070708090607080807
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
hello!
im having a little problem with birts crosstabs and the count function.
i have a small csv file with 2 rows (attached). Id like to have a report
with a table, that has the count of how many rows with the same value in
the first column are in the csv file. for the attached csv file i expect
something like this
1|3
2|2
3|4
4|1
i tried to do this my inserting a crosstab into the report. i created a
flatfiledataset and and datacube with a group for row 1 and a summery
field with function count for row 1. then i drag the group row1 to the
left column of the crosstab and the summary field count to the second
column, when i now switch to the preview pane i get this:
1|1
2|1
3|1
4|1
if i use e.g. sum instead of count it works fine (the sum is correct).
but i need the count of the rows. is there a bug in the count function?
i need to use the crosstab, since i have to add additional groups later
(this example is simplified, since the real task i have to implment is a
little compilcated to describe).
what do i have to do to get the count of rows with same row1 value?
thanks
marc
--------------040806070708090607080807
Content-Type: text/plain;
name="test.csv"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="test.csv"
cm93MSxyb3cyDQoxLEENCjEsQg0KMSxDDQoyLEENCjIsRw0KMyxUDQozLEsN CjMsTQ0KMyxZ
DQo0LFE=
--------------040806070708090607080807
Content-Type: text/xml;
name="test.rptdesign"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="test.rptdesign"
PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHJlcG9y dCB4bWxucz0i
aHR0cDovL3d3dy5lY2xpcHNlLm9yZy9iaXJ0LzIwMDUvZGVzaWduIiB2ZXJz aW9uPSIzLjIu
MTQiIGlkPSIxIj4KICAgIDxwcm9wZXJ0eSBuYW1lPSJjcmVhdGVkQnkiPkVj bGlwc2UgQklS
VCBEZXNpZ25lciBWZXJzaW9uIDIuMi4wLnYyMDA3MDYyMCBCdWlsZCAmbHQ7 Mi4yLjAudjIw
MDcwNjI1LTA2MzA+PC9wcm9wZXJ0eT4KICAgIDxwcm9wZXJ0eSBuYW1lPSJ1 bml0cyI+aW48
L3Byb3BlcnR5PgogICAgPHByb3BlcnR5IG5hbWU9ImNvbW1lbnRzIj5Db3B5 cmlnaHQgKGMp
IDIwMDcgJmx0OyZsdDtZb3VyIENvbXBhbnkgTmFtZSBoZXJlPj48L3Byb3Bl cnR5PgogICAg
PGh0bWwtcHJvcGVydHkgbmFtZT0iZGVzY3JpcHRpb24iPkNyZWF0ZXMgYSBi bGFuayByZXBv
cnQgd2l0aCBubyBwcmVkZWZpbmVkIGNvbnRlbnQuPC9odG1sLXByb3BlcnR5 PgogICAgPHRl
eHQtcHJvcGVydHkgbmFtZT0iZGlzcGxheU5hbWUiPkJsYW5rIFJlcG9ydDwv dGV4dC1wcm9w
ZXJ0eT4KICAgIDxwcm9wZXJ0eSBuYW1lPSJpY29uRmlsZSI+L3RlbXBsYXRl cy9ibGFua19y
ZXBvcnQuZ2lmPC9wcm9wZXJ0eT4KICAgIDxkYXRhLXNvdXJjZXM+CiAgICAg ICAgPG9kYS1k
YXRhLXNvdXJjZSBleHRlbnNpb25JRD0ib3JnLmVjbGlwc2UuZGF0YXRvb2xz LmNvbm5lY3Rp
dml0eS5vZGEuZmxhdGZpbGUiIG5hbWU9IkRhdGEgU291cmNlIiBpZD0iNiI+ CiAgICAgICAg
ICAgIDx0ZXh0LXByb3BlcnR5IG5hbWU9ImRpc3BsYXlOYW1lIj48L3RleHQt cHJvcGVydHk+
CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJIT01FIj5DOlxwcm9qZWN0 c1x0cnVua1xj
b20uZGlsaWdlbnRpdC5jY3R2bmV0LmV4dC5pbmNpZGVudHJlY29yZGVyXGRh dGE8L3Byb3Bl
cnR5PgogICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0iREVMSU1UWVBFIj5D T01NQTwvcHJv
cGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJDSEFSU0VUIj5V VEYtODwvcHJv
cGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJJTkNMQ09MVU1O TkFNRSI+WUVT
PC9wcm9wZXJ0eT4KICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9IklOQ0xU WVBFTElORSI+
Tk88L3Byb3BlcnR5PgogICAgICAgIDwvb2RhLWRhdGEtc291cmNlPgogICAg PC9kYXRhLXNv
dXJjZXM+CiAgICA8ZGF0YS1zZXRzPgogICAgICAgIDxvZGEtZGF0YS1zZXQg ZXh0ZW5zaW9u
SUQ9Im9yZy5lY2xpcHNlLmRhdGF0b29scy5jb25uZWN0aXZpdHkub2RhLmZs YXRmaWxlLmRh
dGFTZXQiIG5hbWU9IkRhdGEgU2V0IiBpZD0iNyI+CiAgICAgICAgICAgIDxz dHJ1Y3R1cmUg
bmFtZT0iY2FjaGVkTWV0YURhdGEiPgogICAgICAgICAgICAgICAgPGxpc3Qt cHJvcGVydHkg
bmFtZT0icmVzdWx0U2V0Ij4KICAgICAgICAgICAgICAgICAgICA8c3RydWN0 dXJlPgogICAg
ICAgICAgICAgICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0icG9zaXRpb24i PjE8L3Byb3Bl
cnR5PgogICAgICAgICAgICAgICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0i bmFtZSI+cm93
MTwvcHJvcGVydHk+CiAgICAgICAgICAgICAgICAgICAgICAgIDxwcm9wZXJ0 eSBuYW1lPSJk
YXRhVHlwZSI+c3RyaW5nPC9wcm9wZXJ0eT4KICAgICAgICAgICAgICAgICAg ICA8L3N0cnVj
dHVyZT4KICAgICAgICAgICAgICAgICAgICA8c3RydWN0dXJlPgogICAgICAg ICAgICAgICAg
ICAgICAgICA8cHJvcGVydHkgbmFtZT0icG9zaXRpb24iPjI8L3Byb3BlcnR5 PgogICAgICAg
ICAgICAgICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0ibmFtZSI+cm93Mjwv cHJvcGVydHk+
CiAgICAgICAgICAgICAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJkYXRh VHlwZSI+c3Ry
aW5nPC9wcm9wZXJ0eT4KICAgICAgICAgICAgICAgICAgICA8L3N0cnVjdHVy ZT4KICAgICAg
ICAgICAgICAgIDwvbGlzdC1wcm9wZXJ0eT4KICAgICAgICAgICAgPC9zdHJ1 Y3R1cmU+CiAg
ICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJkYXRhU291cmNlIj5EYXRhIFNv dXJjZTwvcHJv
cGVydHk+CiAgICAgICAgICAgIDxsaXN0LXByb3BlcnR5IG5hbWU9InJlc3Vs dFNldCI+CiAg
ICAgICAgICAgICAgICA8c3RydWN0dXJlPgogICAgICAgICAgICAgICAgICAg IDxwcm9wZXJ0
eSBuYW1lPSJwb3NpdGlvbiI+MTwvcHJvcGVydHk+CiAgICAgICAgICAgICAg ICAgICAgPHBy
b3BlcnR5IG5hbWU9Im5hbWUiPnJvdzE8L3Byb3BlcnR5PgogICAgICAgICAg ICAgICAgICAg
IDxwcm9wZXJ0eSBuYW1lPSJuYXRpdmVOYW1lIj5yb3cxPC9wcm9wZXJ0eT4K ICAgICAgICAg
ICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0iZGF0YVR5cGUiPnN0cmluZzwv cHJvcGVydHk+
CiAgICAgICAgICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9Im5hdGl2ZURh dGFUeXBlIj4x
MjwvcHJvcGVydHk+CiAgICAgICAgICAgICAgICA8L3N0cnVjdHVyZT4KICAg ICAgICAgICAg
ICAgIDxzdHJ1Y3R1cmU+CiAgICAgICAgICAgICAgICAgICAgPHByb3BlcnR5 IG5hbWU9InBv
c2l0aW9uIj4yPC9wcm9wZXJ0eT4KICAgICAgICAgICAgICAgICAgICA8cHJv cGVydHkgbmFt
ZT0ibmFtZSI+cm93MjwvcHJvcGVydHk+CiAgICAgICAgICAgICAgICAgICAg PHByb3BlcnR5
IG5hbWU9Im5hdGl2ZU5hbWUiPnJvdzI8L3Byb3BlcnR5PgogICAgICAgICAg ICAgICAgICAg
IDxwcm9wZXJ0eSBuYW1lPSJkYXRhVHlwZSI+c3RyaW5nPC9wcm9wZXJ0eT4K ICAgICAgICAg
ICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0ibmF0aXZlRGF0YVR5cGUiPjEy PC9wcm9wZXJ0
eT4KICAgICAgICAgICAgICAgIDwvc3RydWN0dXJlPgogICAgICAgICAgICA8 L2xpc3QtcHJv
cGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJxdWVyeVRleHQi PnNlbGVjdCAi
cm93MSIsICJyb3cyIiBmcm9tIHRlc3QuY3N2IDogeyJyb3cxIiwicm93MSIs U1RSSU5HOyJy
b3cyIiwicm93MiIsU1RSSU5HfTwvcHJvcGVydHk+CiAgICAgICAgICAgIDx4 bWwtcHJvcGVy
dHkgbmFtZT0iZGVzaWduZXJWYWx1ZXMiPjwhW0NEQVRBWzw/eG1sIHZlcnNp b249IjEuMCIg
ZW5jb2Rpbmc9IlVURi04Ij8+DQo8bW9kZWw6RGVzaWduVmFsdWVzIHhtbG5z OmRlc2lnbj0i
aHR0cDovL3d3dy5lY2xpcHNlLm9yZy9kYXRhdG9vbHMvY29ubmVjdGl2aXR5 L29kYS9kZXNp
Z24iIHhtbG5zOm1vZGVsPSJodHRwOi8vd3d3LmVjbGlwc2Uub3JnL2JpcnQv cmVwb3J0L21v
ZGVsL2FkYXB0ZXIvb2RhTW9kZWwiPg0KICA8VmVyc2lvbj4xLjA8L1ZlcnNp b24+DQogIDxk
ZXNpZ246UmVzdWx0U2V0cyBkZXJpdmVkTWV0YURhdGE9InRydWUiPg0KICAg IDxkZXNpZ246
cmVzdWx0U2V0RGVmaW5pdGlvbnM+DQogICAgICA8ZGVzaWduOnJlc3VsdFNl dENvbHVtbnM+
DQogICAgICAgIDxkZXNpZ246cmVzdWx0Q29sdW1uRGVmaW5pdGlvbnM+DQog ICAgICAgICAg
PGRlc2lnbjphdHRyaWJ1dGVzPg0KICAgICAgICAgICAgPGRlc2lnbjpuYW1l PnJvdzE8L2Rl
c2lnbjpuYW1lPg0KICAgICAgICAgICAgPGRlc2lnbjpwb3NpdGlvbj4xPC9k ZXNpZ246cG9z
aXRpb24+DQogICAgICAgICAgICA8ZGVzaWduOm5hdGl2ZURhdGFUeXBlQ29k ZT4xMjwvZGVz
aWduOm5hdGl2ZURhdGFUeXBlQ29kZT4NCiAgICAgICAgICAgIDxkZXNpZ246 cHJlY2lzaW9u
Pi0xPC9kZXNpZ246cHJlY2lzaW9uPg0KICAgICAgICAgICAgPGRlc2lnbjpz Y2FsZT4tMTwv
ZGVzaWduOnNjYWxlPg0KICAgICAgICAgICAgPGRlc2lnbjpudWxsYWJpbGl0 eT5Vbmtub3du
PC9kZXNpZ246bnVsbGFiaWxpdHk+DQogICAgICAgICAgPC9kZXNpZ246YXR0 cmlidXRlcz4N
CiAgICAgICAgICA8ZGVzaWduOnVzYWdlSGludHM+DQogICAgICAgICAgICA8 ZGVzaWduOmxh
YmVsPnJvdzE8L2Rlc2lnbjpsYWJlbD4NCiAgICAgICAgICAgIDxkZXNpZ246 Zm9ybWF0dGlu
Z0hpbnRzLz4NCiAgICAgICAgICA8L2Rlc2lnbjp1c2FnZUhpbnRzPg0KICAg ICAgICA8L2Rl
c2lnbjpyZXN1bHRDb2x1bW5EZWZpbml0aW9ucz4NCiAgICAgICAgPGRlc2ln bjpyZXN1bHRD
b2x1bW5EZWZpbml0aW9ucz4NCiAgICAgICAgICA8ZGVzaWduOmF0dHJpYnV0 ZXM+DQogICAg
ICAgICAgICA8ZGVzaWduOm5hbWU+cm93MjwvZGVzaWduOm5hbWU+DQogICAg ICAgICAgICA8
ZGVzaWduOnBvc2l0aW9uPjI8L2Rlc2lnbjpwb3NpdGlvbj4NCiAgICAgICAg ICAgIDxkZXNp
Z246bmF0aXZlRGF0YVR5cGVDb2RlPjEyPC9kZXNpZ246bmF0aXZlRGF0YVR5 cGVDb2RlPg0K
ICAgICAgICAgICAgPGRlc2lnbjpwcmVjaXNpb24+LTE8L2Rlc2lnbjpwcmVj aXNpb24+DQog
ICAgICAgICAgICA8ZGVzaWduOnNjYWxlPi0xPC9kZXNpZ246c2NhbGU+DQog ICAgICAgICAg
ICA8ZGVzaWduOm51bGxhYmlsaXR5PlVua25vd248L2Rlc2lnbjpudWxsYWJp bGl0eT4NCiAg
ICAgICAgICA8L2Rlc2lnbjphdHRyaWJ1dGVzPg0KICAgICAgICAgIDxkZXNp Z246dXNhZ2VI
aW50cz4NCiAgICAgICAgICAgIDxkZXNpZ246bGFiZWw+cm93MjwvZGVzaWdu OmxhYmVsPg0K
ICAgICAgICAgICAgPGRlc2lnbjpmb3JtYXR0aW5nSGludHMvPg0KICAgICAg ICAgIDwvZGVz
aWduOnVzYWdlSGludHM+DQogICAgICAgIDwvZGVzaWduOnJlc3VsdENvbHVt bkRlZmluaXRp
b25zPg0KICAgICAgPC9kZXNpZ246cmVzdWx0U2V0Q29sdW1ucz4NCiAgICA8 L2Rlc2lnbjpy
ZXN1bHRTZXREZWZpbml0aW9ucz4NCiAgPC9kZXNpZ246UmVzdWx0U2V0cz4N CjwvbW9kZWw6
RGVzaWduVmFsdWVzPg0KXV0+PC94bWwtcHJvcGVydHk+CiAgICAgICAgPC9v ZGEtZGF0YS1z
ZXQ+CiAgICA8L2RhdGEtc2V0cz4KICAgIDxjdWJlcz4KICAgICAgICA8dGFi dWxhci1jdWJl
IG5hbWU9IkN1c3RvbWVyIEN1YmUiIGlkPSI5Ij4KICAgICAgICAgICAgPHBy b3BlcnR5IG5h
bWU9ImRlZmF1bHRNZWFzdXJlR3JvdXAiPlN1bW1hcnkgRmllbGQ8L3Byb3Bl cnR5PgogICAg
ICAgICAgICA8cHJvcGVydHkgbmFtZT0iZGltZW5zaW9ucyI+CiAgICAgICAg ICAgICAgICA8
dGFidWxhci1kaW1lbnNpb24gbmFtZT0iR3JvdXAiIGlkPSIxMCI+CiAgICAg ICAgICAgICAg
ICAgICAgPHByb3BlcnR5IG5hbWU9ImRlZmF1bHRIaWVyYXJjaHkiPk5ld1Rh YnVsYXJIaWVy
YXJjaHk8L3Byb3BlcnR5PgogICAgICAgICAgICAgICAgICAgIDxwcm9wZXJ0 eSBuYW1lPSJo
aWVyYXJjaGllcyI+CiAgICAgICAgICAgICAgICAgICAgICAgIDx0YWJ1bGFy LWhpZXJhcmNo
eSBuYW1lPSJOZXdUYWJ1bGFySGllcmFyY2h5IiBpZD0iMTEiPgogICAgICAg ICAgICAgICAg
ICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9ImxldmVscyI+CiAgICAgICAg ICAgICAgICAg
ICAgICAgICAgICAgICAgPHRhYnVsYXItbGV2ZWwgbmFtZT0icm93MSIgaWQ9 IjEyIj4KICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHByb3BlcnR5IG5h bWU9ImRhdGFU
eXBlIj5zdHJpbmc8L3Byb3BlcnR5PgogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAg
ICAgICA8cHJvcGVydHkgbmFtZT0ibGV2ZWxUeXBlIj5keW5hbWljPC9wcm9w ZXJ0eT4KICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHByb3BlcnR5IG5h bWU9ImNvbHVt
bk5hbWUiPnJvdzE8L3Byb3BlcnR5PgogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAg
IDwvdGFidWxhci1sZXZlbD4KICAgICAgICAgICAgICAgICAgICAgICAgICAg IDwvcHJvcGVy
dHk+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8cHJvcGVydHkgbmFt ZT0iZGF0YVNl
dCI+RGF0YSBTZXQ8L3Byb3BlcnR5PgogICAgICAgICAgICAgICAgICAgICAg ICA8L3RhYnVs
YXItaGllcmFyY2h5PgogICAgICAgICAgICAgICAgICAgIDwvcHJvcGVydHk+ CiAgICAgICAg
ICAgICAgICA8L3RhYnVsYXItZGltZW5zaW9uPgogICAgICAgICAgICA8L3By b3BlcnR5Pgog
ICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0ibWVhc3VyZUdyb3VwcyI+CiAg ICAgICAgICAg
ICAgICA8dGFidWxhci1tZWFzdXJlLWdyb3VwIG5hbWU9IlN1bW1hcnkgRmll bGQiIGlkPSIy
NSI+CiAgICAgICAgICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9Im1lYXN1 cmVzIj4KICAg
ICAgICAgICAgICAgICAgICAgICAgPHRhYnVsYXItbWVhc3VyZSBuYW1lPSJy b3cxIiBpZD0i
MjciPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgPHByb3BlcnR5IG5h bWU9ImZ1bmN0
aW9uIj5jb3VudDwvcHJvcGVydHk+CiAgICAgICAgICAgICAgICAgICAgICAg ICAgICA8ZXhw
cmVzc2lvbiBuYW1lPSJtZWFzdXJlRXhwcmVzc2lvbiI+ZGF0YVNldFJvd1si cm93MSJdPC9l
eHByZXNzaW9uPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgPHByb3Bl cnR5IG5hbWU9
ImRhdGFUeXBlIj5zdHJpbmc8L3Byb3BlcnR5PgogICAgICAgICAgICAgICAg ICAgICAgICA8
L3RhYnVsYXItbWVhc3VyZT4KICAgICAgICAgICAgICAgICAgICA8L3Byb3Bl cnR5PgogICAg
ICAgICAgICAgICAgPC90YWJ1bGFyLW1lYXN1cmUtZ3JvdXA+CiAgICAgICAg ICAgIDwvcHJv
cGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJkYXRhU2V0Ij5E YXRhIFNldDwv
cHJvcGVydHk+CiAgICAgICAgPC90YWJ1bGFyLWN1YmU+CiAgICA8L2N1YmVz PgogICAgPHN0
eWxlcz4KICAgICAgICA8c3R5bGUgbmFtZT0iY3Jvc3N0YWItY2VsbCIgaWQ9 IjQiPgogICAg
ICAgICAgICA8cHJvcGVydHkgbmFtZT0iYm9yZGVyQm90dG9tQ29sb3IiPiND Q0NDQ0M8L3By
b3BlcnR5PgogICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0iYm9yZGVyQm90 dG9tU3R5bGUi
PnNvbGlkPC9wcm9wZXJ0eT4KICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9 ImJvcmRlckJv
dHRvbVdpZHRoIj4xcHQ8L3Byb3BlcnR5PgogICAgICAgICAgICA8cHJvcGVy dHkgbmFtZT0i
Ym9yZGVyTGVmdENvbG9yIj4jQ0NDQ0NDPC9wcm9wZXJ0eT4KICAgICAgICAg ICAgPHByb3Bl
cnR5IG5hbWU9ImJvcmRlckxlZnRTdHlsZSI+c29saWQ8L3Byb3BlcnR5Pgog ICAgICAgICAg
ICA8cHJvcGVydHkgbmFtZT0iYm9yZGVyTGVmdFdpZHRoIj4xcHQ8L3Byb3Bl cnR5PgogICAg
ICAgICAgICA8cHJvcGVydHkgbmFtZT0iYm9yZGVyUmlnaHRDb2xvciI+I0ND Q0NDQzwvcHJv
cGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJib3JkZXJSaWdo dFN0eWxlIj5z
b2xpZDwvcHJvcGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJi b3JkZXJSaWdo
dFdpZHRoIj4xcHQ8L3Byb3BlcnR5PgogICAgICAgICAgICA8cHJvcGVydHkg bmFtZT0iYm9y
ZGVyVG9wQ29sb3IiPiNDQ0NDQ0M8L3Byb3BlcnR5PgogICAgICAgICAgICA8 cHJvcGVydHkg
bmFtZT0iYm9yZGVyVG9wU3R5bGUiPnNvbGlkPC9wcm9wZXJ0eT4KICAgICAg ICAgICAgPHBy
b3BlcnR5IG5hbWU9ImJvcmRlclRvcFdpZHRoIj4xcHQ8L3Byb3BlcnR5Pgog ICAgICAgIDwv
c3R5bGU+CiAgICAgICAgPHN0eWxlIG5hbWU9ImNyb3NzdGFiIiBpZD0iNSI+ CiAgICAgICAg
ICAgIDxwcm9wZXJ0eSBuYW1lPSJib3JkZXJCb3R0b21Db2xvciI+I0NDQ0ND QzwvcHJvcGVy
dHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJib3JkZXJCb3R0b21T dHlsZSI+c29s
aWQ8L3Byb3BlcnR5PgogICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0iYm9y ZGVyQm90dG9t
V2lkdGgiPjFwdDwvcHJvcGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBu YW1lPSJib3Jk
ZXJMZWZ0Q29sb3IiPiNDQ0NDQ0M8L3Byb3BlcnR5PgogICAgICAgICAgICA8 cHJvcGVydHkg
bmFtZT0iYm9yZGVyTGVmdFN0eWxlIj5zb2xpZDwvcHJvcGVydHk+CiAgICAg ICAgICAgIDxw
cm9wZXJ0eSBuYW1lPSJib3JkZXJMZWZ0V2lkdGgiPjFwdDwvcHJvcGVydHk+ CiAgICAgICAg
ICAgIDxwcm9wZXJ0eSBuYW1lPSJib3JkZXJSaWdodENvbG9yIj4jQ0NDQ0ND PC9wcm9wZXJ0
eT4KICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9ImJvcmRlclJpZ2h0U3R5 bGUiPnNvbGlk
PC9wcm9wZXJ0eT4KICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9ImJvcmRl clJpZ2h0V2lk
dGgiPjFwdDwvcHJvcGVydHk+CiAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1l PSJib3JkZXJU
b3BDb2xvciI+I0NDQ0NDQzwvcHJvcGVydHk+CiAgICAgICAgICAgIDxwcm9w ZXJ0eSBuYW1l
PSJib3JkZXJUb3BTdHlsZSI+c29saWQ8L3Byb3BlcnR5PgogICAgICAgICAg ICA8cHJvcGVy
dHkgbmFtZT0iYm9yZGVyVG9wV2lkdGgiPjFwdDwvcHJvcGVydHk+CiAgICAg ICAgPC9zdHls
ZT4KICAgIDwvc3R5bGVzPgogICAgPHBhZ2Utc2V0dXA+CiAgICAgICAgPHNp bXBsZS1tYXN0
ZXItcGFnZSBuYW1lPSJTaW1wbGUgTWFzdGVyUGFnZSIgaWQ9IjIiPgogICAg ICAgICAgICA8
cGFnZS1mb290ZXI+CiAgICAgICAgICAgICAgICA8dGV4dCBpZD0iMyI+CiAg ICAgICAgICAg
ICAgICAgICAgPHByb3BlcnR5IG5hbWU9ImNvbnRlbnRUeXBlIj5odG1sPC9w cm9wZXJ0eT4K
ICAgICAgICAgICAgICAgICAgICA8dGV4dC1wcm9wZXJ0eSBuYW1lPSJjb250 ZW50Ij48IVtD
REFUQVs8dmFsdWUtb2Y+bmV3IERhdGUoKTwvdmFsdWUtb2Y+XV0+PC90ZXh0 LXByb3BlcnR5
PgogICAgICAgICAgICAgICAgPC90ZXh0PgogICAgICAgICAgICA8L3BhZ2Ut Zm9vdGVyPgog
ICAgICAgIDwvc2ltcGxlLW1hc3Rlci1wYWdlPgogICAgPC9wYWdlLXNldHVw PgogICAgPGJv
ZHk+CiAgICAgICAgPGV4dGVuZGVkLWl0ZW0gZXh0ZW5zaW9uTmFtZT0iQ3Jv c3N0YWIiIGlk
PSI4Ij4KICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9Im1lYXN1cmVzIj4K ICAgICAgICAg
ICAgICAgIDxleHRlbmRlZC1pdGVtIGV4dGVuc2lvbk5hbWU9Ik1lYXN1cmVW aWV3IiBpZD0i
MjgiPgogICAgICAgICAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJtZWFz dXJlIj5yb3cx
PC9wcm9wZXJ0eT4KICAgICAgICAgICAgICAgICAgICA8cHJvcGVydHkgbmFt ZT0iZGV0YWls
Ij4KICAgICAgICAgICAgICAgICAgICAgICAgPGV4dGVuZGVkLWl0ZW0gZXh0 ZW5zaW9uTmFt
ZT0iQ3Jvc3N0YWJDZWxsIiBpZD0iMjkiPgogICAgICAgICAgICAgICAgICAg ICAgICAgICAg
PHByb3BlcnR5IG5hbWU9ImNvbnRlbnQiPgogICAgICAgICAgICAgICAgICAg ICAgICAgICAg
ICAgIDxkYXRhIG5hbWU9InJvdzExIiBpZD0iMzEiPgogICAgICAgICAgICAg ICAgICAgICAg
ICAgICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0icmVzdWx0U2V0Q29sdW1u Ij5yb3cxXzE8
L3Byb3BlcnR5PgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDwv ZGF0YT4KICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIDwvcHJvcGVydHk+CiAgICAgICAg ICAgICAgICAg
ICAgICAgIDwvZXh0ZW5kZWQtaXRlbT4KICAgICAgICAgICAgICAgICAgICA8 L3Byb3BlcnR5
PgogICAgICAgICAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJoZWFkZXIi PgogICAgICAg
ICAgICAgICAgICAgICAgICA8ZXh0ZW5kZWQtaXRlbSBleHRlbnNpb25OYW1l PSJDcm9zc3Rh
YkNlbGwiIGlkPSIzMCI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8 cHJvcGVydHkg
bmFtZT0iY29udGVudCI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgPGxhYmVs
IGlkPSIzMiI+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IDx0ZXh0LXBy
b3BlcnR5IG5hbWU9InRleHQiPnJvdzE8L3RleHQtcHJvcGVydHk+CiAgICAg ICAgICAgICAg
ICAgICAgICAgICAgICAgICAgPC9sYWJlbD4KICAgICAgICAgICAgICAgICAg ICAgICAgICAg
IDwvcHJvcGVydHk+CiAgICAgICAgICAgICAgICAgICAgICAgIDwvZXh0ZW5k ZWQtaXRlbT4K
ICAgICAgICAgICAgICAgICAgICA8L3Byb3BlcnR5PgogICAgICAgICAgICAg ICAgPC9leHRl
bmRlZC1pdGVtPgogICAgICAgICAgICA8L3Byb3BlcnR5PgogICAgICAgICAg ICA8cHJvcGVy
dHkgbmFtZT0icm93cyI+CiAgICAgICAgICAgICAgICA8ZXh0ZW5kZWQtaXRl bSBleHRlbnNp
b25OYW1lPSJDcm9zc3RhYlZpZXciIGlkPSIxNSI+CiAgICAgICAgICAgICAg ICAgICAgPHBy
b3BlcnR5IG5hbWU9InZpZXdzIj4KICAgICAgICAgICAgICAgICAgICAgICAg PGV4dGVuZGVk
LWl0ZW0gZXh0ZW5zaW9uTmFtZT0iRGltZW5zaW9uVmlldyIgaWQ9IjE2Ij4K ICAgICAgICAg
ICAgICAgICAgICAgICAgICAgIDxwcm9wZXJ0eSBuYW1lPSJkaW1lbnNpb24i Pkdyb3VwPC9w
cm9wZXJ0eT4KICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxwcm9wZXJ0 eSBuYW1lPSJs
ZXZlbHMiPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDxleHRl bmRlZC1pdGVt
IGV4dGVuc2lvbk5hbWU9IkxldmVsVmlldyIgbmFtZT0iTmV3TGV2ZWwgVmll dyIgaWQ9IjE3
Ij4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHByb3Bl cnR5IG5hbWU9
ImxldmVsIj5Hcm91cC9yb3cxPC9wcm9wZXJ0eT4KICAgICAgICAgICAgICAg ICAgICAgICAg
ICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9Im1lbWJlciI+CiAgICAgICAg ICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICA8ZXh0ZW5kZWQtaXRlbSBleHRlbnNp b25OYW1lPSJD
cm9zc3RhYkNlbGwiIGlkPSIxOCI+CiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAg
ICAgICAgICAgICAgPHByb3BlcnR5IG5hbWU9ImNvbnRlbnQiPgogICAgICAg ICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA8ZGF0YSBuYW1lPSJy b3cxIiBpZD0i
MTkiPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAg
ICAgPHByb3BlcnR5IG5hbWU9InJlc3VsdFNldENvbHVtbiI+cm93MTwvcHJv cGVydHk+CiAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IDwvZGF0YT4K
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA8 L3Byb3BlcnR5
PgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPC9l eHRlbmRlZC1p
dGVtPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA8L3By b3BlcnR5Pgog
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDwvZXh0ZW5kZWQtaXRl bT4KICAgICAg
ICAgICAgICAgICAgICAgICAgICAgIDwvcHJvcGVydHk+CiAgICAgICAgICAg ICAgICAgICAg
ICAgIDwvZXh0ZW5kZWQtaXRlbT4KICAgICAgICAgICAgICAgICAgICA8L3By b3BlcnR5Pgog
ICAgICAgICAgICAgICAgPC9leHRlbmRlZC1pdGVtPgogICAgICAgICAgICA8 L3Byb3BlcnR5
PgogICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0iY3ViZSI+Q3VzdG9tZXIg Q3ViZTwvcHJv
cGVydHk+CiAgICAgICAgICAgIDxsaXN0LXByb3BlcnR5IG5hbWU9ImJvdW5k RGF0YUNvbHVt
bnMiPgogICAgICAgICAgICAgICAgPHN0cnVjdHVyZT4KICAgICAgICAgICAg ICAgICAgICA8
cHJvcGVydHkgbmFtZT0ibmFtZSI+cm93MTwvcHJvcGVydHk+CiAgICAgICAg ICAgICAgICAg
ICAgPGV4cHJlc3Npb24gbmFtZT0iZXhwcmVzc2lvbiI+ZGltZW5zaW9uWyJH cm91cCJdWyJy
b3cxIl08L2V4cHJlc3Npb24+CiAgICAgICAgICAgICAgICAgICAgPHByb3Bl cnR5IG5hbWU9
ImRhdGFUeXBlIj5zdHJpbmc8L3Byb3BlcnR5PgogICAgICAgICAgICAgICAg PC9zdHJ1Y3R1
cmU+CiAgICAgICAgICAgICAgICA8c3RydWN0dXJlPgogICAgICAgICAgICAg ICAgICAgIDxw
cm9wZXJ0eSBuYW1lPSJuYW1lIj5yb3cxXzE8L3Byb3BlcnR5PgogICAgICAg ICAgICAgICAg
ICAgIDxleHByZXNzaW9uIG5hbWU9ImV4cHJlc3Npb24iPm1lYXN1cmVbInJv dzEiXTwvZXhw
cmVzc2lvbj4KICAgICAgICAgICAgICAgICAgICA8cHJvcGVydHkgbmFtZT0i ZGF0YVR5cGUi
PnN0cmluZzwvcHJvcGVydHk+CiAgICAgICAgICAgICAgICA8L3N0cnVjdHVy ZT4KICAgICAg
ICAgICAgPC9saXN0LXByb3BlcnR5PgogICAgICAgIDwvZXh0ZW5kZWQtaXRl bT4KICAgIDwv
Ym9keT4KPC9yZXBvcnQ+Cg==
--------------040806070708090607080807--
|
|
|
| Re: Crosstab and count problem [message #253741 is a reply to message #253506] |
Tue, 28 August 2007 14:29  |
| Eclipse User |
|
|
|
Hi Marc,
I am looking into this, will get back soon
--Rima Kanguri
"Marc Doerflinger" <marc.doerflinger@diligent-it.com> wrote in message
news:fau4j6$fss$1@build.eclipse.org...
> hello!
>
> im having a little problem with birts crosstabs and the count function.
> i have a small csv file with 2 rows (attached). Id like to have a report
> with a table, that has the count of how many rows with the same value in
> the first column are in the csv file. for the attached csv file i expect
> something like this
>
> 1|3
> 2|2
> 3|4
> 4|1
>
> i tried to do this my inserting a crosstab into the report. i created a
> flatfiledataset and and datacube with a group for row 1 and a summery
> field with function count for row 1. then i drag the group row1 to the
> left column of the crosstab and the summary field count to the second
> column, when i now switch to the preview pane i get this:
>
> 1|1
> 2|1
> 3|1
> 4|1
>
> if i use e.g. sum instead of count it works fine (the sum is correct).
> but i need the count of the rows. is there a bug in the count function?
> i need to use the crosstab, since i have to add additional groups later
> (this example is simplified, since the real task i have to implment is a
> little compilcated to describe).
> what do i have to do to get the count of rows with same row1 value?
>
> thanks
> marc
>
------------------------------------------------------------ ----------------
----
> row1,row2
> 1,A
> 1,B
> 1,C
> 2,A
> 2,G
> 3,T
> 3,K
> 3,M
> 3,Y
> 4,Q
------------------------------------------------------------ ----------------
----
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.14"
id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
2.2.0.v20070620 Build <2.2.0.v20070625-0630></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2007 <<Your Company Name
here>></property>
> <html-property name="description">Creates a blank report with no
predefined content.</html-property>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <data-sources>
> <oda-data-source
extensionID="org.eclipse.datatools.connectivity.oda.flatfile " name="Data
Source" id="6">
> <text-property name="displayName"></text-property>
> <property
name="HOME"> C:\projects\trunk\com.diligentit.cctvnet.ext.incidentrecorde r\da
ta</property>
> <property name="DELIMTYPE">COMMA</property>
> <property name="CHARSET">UTF-8</property>
> <property name="INCLCOLUMNNAME">YES</property>
> <property name="INCLTYPELINE">NO</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
extensionID="org.eclipse.datatools.connectivity.oda.flatfile.dataSet "
name="Data Set" id="7">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">row1</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">row2</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">row1</property>
> <property name="nativeName">row1</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">row2</property>
> <property name="nativeName">row2</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">select "row1", "row2" from test.csv
: {"row1","row1",STRING;"row2","row2",STRING}</property >
> <xml-property name="designerValues"><![CDATA[<?xml
version="1.0" encoding="UTF-8"?>
> <model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>row1</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>row1</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>row2</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>-1</design:precision>
> <design:scale>-1</design:scale>
> <design:nullability>Unknown</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>row2</design:label>
> <design:formattingHints/>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <cubes>
> <tabular-cube name="Customer Cube" id="9">
> <property name="defaultMeasureGroup">Summary Field</property>
> <property name="dimensions">
> <tabular-dimension name="Group" id="10">
> <property
name="defaultHierarchy">NewTabularHierarchy</property>
> <property name="hierarchies">
> <tabular-hierarchy name="NewTabularHierarchy"
id="11">
> <property name="levels">
> <tabular-level name="row1" id="12">
> <property
name="dataType">string</property>
> <property
name="levelType">dynamic</property>
> <property
name="columnName">row1</property>
> </tabular-level>
> </property>
> <property name="dataSet">Data Set</property>
> </tabular-hierarchy>
> </property>
> </tabular-dimension>
> </property>
> <property name="measureGroups">
> <tabular-measure-group name="Summary Field" id="25">
> <property name="measures">
> <tabular-measure name="row1" id="27">
> <property name="function">count</property>
> <expression
name="measureExpression">dataSetRow["row1"]</expression >
> <property name="dataType">string</property>
> </tabular-measure>
> </property>
> </tabular-measure-group>
> </property>
> <property name="dataSet">Data Set</property>
> </tabular-cube>
> </cubes>
> <styles>
> <style name="crosstab-cell" id="4">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of>new
Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <extended-item extensionName="Crosstab" id="8">
> <property name="measures">
> <extended-item extensionName="MeasureView" id="28">
> <property name="measure">row1</property>
> <property name="detail">
> <extended-item extensionName="CrosstabCell"
id="29">
> <property name="content">
> <data name="row11" id="31">
> <property
name="resultSetColumn">row1_1</property>
> </data>
> </property>
> </extended-item>
> </property>
> <property name="header">
> <extended-item extensionName="CrosstabCell"
id="30">
> <property name="content">
> <label id="32">
> <text-property
name="text">row1</text-property>
> </label>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> <property name="rows">
> <extended-item extensionName="CrosstabView" id="15">
> <property name="views">
> <extended-item extensionName="DimensionView"
id="16">
> <property name="dimension">Group</property>
> <property name="levels">
> <extended-item extensionName="LevelView"
name="NewLevel View" id="17">
> <property
name="level">Group/row1</property>
> <property name="member">
> <extended-item
extensionName="CrosstabCell" id="18">
> <property name="content">
> <data name="row1" id="19">
> <property
name="resultSetColumn">row1</property>
> </data>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> <property name="cube">Customer Cube</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">row1</property>
> <expression
name="expression">dimension["Group"]["row1"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">row1_1</property>
> <expression
name="expression">measure["row1"]</expression>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </extended-item>
> </body>
> </report>
>
|
|
|
|
|
|
|
| Re: Crosstab and count problem [message #254485 is a reply to message #254389] |
Tue, 04 September 2007 20:47 |
| Eclipse User |
|
|
|
Hi Marc and Klaasjan
The function mechanism has been changed in the latest build. If you define
a COUNT in cube, the default function of measure in crosstab is SUM but
not COUNT again. In future, allow user to specify function of measure in
crosstab will be open. So please try the latest BIRT2.2.1 nightly build.
Regards!
|
|
|
Powered by
FUDForum. Page generated in 0.10626 seconds
Home