CrossTab question
Hello,
I try to use a crosstab, but I can't change 'Count' to 'Sum' for a
valuefield. I've tried double-values and Integer-vcalues, but all I get is
'Count'. All I do is:
- put a Crosstab on my report
- connect to the proper Data-pipeline
- put a field in 'row' (A string field)
- put a field in 'new value' (A double or integer field)
- try to change the setting for the valuefield to Sum. I can choose from the
combobox, but I only get 'Count'.
The rest of the report works fine. What do I do wrong? Help!
The Reportbuilder examples work fine, btw....
Ronald
I try to use a crosstab, but I can't change 'Count' to 'Sum' for a
valuefield. I've tried double-values and Integer-vcalues, but all I get is
'Count'. All I do is:
- put a Crosstab on my report
- connect to the proper Data-pipeline
- put a field in 'row' (A string field)
- put a field in 'new value' (A double or integer field)
- try to change the setting for the valuefield to Sum. I can choose from the
combobox, but I only get 'Count'.
The rest of the report works fine. What do I do wrong? Help!
The Reportbuilder examples work fine, btw....
Ronald
This discussion has been closed.
Comments
Just found out why it didn't work...
The report I use did not have 'live' data available at the time of design.
That means I could not use the preview tab. It looks like it, that the
Crosstab can't figure out what kind of data a field is, if it is not
live.....