Can Someone please show me how to Create a Report using Crystal in VB

[Nitesh]

Hi All,

I want to create a report in my VB app using crystal reports. It's my first time using crystal so please offer me your valued assistance.

Regards,
Nitesh

[Mark Gambo]

I whipped up a quick example, if you have any question just let me know. BTW you have to have CRIX installed on your machine in order for this to work.

[Nitesh]

Wow, Thanks alot Mark. Your assistance is really appreciated. Looking at your example I have managed to create a report of my own. I am trying to generate team lists for a school for matches they participate in.

So far I have managed to generate the report listing all the pupils names and surnames. The thing is, how can I display fields such as the Venue and the Opposition. I have a SQL query that retrieves all the names and surnames of pupils for a specific match. How do I bring in the Venue and Oppositions fields for example.

Thanks again.

[Mark Gambo]

Do the two tables have a common field? If so, you would need to join them and then update the datsource of the report and add the new fields.

[hondaboy24]

hi guys i'm kinda new with crystal reports.. is CRIX an ocx? if it is where can i get one? i'm using vb6 and sql server 2000