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!

CR-10-Pie chart - Problem showing the Negative value

Status
Not open for further replies.

hariomhari

Programmer
Aug 13, 2007
31
GB
I am using xsd as datasource for crystal report. And generating the pie chart using query.

SELECT Strategy,(SUM(Exposure)) as Exposure FROM table WHERE PortfolioID = 1 GROUP BY Strategy

The output is:
-----------------------------------------
Strategy Exposure
------------------------------------------
1101924.90178831
Cash & Equivalent -39644.3596947789

I am displaying the Exposure data for different strategy in pir chart. But problem is no data is displayed in case Exposure is negative. If exposure is positive value then it displayes value fine.

If I use the SQL view as datasource for crystal report instead of xsd file AND change the (SUM(Exposure)) to ABS((SUM(Exposure)) ) then data is displayed in the pie chart.

However, with XSD datasource and ABS((SUM(Exposure))) , pie chart is not showing data in case exposure is negative value. In case of negative value pie chart displays data in braket : Cash & equivalent (3.5)%
 
Please do not crosspost. This is not the appropriate forum anyway.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top