Hi All,
I am well in Access Reports but in crystal reports just i am learning. I am using visual basic 2005 and access 2003 database. The report development in crystal, I am struggling and searching a long time but there is no useful tips. My database has more tables and related with each other. I am trying to develop a report which should be grouped by date and category and count the records as well as sum the amount. The data fields look like as follows:
Date Category RecordID Amount
22/05/2012 axy 1 1200
22/05/2012 axy 2 1200
22/05/2012 jxs 3 2400
23/05/2012 xuv 4 1200
23/05/2012 xuv 5 1200
23/05/2012 xuv 6 1200
23/05/2012 kls 7 2400
23/05/2012 mns 8 2400
Crystal has definitely nice tools and I know how to proceed a simple report with parameters. I need the data should be grouped as like in access format like the one as below:
Date Category Count Amount
22/05/2012 axy 2 2400
22/05/2012 jxs 1 2400
23/05/2012 xuv 3 3600
23/05/2012 kls 1 2400
23/05/2012 mns 1 2400
How can i group the data by date and category, count the records by category count and sum the amount against category.
Please help me in this issue.
And I want another one issue that I have many queries in my access database. When connecting it to the Visual Studio it shows all in the function mode not as stored procedure. How can I directly use that function to achieve the results?
Thanks for your valuable recommends.