Extracting data from a non-linked Table

[Theadmans]

I am using Crystal V8.0 connecting to SQL Server Tables.

I am amending an existing Report that already uses various linked tables (all set up in the Visual Linking Expert).

I now need to extract data from a new table that does not in any way link to the existing tables. The new table will only ever contain one row of data - so I do not really need a Join anyway.

My new table will link to another table which contains an Image Field which I want to put on the report. I had thought of creating an SQL Expression Field but I do not seem to be able use this with the Image Type field in my table.

Can anyone tell me how I can do this please.

 

[MrBillSC]

One approach would be to place the unlinked table(s) in an unlinked subreport and place the subreport in the appropriate section of the main report.

MrBill

 

[mirogak]

Not too long ago, I had a similar issue.

I created a sub-report which pulled only off of the unlinked table. I placed that sub-report in another main report which required some information from that sub-report, which I passed through shared variables.

If you do take that route, make sure your sub-report is called in the page header or report header section of the main report, as it needs to be executed first, then the shared variables would have some actual values to be passed on to your main report.

 

[synapsevampire]

The subreport is a logical way to go, you need to execute a seperate query anyway...

-k

 

[Theadmans]

Thanks guys - the subreport approach appears to work - cheers.