SQL Expression Field

[former_member761973]

I am designing a web project for report card in Crystal report with Visual Studio for students having tables

marks_entry (to enter marks and weightage scored by student in various exams)

subject_6 to store subjects of class 6

And in the report i want to have the weightage of a particular subject and exam, for which i have created a sql expression field having following query (to get the weightage of periodic test for first term in English subject)

( Select `marks_entry`.`weightage`

from marks_entry

where `marks_entry`.`exam`="Periodic Test" and

`marks_entry`.`subject`=`subject_6`.`language1`

and `marks_entry`.`term`="First" )

but i am getting 0.0 as answer whereas the value to be displayed should be 7.6.

Kindly help me to sort out the problem or provide a better alternative.

Thanks

[former_member751591]

Welcome to the SAP Community! Take these tutorials to learn more about getting started:

Ask and Answer Questions on SAP Community | Tutorials for SAP Developers

Update and Maintain Your SAP Profile at people.sap.com | Tutorials for SAP Developers

Tour the SAP Community | Tutorials for SAP Developers

Thank you!

[DellSC]

SQL Expressions are not meant for running a full select statement. Instead, their purpose is to provide a specific value to the Select for the report, such as running a stored function that returns the concatenated address or full name.

What exactly are you trying to show on your report? Just the value for this class? Or this class along with other classes?

[former_member761973 · Accepted solution]

My actual problem explained ....

https://answers.sap.com/questions/13463308/how-to-design-crystal-report-for-my-project.html#