Graphical Report
Posted: Wed Mar 23, 2005 2:44 pm
I have a report which uses a group total to produce a graph however the label for the graphs is not displaying the correct data.__The label is a calculated field which shows the field name and the total in text ( Fieldname+^ ^+SPELLNUM(Total) )____The report is grouped to seven levels and the total i am using is from the lowest level.____If the check box for combine duplicates is unchecked the data is displayed correctly and the field labels also display correctly.____However if the combine duplicates box is checked the graph shows the correct data but the label is incorrect e.g.____unchecked____label_______smith....one____smith....one__smith....one__jones....one____Checked____Smith....one__Jones....one____I seem to be unable to get the label to display the fact that there are indeed Three records for Smith, it stubbornly keeps telling me that there is only one even though the graph displays the correct column size.____Any help with this would be great.____Dave.