extra query for 1 field

[johnugly]

Hello, is it possible in CR 9 to do a call to the database for just one field (this field is in a subreport), or do you need to get up all your data by query when the report loads?
thanks in advance.

 

[synapsevampire]

Not quite clear to me, try posting technical information.

Perhaps you're asking if you can have 1 field in the report use a different select statement than the rest of the report? Are there multiple rows to be returned to this field?

This is generally not supported within the same report, but if the cost is too high to return that field along with the other data using a SQL Expression to create a suquery (generally subreports are bad ideas unless they aren't linked as they are slow) or some such, create another subreport before that subreport and use shared variables to pass the value.

I'd need meaningful information to advise you further:

Database/connectivity used
Example data
Expected output

-k