Multiple data sources on a report

[benlinkknilneb]

Hey all,

I'm writing a VB app that uses Crystal to display reports based on databases in our plant. My problem is this:

I have a report that returns results from one department. However, I would like to have several pieces of information on the report that are not logically related... that is, I can't link the tables by any field, even though they apply to the same department in the plant. I don't WANT to link them. Is there a way I can force Crystal to ignore relational database-type stuff and just print two unrelated data values onto a single report?

Ben

 

[crystalreporting]

Subreports.

 

[benlinkknilneb]

Thanks for the quick response.

I added the subreport to my main report... The main report displays its information just fine, but the subreport only gives me the column headings. It appears that it has no data. What can I do?

Ben

 

[crystalreporting]

Open up your subreport - comment out any record or group selection criteria - refresh the subreport (not the main report). If you get data, the selection criteria is wrong, if you get no data, the table is empty, or your links are incorrect, or......

 

[benlinkknilneb]

Thanks for your help, but I'm still not getting this to work...

This particular part of the report pulls the data straight from the table; no selection criteria is specified in the subreport. I checked the data that's being sent out of the program... there is data in the table, and I had no trouble setting up the data link (I'm using ADO.net and writing the Schema to a temporary file, which the report uses to set things up; it's worked everywhere else). Any more ideas?

Ben

 

[benlinkknilneb]

Hey, thanks for pointing me in the right direction... I found my mistake, and it's working fine now!

Ben