crystal report in vb

[VBmim]

Hello

I'm making a crystal report with rdc in visual basic. I have a sql server database with one table 'sales'.

This is a sketch of the database
c.no Customer year value Art Group
1 John 2002 1203.20$ Accessories
2 Smith 2001 5401.25$ Clothing
2 John 2001 500.50$ Accessories
.....

I have to make a report for all the 'Accessories' sales per customer in a year. My problem is that I have to include the sales of the year before in my report. So I have to have the following report

c.no Customer Current y. Last y.
1 John 1203.20$ 500.50%
...

I can write an sql that gives me single reports for each year (with CASE), but I want both values in one record... is this possible in crystal report?

thnx in advance for the help

greetz

Mim

 

[garths2]

You can use a "data definition file" in Crystal to accomplish what you want.

When adding a data source from the data explorer in Crystal Reports you would select "More Data Sources", "Active Data" and "Active Data [Field Definitions Only]"

Do a search in Crystal for "data definition file" and that should get you the rest of the way.

Hope this helps.

GS