Can I place a selected field inside a sqlplus report title?

[SteveBurch]

<br>&nbsp;&nbsp;&nbsp;Hi,<br><br>&nbsp;&nbsp;&nbsp;Does anyone know if the following is possible - I'm wanting to have a field derived from a select statement incorporated into a sqlplus report title (ttitle).<br>&nbsp;&nbsp;&nbsp;Eg. &quot;Shortfall Report for Period Starting dd-mmm-yyyy&quot;,<br>where the 'dd-mmm-yyyy' field is stored on a table (in this instance a one-record table).<br>&nbsp;&nbsp;&nbsp;I know you can have a variable included in the title, but even using 'define' there doesn't seem to be a way of getting something from a select statement into a defined variable.<br>&nbsp;&nbsp;&nbsp;If anyone can help out it would be much appreciated.<br>&nbsp;&nbsp;&nbsp;Thanks in advance,<br><br>&nbsp;&nbsp;&nbsp;Steve Burch

 

[MalcolmW]

Since you only have one record in the table, the type of join you make to the rest of your data is not relevant.<br>SELECT &quot;Shortfall Report for Period Starting &quot; CONCAT CAST(datetable.yourdate, char(12)), othertable.*<br>FROM datetable, othertable<br>That would get you the period date field returned with your data, but I'm not sure if this is what you wanted.<br> <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>