Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I perform calculations on multiple baserows in my horizontally

Status
Not open for further replies.

ncalcaterra

Programmer
Nov 11, 2004
27
US
Here's my tiny example... I have a report with a column definition that includes a column for calculating the % of Gross Sales as well as a column for calculating the % of Net Sales. In the Row Definition, I set the CBR to row 280 (gross sales). A little further down in the rows I set the CBR to row 340 (net sales).

Heres what I don't understand 'how' to do... If my columns are obviously going horizontally across the page and one column wants to calculate the percentage off row 280 (gross sales), but the next column wants to calculate the percentage off row 340 (net sales), 'how', when using 'baserow' in your column definition does it know 'which' baserow to calculate from? If this report was vertical, I could understand how there can be multiple baserows. But how, in a horizontal layout, can I have multiple baserows to calculate from?

I hope I made sense! Thanks for any help you can provide :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top