XL Reporter

I too a look at the sample report pack from SAP and I noticed that when they created a graph (even over expanding groups), they were selecting the cell below the value as well.

When I first added the graph to the report, I selected the expanding row value (e.g., $B$6) only as the data values for the graph and ran the report. The graph only displayed one value, the first line of the expanding row. A little frustrated, I took a look at one of their examples and found that they were selecting the cell right below the expanding row as well (e.g., $B$6 and $B$7, written in Excel as $B$6:$B$7). This produced the results that I was expecting. I did the same thing for the value labels for the graph (e.g., $A$6:$A$7).

Thanks to Ed Monk of SBONotes.com

© 2009, Mark Chinsky. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.

Mark is a partner at Clients First Business Solutions, LLC. He is based out of the NY/NJ office. Mark has been in ERP sales and service for more than 20 years and at least 15 with Sage

Mark Chinsky

View all posts by Mark Chinsky
Mark's website

« Creating Custom Queries in SAP Business One | Home | SAP Business One Formatted Search: Default the State Tax Code »

• 
  
  
  
  
  
  
• Ask a Question on Ask The 90 Minds Group