Data fields are not allowed in the Page Header section

How can I build the page header (Sales for John Smith) where John Smith is
returned in the query results? Data fields are not allowed in the Page
Header section.
All responses greatly appreciated.
--
Any and all contributions are greatly appreciated ...
Regards TJYou can use read-only parameter with default value from query (assuming that
you render separate instance of report for every person)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"TJ" <nospam@.nowhere.com> wrote in message
news:O2Mt1aNoEHA.3564@.tk2msftngp13.phx.gbl...
> How can I build the page header (Sales for John Smith) where John Smith is
> returned in the query results? Data fields are not allowed in the Page
> Header section.
> All responses greatly appreciated.
> --
> Any and all contributions are greatly appreciated ...
> Regards TJ
>
>

Data Driven Subscription multi-line email content

I am trying to set up a data driven subscription where one of the fields
returned from the query is sent as the content of the email.
This works fine for a one line email by selecting that column in the
Comment field of the delivery extension screen but I need to create a
multi-line email.
I have tried storing the field with CHAR(13) & CHAR(10) separators in the
table but it still displays on one line when RS sends the email.
Does anyone know if this is possible and how I can achieve it ?The comment can be HTML. So make the comment use html to render on multiple
lines.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"magicboy" <magicboy@.discussions.microsoft.com> wrote in message
news:48673C18-06E1-47CA-A8C7-F6B691C404A4@.microsoft.com...
>I am trying to set up a data driven subscription where one of the fields
> returned from the query is sent as the content of the email.
> This works fine for a one line email by selecting that column in the
> Comment field of the delivery extension screen but I need to create a
> multi-line email.
> I have tried storing the field with CHAR(13) & CHAR(10) separators in the
> table but it still displays on one line when RS sends the email.
> Does anyone know if this is possible and how I can achieve it ?|||This works fine, thanks
"Daniel Reib [MSFT]" wrote:
> The comment can be HTML. So make the comment use html to render on multiple
> lines.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "magicboy" <magicboy@.discussions.microsoft.com> wrote in message
> news:48673C18-06E1-47CA-A8C7-F6B691C404A4@.microsoft.com...
> >I am trying to set up a data driven subscription where one of the fields
> > returned from the query is sent as the content of the email.
> > This works fine for a one line email by selecting that column in the
> > Comment field of the delivery extension screen but I need to create a
> > multi-line email.
> > I have tried storing the field with CHAR(13) & CHAR(10) separators in the
> > table but it still displays on one line when RS sends the email.
> > Does anyone know if this is possible and how I can achieve it ?
>
>