Using a non-linked Table

[PBS2]

I have to amend an existing report which works from 4 linked tables. I now need to include data from a fifth table which contains only 1 row. This fifth table contains no links to any of the other tables. I can add this table to report and create formulas, however, when I run the report the fields from the new table are blank. I guess this is because the fifth table is not linked.

How can I overcome this problem?

 

[synapsevampire]

You'll probably want to use a subreport for the 5th table.

Sicne you didn't bother to post anything about your software version/edition, nor the database being used, you shouldn't expect a technical nor detailed answer.

If this data is supposed to be included with the current data, then you'll likely need a UNION ALL query as the datasource, either by using a View or SP on the database, or by modifying the SQL being passed to the database.

This is dependent upon the database being used and the version of your software.

-k

 

[PBS2]

Yes sorry I am using Crystal V.8 for this particular report. I have tried accessing my data by setting up an SQL expression but I get the error:-

"No rowset was returned"

I recently managed to setup an SQL expression on a different Report in Crystal V.10. Can anyone tell me what I am doing wrong.

The data I want to extract is not linked to the other tables. I want to create a formula which uses the values in the single row of the fifth table and every row of the existing main table on the report.

 

[dgillz]

I agree with SV, a subreport is the way to go. Use Shared Variables to pass values from the subreport to the main report, then write formulas to do whatever is required with this value once he subreport is in place.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz