Liveware Publishing Support Forum

We^re finding it hard to get correct legends in rr version 8 for bar and pie charts. As a workaround, thought we would print out a listing of categories with descriptions.____This amounts to running a listing within a report, i.e., probably requiring a double scan of the file to get the second listing. ____Specifically, the report runs thru a bunch of stats on each dept that take as much as a full page for each dept. It then prints a chart in the summary band with yearly totals for all depts at the end of the report. ____The chart has only the 2 digit dept numbers, the longer dept titles would not print either at bottom or in a legend. To work around this, either just before or after the chart, we would need to print out a list of dept numbers with titles.____Is there a way to print this kind of a listing within a report, or will we be stuck having users print separate reference lists. Better yet, any plans to fix the legend features in RR?____Thanks,__Rick

Have you tried V9 to see if anything has changed in relation to your problem?__

I checked. No updates were made to charting in version 9, tho planning to move to 9, possibly soon, for other reasons.____

We have not made any charting changes in V9.__We recognize that the current charting support is only rudimentary and that there are bugs and deficiences present in that part of the product^s functionality.____Kathleen__R&R Support

Thanks Kathleen,____I know we can print to an Excel chart, but it requires user to set the variables, labels, etc. before printing. Is there a way to set all of this up in a report so the user only has to print it and it will use the variables, labels etc. that we set up for them? ____Basically, our users want it to be as one click as possible, and would not want to set it up each time they want the latest data in the Excel chart.____Thanks,__Rick____

If you only have a small number of depts, the following calc field might work.____Create a calculated field called test with expression:____IIF(DEPTNO<>prev(DEPTNO),test+STR(DEPTNO,2)+" "+DEPTNAME-";",test)____Place this field in summary band and format it as word wrapped.__The in Format Record Layout, check the box that says begin new line on semicolon.____It should give you a paired listing of DEPTNO and DEPTNAME.______Kathleen__R&R Support

Thanks Kathleen,____It worked, tho had to set up two vars, one for dept < 10 and one > 10. If client adds more then 20 depts, will need to make more adjustments. Not sure why the list would cut off in the middle of a string on the 9th dept. ____Thanks for the workaround. One thing I always liked about RR is there is usually a way to get around a problem if you think or look long enough. ____Just want to put in my vote for fixing the legend problem. The graph features are easy to use and capable enough for my users. They would probably purchase and use RR to create their own reports, but they need and love graphing and without legends, the graph function just doesn^t make it for them.____Thanks,__Rick ______