Dynamic Captions in Reports

Hi,
We are evaluating using SQL Server Reporting Services in our next
product.
One of the requirements is for captions in our application to be
customisable by the customer, with the captions on web pages and
reports always matching.
I assume that the best approach would be to have a table which holds
table names, field names and captions and to look up this table
whenever we need the caption for a particular field.
Presumably, this could be done via a stored procedure - is it viable
to do this from reporting services?
Any other thoughts on how best to achieve this?
Regards.
Matt.you could do that and use the Drop down controls to display parameters for
the users to pick from. the selected values can be displayed whereever you
want in the report.
you can use stored procs, views or straight sql and you can pull the values
from a wide variety of sources
<matt.mcqueen@.shesoftware.com> wrote in message
news:1185352426.646729.180800@.q75g2000hsh.googlegroups.com...
> Hi,
> We are evaluating using SQL Server Reporting Services in our next
> product.
> One of the requirements is for captions in our application to be
> customisable by the customer, with the captions on web pages and
> reports always matching.
> I assume that the best approach would be to have a table which holds
> table names, field names and captions and to look up this table
> whenever we need the caption for a particular field.
> Presumably, this could be done via a stored procedure - is it viable
> to do this from reporting services?
> Any other thoughts on how best to achieve this?
> Regards.
> Matt.
>