HELP format Page Heading

I dont usually use page headers for this reason. I usually put my headings
within the body of the report however it doesnt seem to be working properly
with this matrix so I am going to use a true page header and I am having
trouble because I need to reference fields from the database in the header.
Here is my expression:
=eSLRReporting.MultiLanguage.TranslateText( Parameters!Language.Value
,"Title") & Parameters!MetricCode.Label & vbcrlf &
eSLRReporting.MultiLanguage.TranslateText( Parameters!Language.Value
,"ReportPeriod") & format(CDate(Parameters!StartDate.Value), "MM-dd-yyyy")
& " - " & format(First (Fields!MAXDATE.Value, "GR01_10"),"MM-dd-yyyy")
It is complaining about the MAXDATE value however I need that value and it
comes from the query result. There is probably a way around this ... I just
dont deal with headers so I have never encountered this "rule" of fields
cannot be used in headers or footers.You can't directly put values from a dataset into the page header or footer,
but you can use report paramters to do this.
Create a report parameters for each query field that you want to put in the
header. Setup the parameter to be populated by the appriopriate field.
Then use textboxes that get their value form an expression to put the data
in the header.
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:E0813CA6-F8FA-4EBA-80B6-EA86C613DB98@.microsoft.com...
>I dont usually use page headers for this reason. I usually put my headings
> within the body of the report however it doesnt seem to be working
> properly
> with this matrix so I am going to use a true page header and I am having
> trouble because I need to reference fields from the database in the
> header.
> Here is my expression:
> =eSLRReporting.MultiLanguage.TranslateText( Parameters!Language.Value
> ,"Title") & Parameters!MetricCode.Label & vbcrlf &
> eSLRReporting.MultiLanguage.TranslateText( Parameters!Language.Value
> ,"ReportPeriod") & format(CDate(Parameters!StartDate.Value),
> "MM-dd-yyyy")
> & " - " & format(First (Fields!MAXDATE.Value, "GR01_10"),"MM-dd-yyyy")
>
> It is complaining about the MAXDATE value however I need that value and it
> comes from the query result. There is probably a way around this ... I
> just
> dont deal with headers so I have never encountered this "rule" of fields
> cannot be used in headers or footers.sql

help- expressions appearing on second page?

i have a list which is hidden at the top of my body and then some text boxes afterwards...this should all fit on the first page, but as soon as one of my textboxes has an expression the rest of the data skips to the second page

Right click the list and select properties. If "insert a page break before this list" or "insert a page break after this list" are checked, then uncheck them.

|||

both are unchecked, it is breaking at any textbox containing an expression....so the first page has the first few textboxes that only have text

|||

please i need help with this, why do text boxes with expressions appear on the second page, but only the ones after my list, if i put one before the list it will display on the first page

help

i have a list which is hidden at the top of my body and then some text boxes afterwards...this should all fit on the first page, but as soon as one of my textboxes has an expression the rest of the data skips to the second page

Right click the list and select properties. If "insert a page break before this list" or "insert a page break after this list" are checked, then uncheck them.

|||

both are unchecked, it is breaking at any textbox containing an expression....so the first page has the first few textboxes that only have text

|||

please i need help with this, why do text boxes with expressions appear on the second page, but only the ones after my list, if i put one before the list it will display on the first page

help

id name
1 Noor
1 Ali
2 Hamsan
2 Guy
I want the data like this.
1 Noor Ali
2 Hamsan Guy
Can any body tell me
thanks
NOOR
Hi Noor,
Look into the below solution, this will fail if you have more than 2 records
for 1 id. If you have more than 2 id's then write a Cursor to obtain the
result.
I feel that this may not be possible only with a select statement.
set nocount on
CREATE TABLE #T (i int,a varchar(50))
INSERT INTO #T VALUES (1,'Hari')
INSERT INTO #T VALUES (1,'Prasad')
INSERT INTO #T VALUES (2,'SQL')
INSERT INTO #T VALUES (2,'DBA')
CREATE TABLE #T1 (i int,a varchar(1000))
--select * from #T t1 where a in (select top 1 t2.a from #T t2 where t1.i =
t2.i)
insert into #T1 select * from #T t1 where a in (select top 1 t2.a from
#T t2 where t1.i = t2.i)
update #T1 set a = t4.a + t3.a from #T1 t4, #T t3 where t4.i = t3.i
select * from #T1
drop table #T1
drop table #T
Thanks
Hari
MCDBA
"Noorali Issani" <naissani@.softhome.net> wrote in message
news:OWjwVmwIEHA.1608@.TK2MSFTNGP11.phx.gbl...
> id name
> 1 Noor
> 1 Ali
> 2 Hamsan
> 2 Guy
>
> I want the data like this.
>
> 1 Noor Ali
> 2 Hamsan Guy
> Can any body tell me
> thanks
> NOOR
>
|||Thanks Hari, can you tell me how I use your solution in Mysql b/c in mysql
we can't use inner query.
Thanks
Noor
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23IXv%23K6IEHA.1412@.TK2MSFTNGP12.phx.gbl...
> Hi Noor,
> Look into the below solution, this will fail if you have more than 2
records
> for 1 id. If you have more than 2 id's then write a Cursor to obtain the
> result.
> I feel that this may not be possible only with a select statement.
> set nocount on
> CREATE TABLE #T (i int,a varchar(50))
> INSERT INTO #T VALUES (1,'Hari')
> INSERT INTO #T VALUES (1,'Prasad')
> INSERT INTO #T VALUES (2,'SQL')
> INSERT INTO #T VALUES (2,'DBA')
> CREATE TABLE #T1 (i int,a varchar(1000))
> --select * from #T t1 where a in (select top 1 t2.a from #T t2 where t1.i
=
> t2.i)
> insert into #T1 select * from #T t1 where a in (select top 1 t2.a from
> #T t2 where t1.i = t2.i)
> update #T1 set a = t4.a + t3.a from #T1 t4, #T t3 where t4.i = t3.i
> select * from #T1
> drop table #T1
> drop table #T
> Thanks
> Hari
> MCDBA
>
> "Noorali Issani" <naissani@.softhome.net> wrote in message
> news:OWjwVmwIEHA.1608@.TK2MSFTNGP11.phx.gbl...
>