[RESOLVED] New To Crystal Report: PLease Help

[Andy0000]

I haf created a simple data base connection in which I am fetching data from 3 different table. The Problem is when I am generating the report, data from only the first table is coming. When in Design mode, I right click all the table field and selecting "Browse data" option, its showing all the fields. But at the time of report generation its showing data only from 1st field, rest field if its numeric then showing '0' and if its string, its showing ''(null). Please help guys. Thanks in advance

[Andy0000]

I also want to ask that for displaying data from multiple table is it necessary to have a link between tables. Can I not display data from 2 different table, in which nothing is common.

[JaganEllis]

re first post, are you actually using any of the fields from the other two tables? How have you linked them together in the database expert? i.e. what's the SQL that Crystal generates? (Database menu, Show SQL Query...)

re second post, if they have nothing in common then they should not be in the same report 'cos you can't link them; but you could, for example, use one table in the report and the other table in a subreport in the report footer.