Some experience with sql,on crystal 8.5. New to MS Access and crystal 9.0. Have tried this with both configurations.
Have multiple rows of data, same unique id, different row names, am pulling a string out of a memo field and converting to number. Managed that.
Can either update dbase or create a formula to store the number minus 100 so that the two combined always equal 100. As in Percentage.
i.e. Field 1 20,60,80,0
Field 2 80,40,20,100
Field 3 Field1+Field2 always equals 100
Have rows with varying numbers, all add up to 100. Trying to create a pie chart for each row of data to be inserted into a sub report, layered onto an ole graphic.
If I choose to group on each column name (unique), I end up with 14 graphs in a 3 x 4 configuration, I need each pie graph to be independent so as to move them on the appropriate space and tag (not auto label) them accordingly.
How can this be done in crystal 9 with Access (weak on the formulas but learning) or can this be done at all ?
Thanks in advance,
Pat
Have multiple rows of data, same unique id, different row names, am pulling a string out of a memo field and converting to number. Managed that.
Can either update dbase or create a formula to store the number minus 100 so that the two combined always equal 100. As in Percentage.
i.e. Field 1 20,60,80,0
Field 2 80,40,20,100
Field 3 Field1+Field2 always equals 100
Have rows with varying numbers, all add up to 100. Trying to create a pie chart for each row of data to be inserted into a sub report, layered onto an ole graphic.
If I choose to group on each column name (unique), I end up with 14 graphs in a 3 x 4 configuration, I need each pie graph to be independent so as to move them on the appropriate space and tag (not auto label) them accordingly.
How can this be done in crystal 9 with Access (weak on the formulas but learning) or can this be done at all ?
Thanks in advance,
Pat