Display Data Month Wise
-
Hi, I am accpting date from the user in a form. And i want to display the data in crystal reports month wise, in which i want the month names to be the column. Ex: SNo Name Amount Date Jan Feb Mar Apr ..... Is there any way by which i can achive this output by sql query...?:confused:
Deepak Surana
-
Hi, I am accpting date from the user in a form. And i want to display the data in crystal reports month wise, in which i want the month names to be the column. Ex: SNo Name Amount Date Jan Feb Mar Apr ..... Is there any way by which i can achive this output by sql query...?:confused:
Deepak Surana
deepaks3 wrote:
I am accpting date from the user in a form. And i want to display the data in crystal reports month wise, in which i want the month names to be the column. Ex: SNo Name Amount Date Jan Feb Mar Apr ..... Is there any way by which i can achive this output by sql query...?
Try using the
GROUP BYclause on Month(YourDateFieldHere) in your SQL query -
deepaks3 wrote:
I am accpting date from the user in a form. And i want to display the data in crystal reports month wise, in which i want the month names to be the column. Ex: SNo Name Amount Date Jan Feb Mar Apr ..... Is there any way by which i can achive this output by sql query...?
Try using the
GROUP BYclause on Month(YourDateFieldHere) in your SQL query -
By Using Group BY i will get the data in the form of rows, but i want each month amount in the corresponding month.
Deepak Surana
deepaks3 wrote:
By Using Group BY i will get the data in the form of rows, but i want each month amount in the corresponding month.
You might also want to look up Pivot Tables and their usage...
-
deepaks3 wrote:
By Using Group BY i will get the data in the form of rows, but i want each month amount in the corresponding month.
You might also want to look up Pivot Tables and their usage...