hariomhari
Programmer
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)%
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)%