Displaying values from a non-linked table

[jbhsuman]

In my previous version of CR 8, I was able to display field information from a table that is not linked to other tables in the report. For example, I have one table that holds the client informaion and does not link to any other table in the database. I want to be able to display the clients name in the report header without hard coding it into the report via a text field.

When I switched to CR 9 I can see the un-linked table, select the field and insert it into the report. However, at print time, the field information is blank. Any idea what I may be doing wrong?

 

[synapsevampire]

Hard to say, but I'd check what the SQL was generating in the original and the difference now, perhaps a cross join? This may have thrown other things off.

Anyway, if you need a sepaate data source, use a subreport.

-k