Dear all

i have a problem by using crystal report. My target: creating a report with a sum for every group and a diagram wich visualizes all sums.

=> From the connected table, I want to use 2 columns

1sth. street classes (Group) => datatype varchar
2nd. street length => datatype number

There no possibility to sum the length for every street group (not inside the assistants and not inside the report). Furthermore I can not do any group-settings inside the diagram-assistant.
Still crystal reports closes directly after 5 seconds when I start to open it - so I can only work when I use already generated rpt-files. SP2 is installed on my pc.

OK, I am a newbee with crystal reports - but my crystal (Version 2008) works not like tutorials told me. Can you help me?

best regards

Thomas

Edited by gipsy - 06 Dec 2010 at 4:02am

I mean, that there is no chance to get the sum for my numeric column. When I act inside the blank report like 

insert => groupresult => choose the numeric column => there is no sum inside the pulldown-menu. There is only something like highest value, lowest value,....but no sum. Not on this way and not when I do want to do this with a report-assistant. The tutorials told me that the sum should be created autmatically when I use the an assistant to create a report and build a group.

Yes, I think you are right.

In our database, length is a number and crystal reports tells me that it is a string.
Other case: a column from our database (VarChar(10 Byte)) is in crystal a number and crystal tells me that I can get the sum for this attribute.

What can I do now?

That's not making much sense.  If Crystal is allowing a sum on a varchar field...something is not right.  I would try refreshing the database, that might correct the issue.

Are you able to create a running total that will take the sum of the lengths evaluated by group?