Click here to Skip to main content
15,747,908 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a database with 12 tables (for every month in yr). someone contributes every month some amount towards their savings which may not be the same every month. The savings field is the same for every table (share_cr).
Problem is: how to i create a statement in crystal so that it shows the value that was contributed by a given member for every month in one report i.e

Month share_cr
january 15000
February 9000
march 20000
Total 44000

Someone help plz

1 solution

You can use group by in crystal reports. First group by it using Month field then group by it using member field also.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900