Hello!
I am posting this problem again. I have gotten somebody's help with the
right solution but I have one more case to work on. I would appreciate
your time and help on this.
create table #temp
(ID int, Cust varchar(80))
insert into #temp values(23, 'Name: abcd DBX: abcdefgh Addr1: 1234')
insert into #temp values(27, 'Name: xyz DBX: xyz Addr1: 9999')
insert into #temp values(25, 'Name: lmn DBX: opqr Addr1: 1234')
-- Case 1: Put CENSORED between DBX: and Addr1: in the Cust column...IT
WORKS!!!
select Col1 = Left(Cust, charindex('DBX:', Cust) + 3) +
replace(substring(Cust, charindex('DBX:', Cust) + 4, LEN(Cust)),
substring(Cust, charindex('DBX:', Cust) + 4,
charindex('Addr1:', Cust) - charindex('DBX:', Cust)-4), ' CENSORED ')
from #temp
-- Case 2: Put CLASSIFIED between Name: and DBX: in the Cust column..IT
DOES NOT WORK for 'xyz' case bc 'xyz is in two places. I need it to
replace only one time which is in bw Name: and DBX: and leave the other
one untouched. how do I do that?
select Col2 = replace(Cust, substring(Cust, charindex(':', Cust)+2,
charindex('DBX:', Cust)- charindex(':', Cust)-2), ' CLASSIFIED ')
from #temp
My SQL for Col2 gives me this:
Name: CLASSIFIED DBX: abcdefgh Addr1: 1234
Name: CLASSIFIED DBX: CLASSIFIED Addr1: 9999
Name: CLASSIFIED DBX: opqr Addr1: 1234
And I want this..
Name: CLASSIFIED DBX: abcdefgh Addr1: 1234
Name: CLASSIFIED DBX: xyz Addr1: 9999
Name: CLASSIFIED DBX: opqr Addr1: 1234
Thanks for your help!
*** Sent via Developersdex http://www.examnotes.net ***Test,
Try:
SELECT STUFF(CUST,1,CHARINDEX(' ',CUST,CHARINDEX(' ',CUST)+1),'CLASSIFIED ')
FROM #TEMP
HTH
Jerry
"Test Test" <farooqhs_2000@.yahoo.com> wrote in message
news:%23irrn3l1FHA.1852@.TK2MSFTNGP10.phx.gbl...
> Hello!
> I am posting this problem again. I have gotten somebody's help with the
> right solution but I have one more case to work on. I would appreciate
> your time and help on this.
> create table #temp
> (ID int, Cust varchar(80))
> insert into #temp values(23, 'Name: abcd DBX: abcdefgh Addr1: 1234')
> insert into #temp values(27, 'Name: xyz DBX: xyz Addr1: 9999')
> insert into #temp values(25, 'Name: lmn DBX: opqr Addr1: 1234')
>
> -- Case 1: Put CENSORED between DBX: and Addr1: in the Cust column...IT
> WORKS!!!
> select Col1 = Left(Cust, charindex('DBX:', Cust) + 3) +
> replace(substring(Cust, charindex('DBX:', Cust) + 4, LEN(Cust)),
> substring(Cust, charindex('DBX:', Cust) + 4,
> charindex('Addr1:', Cust) - charindex('DBX:', Cust)-4), ' CENSORED ')
> from #temp
> -- Case 2: Put CLASSIFIED between Name: and DBX: in the Cust column..IT
> DOES NOT WORK for 'xyz' case bc 'xyz is in two places. I need it to
> replace only one time which is in bw Name: and DBX: and leave the other
> one untouched. how do I do that?
> select Col2 = replace(Cust, substring(Cust, charindex(':', Cust)+2,
> charindex('DBX:', Cust)- charindex(':', Cust)-2), ' CLASSIFIED ')
> from #temp
> My SQL for Col2 gives me this:
> Name: CLASSIFIED DBX: abcdefgh Addr1: 1234
> Name: CLASSIFIED DBX: CLASSIFIED Addr1: 9999
> Name: CLASSIFIED DBX: opqr Addr1: 1234
> And I want this..
> Name: CLASSIFIED DBX: abcdefgh Addr1: 1234
> Name: CLASSIFIED DBX: xyz Addr1: 9999
> Name: CLASSIFIED DBX: opqr Addr1: 1234
> Thanks for your help!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Thanks Jerry. It is not perfectly working:
1. Your SQL is also deleting 'Name:' which I want to keep it. But that
can be fixed by adding 'Name: ' in the SQL i.e.
SELECT 'Name: ' + STUFF(CUST,1,CHARINDEX(' ',CUST,CHARINDEX('
',CUST)+1),'CLASSIFIED ')
FROM #TEMP
2. The main issue is there can a space in the name field (it will not
always be a continuation). So, the whole name needs to be replaced with
CLASSIFIED. Your SQL is not currently handling this.
Example: Insert these two records in the #temp table:
insert into #temp values(25, 'Name: xxx yyy DBX: xxx yyy Addr1: 1234')
insert into #temp values(25, 'Name: ijk 123 DBX: aaa Addr1: 1234')
SELECT 'Name: ' + STUFF(CUST,1,CHARINDEX(' ',CUST,CHARINDEX('
',CUST)+1),'CLASSIFIED ')
FROM #TEMP
The result is:
Name: CLASSIFIED yyy DBX: xxx yyy Addr1: 1234
Name: CLASSIFIED 123 DBX: aaa Addr1: 1234
The corerct result would be:
Name: CLASSIFIED DBX: xxx yyy Addr1: 1234
Name: CLASSIFIED DBX: aaa Addr1: 1234
*** Sent via Developersdex http://www.examnotes.net ***|||Test,
Mod the code to use the : after DBX (then count back 3) for the end number
and change the start postion in the STUFF statment to ensure Name: is
retained. I just had to reboot my machine so I lost all of the code i had
for this. Let me know if you don't get it working and I'll redo and post
the solution.
HTH
Jerry
"Test Test" <farooqhs_2000@.yahoo.com> wrote in message
news:uOj4Pom1FHA.2792@.tk2msftngp13.phx.gbl...
> Thanks Jerry. It is not perfectly working:
> 1. Your SQL is also deleting 'Name:' which I want to keep it. But that
> can be fixed by adding 'Name: ' in the SQL i.e.
> SELECT 'Name: ' + STUFF(CUST,1,CHARINDEX(' ',CUST,CHARINDEX('
> ',CUST)+1),'CLASSIFIED ')
> FROM #TEMP
> 2. The main issue is there can a space in the name field (it will not
> always be a continuation). So, the whole name needs to be replaced with
> CLASSIFIED. Your SQL is not currently handling this.
> Example: Insert these two records in the #temp table:
> insert into #temp values(25, 'Name: xxx yyy DBX: xxx yyy Addr1: 1234')
> insert into #temp values(25, 'Name: ijk 123 DBX: aaa Addr1: 1234')
> SELECT 'Name: ' + STUFF(CUST,1,CHARINDEX(' ',CUST,CHARINDEX('
> ',CUST)+1),'CLASSIFIED ')
> FROM #TEMP
> The result is:
> Name: CLASSIFIED yyy DBX: xxx yyy Addr1: 1234
> Name: CLASSIFIED 123 DBX: aaa Addr1: 1234
> The corerct result would be:
> Name: CLASSIFIED DBX: xxx yyy Addr1: 1234
> Name: CLASSIFIED DBX: aaa Addr1: 1234
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Jerry, Thanks for all your help! I think I'll make it work.
*** Sent via Developersdex http://www.examnotes.net ***|||Try this out...
select
substring(Name,1,patindex('%DBX:%',Name)
-1)+
replace(substring(Name,patindex('%DBX:%'
,Name),len(Name)),
substring(Name,patindex('%DBX:%',Name)+5
,(charindex('Addr1:',Name,1)-patinde
x('%DBX:%',Name)-6)),
'APPLE')
as Output
from #temp
Regards
sudarshan
"Test Test" wrote:
> Hello!
> I am posting this problem again. I have gotten somebody's help with the
> right solution but I have one more case to work on. I would appreciate
> your time and help on this.
> create table #temp
> (ID int, Cust varchar(80))
> insert into #temp values(23, 'Name: abcd DBX: abcdefgh Addr1: 1234')
> insert into #temp values(27, 'Name: xyz DBX: xyz Addr1: 9999')
> insert into #temp values(25, 'Name: lmn DBX: opqr Addr1: 1234')
>
> -- Case 1: Put CENSORED between DBX: and Addr1: in the Cust column...IT
> WORKS!!!
> select Col1 = Left(Cust, charindex('DBX:', Cust) + 3) +
> replace(substring(Cust, charindex('DBX:', Cust) + 4, LEN(Cust)),
> substring(Cust, charindex('DBX:', Cust) + 4,
> charindex('Addr1:', Cust) - charindex('DBX:', Cust)-4), ' CENSORED ')
> from #temp
> -- Case 2: Put CLASSIFIED between Name: and DBX: in the Cust column..IT
> DOES NOT WORK for 'xyz' case bc 'xyz is in two places. I need it to
> replace only one time which is in bw Name: and DBX: and leave the other
> one untouched. how do I do that?
> select Col2 = replace(Cust, substring(Cust, charindex(':', Cust)+2,
> charindex('DBX:', Cust)- charindex(':', Cust)-2), ' CLASSIFIED ')
> from #temp
> My SQL for Col2 gives me this:
> Name: CLASSIFIED DBX: abcdefgh Addr1: 1234
> Name: CLASSIFIED DBX: CLASSIFIED Addr1: 9999
> Name: CLASSIFIED DBX: opqr Addr1: 1234
> And I want this..
> Name: CLASSIFIED DBX: abcdefgh Addr1: 1234
> Name: CLASSIFIED DBX: xyz Addr1: 9999
> Name: CLASSIFIED DBX: opqr Addr1: 1234
> Thanks for your help!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>
Showing posts with label solution. Show all posts
Showing posts with label solution. Show all posts
Friday, March 23, 2012
Replace LinkedServer with Service Broker
Hi,
We currently have an application that primarily sits on SQL server and needs to access some legacy data in a DB2 database. The solution we are using is to use a linked server between the two servers. The problem with this is that complex queries occasionally cause the driver to fetch a complete table and filter that table locally. I wondered whether service broker (which I have never used) could allow me to access the DB2 database using MQSeries and thus speed up the application as our ODBC calls have low priority on our mainframe.
Thanks and sorry if this sounds a stupid use of service broker.
Service Broker supports only its own protocol so it cannot communicate with DB2 or MQSeries. You must have Sql on both ends to use Service Broker.
Rick Negrin
Program Manager
Sql Server Service BrokersqlWednesday, March 21, 2012
Replace Access with a .NET front end and SQL Backend solution.
My company currently has about 20-25 Ms Access Database that they want to
replace the FE with .net and the BE on SQL.
Enterprise Manager is a tool that exists only in SQL 2000, and I assume
- and hope! - that you will implement your new solution on SQL 2005. The
tool in SQL 2005 is SQL Server Management Studio which replaces both
Enterprise Manager and Query Analyzer. As long as you work with SQL 2000,
QA should be your main tool, because it is from this tool you most easily
can run queries. EM may look a little like Access, so you may feel com-
fortable with that. However, SQL Server is very different from Access,
so best is to use a tool that forces you to unlearn a lot things.
Yes, there is an upsizing wizard. And the word that I have from people
who have worked extensively with both Access and SQL Server is that you
should stay away from it. Access and SQL Server are very different and
build on different mindset. You should more or less redesign your
application for SQL Server and .Net. This may seem like a lot more work
that you had expected, but it is likely to pay off in the long run with
lower maintenance costs, if you do it right from the start.
>
>Enterprise Manager is a tool that exists only in SQL 2000, and I assume
>- and hope! - that you will implement your new solution on SQL 2005. The
>tool in SQL 2005 is SQL Server Management Studio which replaces both
>Enterprise Manager and Query Analyzer. As long as you work with SQL 2000,
>QA should be your main tool, because it is from this tool you most easily
>can run queries. EM may look a little like Access, so you may feel com-
>fortable with that. However, SQL Server is very different from Access,
>so best is to use a tool that forces you to unlearn a lot things.
>
>
>Yes, there is an upsizing wizard. And the word that I have from people
>who have worked extensively with both Access and SQL Server is that you
>should stay away from it. Access and SQL Server are very different and
>build on different mindset. You should more or less redesign your
>application for SQL Server and .Net. This may seem like a lot more work
>that you had expected, but it is likely to pay off in the long run with
>lower maintenance costs, if you do it right from the start.
>
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...eneral/200607/1|||Anns via SQLMonster.com (u22580@.uwe) writes:
You can download the Evaluation Edition of SQL 2005 from
http://www.microsoft.com/downloads/...FA7F-C094-49A2-
A050-2D07993566EC&displaylang=en.
Enterprise Manager != Enterprise Edition. Enterprise Manager is available
in all editions of SQL 2000, except for the desktop version MSDE. The
difference between the editions lies in what features that are available,
and what purpose the edition is licensed for.
It's not completely different, but there are also considerable differences.
In the end, you will only do yourself a disservice by learning a tool
that you will not work with.
Maybe. As I said, I think you should consider a major redesign, at
least in places where you have some quirks in Access, or in places
where SQL Server offers better solutions. Then again, even if you go
for a new schema, it may of course be a good idea bring over the
Access databases to SQL Server, so that you can work with them locally.
And for that end SQL Server Integration Services (which is the successor
to DTS in SQL 2005) may be a good choice. (I've never worked with
neither DTS nor SSIS, so I don't really know.)
Since you are migrating from Access to .Net, I would assume that you
more or less rewrite the front-end code entirely, but you should ask in a
..Net forum about that.
replace the FE with .net and the BE on SQL.
This will be done using Visual Studio 2005. Once the FE is converted to .net
and the BE is SQL they all will be accessed through our intranet (sharepoint).
I work in Ms Access and intermediate at VBA and just learing SQL through the
ENTERPRISE MANAGER SCREEN.
I am just now looking at what Visual Studio 2005 is, but can some one tell me
how this will all connect?
What is the typical route for this process?
Ms access to SQL - upsizing wizard or SQL importing???
Ms Access FE to .net - summarize how this is done in visual studio (user face
rebuilt) then placed on sharepoint?
Can anyone sum this up?
--
Message posted via http://www.sqlmonster.comAnns via SQLMonster.com (u22580@.uwe) writes:
Quote:
Originally Posted by
I work in Ms Access and intermediate at VBA and just learing SQL through
the ENTERPRISE MANAGER SCREEN.
Enterprise Manager is a tool that exists only in SQL 2000, and I assume
- and hope! - that you will implement your new solution on SQL 2005. The
tool in SQL 2005 is SQL Server Management Studio which replaces both
Enterprise Manager and Query Analyzer. As long as you work with SQL 2000,
QA should be your main tool, because it is from this tool you most easily
can run queries. EM may look a little like Access, so you may feel com-
fortable with that. However, SQL Server is very different from Access,
so best is to use a tool that forces you to unlearn a lot things.
Quote:
Originally Posted by
I am just now looking at what Visual Studio 2005 is, but can some one
tell me how this will all connect?
>
What is the typical route for this process?
>
>
Ms access to SQL - upsizing wizard or SQL importing???
Yes, there is an upsizing wizard. And the word that I have from people
who have worked extensively with both Access and SQL Server is that you
should stay away from it. Access and SQL Server are very different and
build on different mindset. You should more or less redesign your
application for SQL Server and .Net. This may seem like a lot more work
that you had expected, but it is likely to pay off in the long run with
lower maintenance costs, if you do it right from the start.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||SQL 2005 - SQL Server Managment Studio, thank you, when I said I was
currently learning I am learning unfortunately on 2000 b/c that is the study
material I bought and cannot afford to upgrade right now.
You are right with the SQL 2000 Enterprise edition, it is so user friendly
and that edition is all I know and still learning at best with that.
Yes, my company will be doing this on 2005 but for now, my learning is on
2000.
You see I work in a another department besides IT and between that job/baby
and small buisness, I am trying to get my DBA (2000) certification, I would
like the upgrade (2005) but do not have the funds to upgrade.
I have an opportunity to help with this conversion process and learn in
between, but I am trying to get a better grasp of this before sinking.
Does the 2005 Managment Studio look alot like Enterprise manager?
Answer:
Ms Access to SQL - I am assuming your answer would then be exporting/dts tool
from SQL to pull over all these db's?
Answer:
Erland, tell me once the db's are pull over to SQL, now I have Visual Studio
2005 software open - what steps are taken in this software to rebuilt the
user faces and then how is it then put on SHAREPOINT????
ANSWER:
Erland Sommarskog wrote:
Quote:
Originally Posted by
Quote:
Originally Posted by
>I work in Ms Access and intermediate at VBA and just learing SQL through
>the ENTERPRISE MANAGER SCREEN.
>
>Enterprise Manager is a tool that exists only in SQL 2000, and I assume
>- and hope! - that you will implement your new solution on SQL 2005. The
>tool in SQL 2005 is SQL Server Management Studio which replaces both
>Enterprise Manager and Query Analyzer. As long as you work with SQL 2000,
>QA should be your main tool, because it is from this tool you most easily
>can run queries. EM may look a little like Access, so you may feel com-
>fortable with that. However, SQL Server is very different from Access,
>so best is to use a tool that forces you to unlearn a lot things.
>
Quote:
Originally Posted by
>I am just now looking at what Visual Studio 2005 is, but can some one
>tell me how this will all connect?
>>
>What is the typical route for this process?
>>
>Ms access to SQL - upsizing wizard or SQL importing???
>
>Yes, there is an upsizing wizard. And the word that I have from people
>who have worked extensively with both Access and SQL Server is that you
>should stay away from it. Access and SQL Server are very different and
>build on different mindset. You should more or less redesign your
>application for SQL Server and .Net. This may seem like a lot more work
>that you had expected, but it is likely to pay off in the long run with
>lower maintenance costs, if you do it right from the start.
>
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...eneral/200607/1|||Anns via SQLMonster.com (u22580@.uwe) writes:
Quote:
Originally Posted by
SQL 2005 - SQL Server Managment Studio, thank you, when I said I was
currently learning I am learning unfortunately on 2000 b/c that is the
study material I bought and cannot afford to upgrade right now.
You can download the Evaluation Edition of SQL 2005 from
http://www.microsoft.com/downloads/...FA7F-C094-49A2-
A050-2D07993566EC&displaylang=en.
Even if your study material only covers SQL 2000, I still think you
should work with SQL 2005.
Quote:
Originally Posted by
You are right with the SQL 2000 Enterprise edition, it is so user friendly
and that edition is all I know and still learning at best with that.
Enterprise Manager != Enterprise Edition. Enterprise Manager is available
in all editions of SQL 2000, except for the desktop version MSDE. The
difference between the editions lies in what features that are available,
and what purpose the edition is licensed for.
Quote:
Originally Posted by
Does the 2005 Managment Studio look alot like Enterprise manager?
It's not completely different, but there are also considerable differences.
In the end, you will only do yourself a disservice by learning a tool
that you will not work with.
But Enterprise Manager and SQL Server Management Studio are just the
tools. These are not what you should focus your learning on. You should
learn how to create databases, tables and indexes, and how to write
queries. You may think that you know SQL from Access, but as I said,
there are considerable differences. In general, SQL Server offers much
more powerful constructs, but there also features from Access that
are completely missing. A classic example is dynamic crosstabs.
Quote:
Originally Posted by
Ms Access to SQL - I am assuming your answer would then be exporting/dts
tool from SQL to pull over all these db's?
Maybe. As I said, I think you should consider a major redesign, at
least in places where you have some quirks in Access, or in places
where SQL Server offers better solutions. Then again, even if you go
for a new schema, it may of course be a good idea bring over the
Access databases to SQL Server, so that you can work with them locally.
And for that end SQL Server Integration Services (which is the successor
to DTS in SQL 2005) may be a good choice. (I've never worked with
neither DTS nor SSIS, so I don't really know.)
Quote:
Originally Posted by
Erland, tell me once the db's are pull over to SQL, now I have Visual
Studio 2005 software open - what steps are taken in this software to
rebuilt the user faces and then how is it then put on
SHAREPOINT????
Since you are migrating from Access to .Net, I would assume that you
more or less rewrite the front-end code entirely, but you should ask in a
..Net forum about that.
Sharepoint? I know there is a product with that name, but I have very
little idea what it's good for. So I cannot answer that question.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||A great walk thru / how to on the MS Access to SQL Server 2005 was
blogged. I tried it and made my life much easier.
http://cfpayne.wordpress.com/2006/0...ql-server-2005/
Precia
Anns via SQLMonster.com wrote:
Quote:
Originally Posted by
My company currently has about 20-25 Ms Access Database that they want to
replace the FE with .net and the BE on SQL.
>
>
This will be done using Visual Studio 2005. Once the FE is converted to .net
and the BE is SQL they all will be accessed through our intranet (sharepoint).
>
>
I work in Ms Access and intermediate at VBA and just learing SQL through the
ENTERPRISE MANAGER SCREEN.
I am just now looking at what Visual Studio 2005 is, but can some one tell me
how this will all connect?
>
What is the typical route for this process?
>
>
Ms access to SQL - upsizing wizard or SQL importing???
>
>
>
Ms Access FE to .net - summarize how this is done in visual studio (user face
rebuilt) then placed on sharepoint?
>
>
Can anyone sum this up?
>
--
Message posted via http://www.sqlmonster.com
Friday, March 9, 2012
Repeat title on every page
Hello all,
I'm trying to find solution to show sub-report title on every page of that
subreport.
What I have in the subreport is the text containing title and two tables
underneath.
The first table is a summary table and will only be shown on the first page.
The second table goes over few pages.
What I need is to get the title (which is above he first table) to show on
every page of that subreport, when exported to PDF.Instead its only shown on
the first page.
I have tried many things, nothing seems to work.
What should be the solution does NOT work: I have set a property on the
title text box to 'Repeat on every page with data region' , where data region
is set to be table 2.
Can anyone help me?
Many thanks
--
NatashaOn Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> Hello all,
> I'm trying to find solution to show sub-report title on every page of that
> subreport.
> What I have in the subreport is the text containing title and two tables
> underneath.
> The first table is a summary table and will only be shown on the first page.
> The second table goes over few pages.
> What I need is to get the title (which is above he first table) to show on
> every page of that subreport, when exported to PDF.Instead its only shown on
> the first page.
> I have tried many things, nothing seems to work.
> What should be the solution does NOT work: I have set a property on the
> title text box to 'Repeat on every page with data region' , where data region
> is set to be table 2.
> Can anyone help me?
> Many thanks
> --
> Natasha
You should be able to add a page header to the subreport (via 'Layout'
view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
repeat on every page when exported to PDF. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
I have tried using subreport headers before, but it doesnot show them at all
- this is another MRS limitation. Only main report headers and/or footers are
displayed.
"EMartinez" wrote:
> On Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> > Hello all,
> > I'm trying to find solution to show sub-report title on every page of that
> > subreport.
> > What I have in the subreport is the text containing title and two tables
> > underneath.
> > The first table is a summary table and will only be shown on the first page.
> > The second table goes over few pages.
> > What I need is to get the title (which is above he first table) to show on
> > every page of that subreport, when exported to PDF.Instead its only shown on
> > the first page.
> > I have tried many things, nothing seems to work.
> > What should be the solution does NOT work: I have set a property on the
> > title text box to 'Repeat on every page with data region' , where data region
> > is set to be table 2.
> > Can anyone help me?
> >
> > Many thanks
> >
> > --
> > Natasha
>
> You should be able to add a page header to the subreport (via 'Layout'
> view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
> repeat on every page when exported to PDF. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||A little clumsy, but you could add an additional dataset in the main
report to provide the subreport heading that you want to repeat - if
you want values from it to appear in the actual header, you need to
use the following trick to show dataset values in the header (or
footer):
Go to Report|Report Properties menu.
Put code similar to the following into the Code tab (for each field
you plan on using in the header, add a global variable and a function
to return it and/or a parameter).
Sample:
Public Shared reportTitle As String
Public Shared reportName As String
Public Shared Function StoreHeaderInfo( title As String, name As
String) As String
reportTitle = title
reportName = name
' we need the assignment statement below, because method must return
something
' otherwise, we can't use it in a table cell or textbox
StoreHeaderInfo = ""
End Function
Then, in the body of the report, add a hidden textbox that has an
expression similar to this:
=Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
ReportName.Value )
Finally, in the header, put in a text box that has the expression:
=Code.reportName or =Code.reportTitle|||Hello Parker,
I'd like to thank you for your response.
Unfortunatelly, I couldnt get it to work using this approach.I'm not sure if
I understood where Function StoreHeaderInfo supposed to go to, into the code
of the main report, or subreport?
I have tried both, but it didnt work..
I could not use the header of the main report, as I didnt want to use the
same header accross all subreports. The main header works fine if it is to be
applied throughout all report (will be applied to all subreports)...from what
I could find is that it can only be hidden on the first and/or the last page
if required...I couldnt find a way to control it accross subreports...
If I try to make use of the header in the subreport , it doesnt work
again...this header is completelly ignored once I run the whole report.
This is what I did at the end:
I have modified table 2 and made table 1 part of the table 2 (created new
group in table one and placed table 1 into it)...
I have then added Title which I wanted to repeat into the table 2 header.
Thank you again!
"Parker" wrote:
> A little clumsy, but you could add an additional dataset in the main
> report to provide the subreport heading that you want to repeat - if
> you want values from it to appear in the actual header, you need to
> use the following trick to show dataset values in the header (or
> footer):
> Go to Report|Report Properties menu.
> Put code similar to the following into the Code tab (for each field
> you plan on using in the header, add a global variable and a function
> to return it and/or a parameter).
> Sample:
> Public Shared reportTitle As String
> Public Shared reportName As String
> Public Shared Function StoreHeaderInfo( title As String, name As
> String) As String
> reportTitle = title
> reportName = name
> ' we need the assignment statement below, because method must return
> something
> ' otherwise, we can't use it in a table cell or textbox
> StoreHeaderInfo = ""
> End Function
> Then, in the body of the report, add a hidden textbox that has an
> expression similar to this:
> =Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
> ReportName.Value )
> Finally, in the header, put in a text box that has the expression:
> =Code.reportName or =Code.reportTitle
>
I'm trying to find solution to show sub-report title on every page of that
subreport.
What I have in the subreport is the text containing title and two tables
underneath.
The first table is a summary table and will only be shown on the first page.
The second table goes over few pages.
What I need is to get the title (which is above he first table) to show on
every page of that subreport, when exported to PDF.Instead its only shown on
the first page.
I have tried many things, nothing seems to work.
What should be the solution does NOT work: I have set a property on the
title text box to 'Repeat on every page with data region' , where data region
is set to be table 2.
Can anyone help me?
Many thanks
--
NatashaOn Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> Hello all,
> I'm trying to find solution to show sub-report title on every page of that
> subreport.
> What I have in the subreport is the text containing title and two tables
> underneath.
> The first table is a summary table and will only be shown on the first page.
> The second table goes over few pages.
> What I need is to get the title (which is above he first table) to show on
> every page of that subreport, when exported to PDF.Instead its only shown on
> the first page.
> I have tried many things, nothing seems to work.
> What should be the solution does NOT work: I have set a property on the
> title text box to 'Repeat on every page with data region' , where data region
> is set to be table 2.
> Can anyone help me?
> Many thanks
> --
> Natasha
You should be able to add a page header to the subreport (via 'Layout'
view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
repeat on every page when exported to PDF. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
I have tried using subreport headers before, but it doesnot show them at all
- this is another MRS limitation. Only main report headers and/or footers are
displayed.
"EMartinez" wrote:
> On Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> > Hello all,
> > I'm trying to find solution to show sub-report title on every page of that
> > subreport.
> > What I have in the subreport is the text containing title and two tables
> > underneath.
> > The first table is a summary table and will only be shown on the first page.
> > The second table goes over few pages.
> > What I need is to get the title (which is above he first table) to show on
> > every page of that subreport, when exported to PDF.Instead its only shown on
> > the first page.
> > I have tried many things, nothing seems to work.
> > What should be the solution does NOT work: I have set a property on the
> > title text box to 'Repeat on every page with data region' , where data region
> > is set to be table 2.
> > Can anyone help me?
> >
> > Many thanks
> >
> > --
> > Natasha
>
> You should be able to add a page header to the subreport (via 'Layout'
> view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
> repeat on every page when exported to PDF. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||A little clumsy, but you could add an additional dataset in the main
report to provide the subreport heading that you want to repeat - if
you want values from it to appear in the actual header, you need to
use the following trick to show dataset values in the header (or
footer):
Go to Report|Report Properties menu.
Put code similar to the following into the Code tab (for each field
you plan on using in the header, add a global variable and a function
to return it and/or a parameter).
Sample:
Public Shared reportTitle As String
Public Shared reportName As String
Public Shared Function StoreHeaderInfo( title As String, name As
String) As String
reportTitle = title
reportName = name
' we need the assignment statement below, because method must return
something
' otherwise, we can't use it in a table cell or textbox
StoreHeaderInfo = ""
End Function
Then, in the body of the report, add a hidden textbox that has an
expression similar to this:
=Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
ReportName.Value )
Finally, in the header, put in a text box that has the expression:
=Code.reportName or =Code.reportTitle|||Hello Parker,
I'd like to thank you for your response.
Unfortunatelly, I couldnt get it to work using this approach.I'm not sure if
I understood where Function StoreHeaderInfo supposed to go to, into the code
of the main report, or subreport?
I have tried both, but it didnt work..
I could not use the header of the main report, as I didnt want to use the
same header accross all subreports. The main header works fine if it is to be
applied throughout all report (will be applied to all subreports)...from what
I could find is that it can only be hidden on the first and/or the last page
if required...I couldnt find a way to control it accross subreports...
If I try to make use of the header in the subreport , it doesnt work
again...this header is completelly ignored once I run the whole report.
This is what I did at the end:
I have modified table 2 and made table 1 part of the table 2 (created new
group in table one and placed table 1 into it)...
I have then added Title which I wanted to repeat into the table 2 header.
Thank you again!
"Parker" wrote:
> A little clumsy, but you could add an additional dataset in the main
> report to provide the subreport heading that you want to repeat - if
> you want values from it to appear in the actual header, you need to
> use the following trick to show dataset values in the header (or
> footer):
> Go to Report|Report Properties menu.
> Put code similar to the following into the Code tab (for each field
> you plan on using in the header, add a global variable and a function
> to return it and/or a parameter).
> Sample:
> Public Shared reportTitle As String
> Public Shared reportName As String
> Public Shared Function StoreHeaderInfo( title As String, name As
> String) As String
> reportTitle = title
> reportName = name
> ' we need the assignment statement below, because method must return
> something
> ' otherwise, we can't use it in a table cell or textbox
> StoreHeaderInfo = ""
> End Function
> Then, in the body of the report, add a hidden textbox that has an
> expression similar to this:
> =Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
> ReportName.Value )
> Finally, in the header, put in a text box that has the expression:
> =Code.reportName or =Code.reportTitle
>
Repeat Data On Each Page (frustrated)
Sorry if this is a repeat question. I've been searching for three hours
trying to find a solution to a simple problem. Thank you in advance.
I have a report with a list control that has 20 textboxes and three sub
reports.
The report usually renders between 1-3 pages, depending on the content.
The report is an invoice report. All I want to do, is repeat the invoice
number at the top of each page. I know the textbox trick, but with a list
control, I can't guarantee that this control will be on each rendered page.
It's on the first page so the invoice number will print at the top. But on
all other pages, that control does not get rendered, which results in the
invoice number not printing on the page.
I have tried nesting list controls but this does not work either, especially
with .pdf rendering.
I understand the how's and why's Reporting Services renders reports.
But this functionality is basic and really a requirement for reports like
invoices where having the invoice number on each page is a requirement.
I also have to be able to print more that one invoice at a time. Currently
my dataset returns all invoice that need printing. My page breaking is
working fine.
I just can't get the invoice number on each rendered page.
Please help and thank you so very much,
KarlHave you tried passing the invoice number through as a parameter, and having
that at the top of the page. May work a little better
"Karl 140.6" wrote:
> Sorry if this is a repeat question. I've been searching for three hours
> trying to find a solution to a simple problem. Thank you in advance.
> I have a report with a list control that has 20 textboxes and three sub
> reports.
> The report usually renders between 1-3 pages, depending on the content.
> The report is an invoice report. All I want to do, is repeat the invoice
> number at the top of each page. I know the textbox trick, but with a list
> control, I can't guarantee that this control will be on each rendered page.
> It's on the first page so the invoice number will print at the top. But on
> all other pages, that control does not get rendered, which results in the
> invoice number not printing on the page.
> I have tried nesting list controls but this does not work either, especially
> with .pdf rendering.
> I understand the how's and why's Reporting Services renders reports.
> But this functionality is basic and really a requirement for reports like
> invoices where having the invoice number on each page is a requirement.
> I also have to be able to print more that one invoice at a time. Currently
> my dataset returns all invoice that need printing. My page breaking is
> working fine.
> I just can't get the invoice number on each rendered page.
> Please help and thank you so very much,
> Karl|||Thank you for your suggestion. This would work if we are only printing one
invoice at a time.
Howerver we are printing between 1 - 50 invoices at a time. The parameter
wouldn't work in this case. The data comes from a Dataset that queries based
on other criteria.
Thank you again for your suggestion.
Karl
"MACNR" wrote:
> Have you tried passing the invoice number through as a parameter, and having
> that at the top of the page. May work a little better
> "Karl 140.6" wrote:
> > Sorry if this is a repeat question. I've been searching for three hours
> > trying to find a solution to a simple problem. Thank you in advance.
> >
> > I have a report with a list control that has 20 textboxes and three sub
> > reports.
> >
> > The report usually renders between 1-3 pages, depending on the content.
> >
> > The report is an invoice report. All I want to do, is repeat the invoice
> > number at the top of each page. I know the textbox trick, but with a list
> > control, I can't guarantee that this control will be on each rendered page.
> > It's on the first page so the invoice number will print at the top. But on
> > all other pages, that control does not get rendered, which results in the
> > invoice number not printing on the page.
> >
> > I have tried nesting list controls but this does not work either, especially
> > with .pdf rendering.
> >
> > I understand the how's and why's Reporting Services renders reports.
> >
> > But this functionality is basic and really a requirement for reports like
> > invoices where having the invoice number on each page is a requirement.
> >
> > I also have to be able to print more that one invoice at a time. Currently
> > my dataset returns all invoice that need printing. My page breaking is
> > working fine.
> >
> > I just can't get the invoice number on each rendered page.
> >
> > Please help and thank you so very much,
> >
> > Karl|||Try putting the invoice within the innermost list, then hide it. You can then
refer to the textbox in the page header using the normal
ReportItems!textbox.Value expression.
"Karl 140.6" wrote:
> Thank you for your suggestion. This would work if we are only printing one
> invoice at a time.
> Howerver we are printing between 1 - 50 invoices at a time. The parameter
> wouldn't work in this case. The data comes from a Dataset that queries based
> on other criteria.
> Thank you again for your suggestion.
> Karl
> "MACNR" wrote:
> > Have you tried passing the invoice number through as a parameter, and having
> > that at the top of the page. May work a little better
> >
> > "Karl 140.6" wrote:
> >
> > > Sorry if this is a repeat question. I've been searching for three hours
> > > trying to find a solution to a simple problem. Thank you in advance.
> > >
> > > I have a report with a list control that has 20 textboxes and three sub
> > > reports.
> > >
> > > The report usually renders between 1-3 pages, depending on the content.
> > >
> > > The report is an invoice report. All I want to do, is repeat the invoice
> > > number at the top of each page. I know the textbox trick, but with a list
> > > control, I can't guarantee that this control will be on each rendered page.
> > > It's on the first page so the invoice number will print at the top. But on
> > > all other pages, that control does not get rendered, which results in the
> > > invoice number not printing on the page.
> > >
> > > I have tried nesting list controls but this does not work either, especially
> > > with .pdf rendering.
> > >
> > > I understand the how's and why's Reporting Services renders reports.
> > >
> > > But this functionality is basic and really a requirement for reports like
> > > invoices where having the invoice number on each page is a requirement.
> > >
> > > I also have to be able to print more that one invoice at a time. Currently
> > > my dataset returns all invoice that need printing. My page breaking is
> > > working fine.
> > >
> > > I just can't get the invoice number on each rendered page.
> > >
> > > Please help and thank you so very much,
> > >
> > > Karl|||Tom,
Great idea with a limitation however.
R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
If it's not on the page, R/S can't "see it"
If it can't "see it" the Invoice Number textbox will end up without a value
assigned to it.
This will happen in the list control extends past one page. This is exactly
the problem I'm having.
Thank you for your suggestion. If I come up with a fix I'll post it here
for sure.
Karl
"Tom" wrote:
> Try putting the invoice within the innermost list, then hide it. You can then
> refer to the textbox in the page header using the normal
> ReportItems!textbox.Value expression.
> "Karl 140.6" wrote:
> > Thank you for your suggestion. This would work if we are only printing one
> > invoice at a time.
> >
> > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > wouldn't work in this case. The data comes from a Dataset that queries based
> > on other criteria.
> >
> > Thank you again for your suggestion.
> >
> > Karl
> >
> > "MACNR" wrote:
> >
> > > Have you tried passing the invoice number through as a parameter, and having
> > > that at the top of the page. May work a little better
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > trying to find a solution to a simple problem. Thank you in advance.
> > > >
> > > > I have a report with a list control that has 20 textboxes and three sub
> > > > reports.
> > > >
> > > > The report usually renders between 1-3 pages, depending on the content.
> > > >
> > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > number at the top of each page. I know the textbox trick, but with a list
> > > > control, I can't guarantee that this control will be on each rendered page.
> > > > It's on the first page so the invoice number will print at the top. But on
> > > > all other pages, that control does not get rendered, which results in the
> > > > invoice number not printing on the page.
> > > >
> > > > I have tried nesting list controls but this does not work either, especially
> > > > with .pdf rendering.
> > > >
> > > > I understand the how's and why's Reporting Services renders reports.
> > > >
> > > > But this functionality is basic and really a requirement for reports like
> > > > invoices where having the invoice number on each page is a requirement.
> > > >
> > > > I also have to be able to print more that one invoice at a time. Currently
> > > > my dataset returns all invoice that need printing. My page breaking is
> > > > working fine.
> > > >
> > > > I just can't get the invoice number on each rendered page.
> > > >
> > > > Please help and thank you so very much,
> > > >
> > > > Karl|||Karl,
Have you tried using a simple one column table to emulate the list. You'll
need to put a rectangle in each cell before you then add fields. You can
then use the Repeat On New Page flag for the table's group header.
"Karl 140.6" wrote:
> Tom,
> Great idea with a limitation however.
> R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> If it's not on the page, R/S can't "see it"
> If it can't "see it" the Invoice Number textbox will end up without a value
> assigned to it.
> This will happen in the list control extends past one page. This is exactly
> the problem I'm having.
> Thank you for your suggestion. If I come up with a fix I'll post it here
> for sure.
> Karl
> "Tom" wrote:
> > Try putting the invoice within the innermost list, then hide it. You can then
> > refer to the textbox in the page header using the normal
> > ReportItems!textbox.Value expression.
> >
> > "Karl 140.6" wrote:
> >
> > > Thank you for your suggestion. This would work if we are only printing one
> > > invoice at a time.
> > >
> > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > on other criteria.
> > >
> > > Thank you again for your suggestion.
> > >
> > > Karl
> > >
> > > "MACNR" wrote:
> > >
> > > > Have you tried passing the invoice number through as a parameter, and having
> > > > that at the top of the page. May work a little better
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > >
> > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > reports.
> > > > >
> > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > >
> > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > all other pages, that control does not get rendered, which results in the
> > > > > invoice number not printing on the page.
> > > > >
> > > > > I have tried nesting list controls but this does not work either, especially
> > > > > with .pdf rendering.
> > > > >
> > > > > I understand the how's and why's Reporting Services renders reports.
> > > > >
> > > > > But this functionality is basic and really a requirement for reports like
> > > > > invoices where having the invoice number on each page is a requirement.
> > > > >
> > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > working fine.
> > > > >
> > > > > I just can't get the invoice number on each rendered page.
> > > > >
> > > > > Please help and thank you so very much,
> > > > >
> > > > > Karl|||I was trying to avoid that but I think you right.
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||ok ... now you lost me. His original set up was a list box with 20 text
boxes and a number of subreports. So the one column table will do what? and
why would he need to enter rectangles before adding fields? I am quite
interested in this ... also ... as you can see ... the "repeat item with
data area on each page" when checked doesnt seem to be working ... and that
has been my experience as well. I have a list box which contains a text box
and 2 tables (which the text box represents the heading for both tables since
they would be the same heading repeated) I have it set up to repeat the text
box with the table on each page ... and when the table spans more than one
page ... the text box doesnt show up (it isnt set to hidden or anything like
that either). The only way I was able to resolve this was to use a table
header ... which WILL repeat on each page ... however the second table would
need the same header and I dont want it repeated (looks redundant). However
there are cases where the second table renders by itself on a new page and
then there is no heading to describe what the table represents - all you see
are the group headings describing the fields them selves (the heading tells
what resource the fields relate to )
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||This sounded like such a good idea as I am trying something similar to Karl.
I thought of the one column table, but it would not let me put tables in the
detail rows. I tried putting the tables into the table footer rows and
repeating the table header, but the header would not repeat on each page.
So, upon reading your post, I put rectangles in the detail rows and then put
the tables inside the rectangles. It looked like it was going to work. But
when I tried to run my report, I got an error saying "The table â'table10â' is
contained inside a table detail row. Data regions are not allowed inside a
table detail row." for each table I tried to put inside the main table. Is
there a way around this? It's ridiculous that's there's no easy way to
repeat an item that contains a field on each page. Thanks.
-Sherri
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||Sherri,
Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
with code that I received from Microsoft. There is a workaround that's not
"TO" bad.
Cheers,
Karl
"Sherri French" wrote:
> This sounded like such a good idea as I am trying something similar to Karl.
> I thought of the one column table, but it would not let me put tables in the
> detail rows. I tried putting the tables into the table footer rows and
> repeating the table header, but the header would not repeat on each page.
> So, upon reading your post, I put rectangles in the detail rows and then put
> the tables inside the rectangles. It looked like it was going to work. But
> when I tried to run my report, I got an error saying "The table â'table10â' is
> contained inside a table detail row. Data regions are not allowed inside a
> table detail row." for each table I tried to put inside the main table. Is
> there a way around this? It's ridiculous that's there's no easy way to
> repeat an item that contains a field on each page. Thanks.
> -Sherri
> "Tom" wrote:
> > Karl,
> >
> > Have you tried using a simple one column table to emulate the list. You'll
> > need to put a rectangle in each cell before you then add fields. You can
> > then use the Repeat On New Page flag for the table's group header.
> >
> > "Karl 140.6" wrote:
> >
> > > Tom,
> > >
> > > Great idea with a limitation however.
> > >
> > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > If it's not on the page, R/S can't "see it"
> > >
> > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > assigned to it.
> > >
> > > This will happen in the list control extends past one page. This is exactly
> > > the problem I'm having.
> > >
> > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > for sure.
> > >
> > > Karl
> > >
> > > "Tom" wrote:
> > >
> > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > refer to the textbox in the page header using the normal
> > > > ReportItems!textbox.Value expression.
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > invoice at a time.
> > > > >
> > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > on other criteria.
> > > > >
> > > > > Thank you again for your suggestion.
> > > > >
> > > > > Karl
> > > > >
> > > > > "MACNR" wrote:
> > > > >
> > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > that at the top of the page. May work a little better
> > > > > >
> > > > > > "Karl 140.6" wrote:
> > > > > >
> > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > >
> > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > reports.
> > > > > > >
> > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > >
> > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > invoice number not printing on the page.
> > > > > > >
> > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > with .pdf rendering.
> > > > > > >
> > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > >
> > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > >
> > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > working fine.
> > > > > > >
> > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > >
> > > > > > > Please help and thank you so very much,
> > > > > > >
> > > > > > > Karl|||Hi Karl,
I am having the same problem. In the body section of my RDL I have 10
text boxes that are feeding information to the report header and
footer. I have also created a table in the same body section right
below the text boxes. But these text boxes are not displayed from the
second page onwards in the report. Seems like the table gets a
preference in being rendered than my text boxes. For days now, I have
been trying to repeat items on all report pages and i just cant.
Could you please perhaps tell me the work around for this that u
recommended to Sherri?
Thanks a lot!
Noorie
Karl 140.6 wrote:
> Sherri,
> Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> with code that I received from Microsoft. There is a workaround that's not
> "TO" bad.
> Cheers,
> Karl
> "Sherri French" wrote:
> > This sounded like such a good idea as I am trying something similar to Karl.
> > I thought of the one column table, but it would not let me put tables in the
> > detail rows. I tried putting the tables into the table footer rows and
> > repeating the table header, but the header would not repeat on each page.
> > So, upon reading your post, I put rectangles in the detail rows and then put
> > the tables inside the rectangles. It looked like it was going to work. But
> > when I tried to run my report, I got an error saying "The table 'table10' is
> > contained inside a table detail row. Data regions are not allowed inside a
> > table detail row." for each table I tried to put inside the main table. Is
> > there a way around this? It's ridiculous that's there's no easy way to
> > repeat an item that contains a field on each page. Thanks.
> >
> > -Sherri
> >
> > "Tom" wrote:
> >
> > > Karl,
> > >
> > > Have you tried using a simple one column table to emulate the list. You'll
> > > need to put a rectangle in each cell before you then add fields. You can
> > > then use the Repeat On New Page flag for the table's group header.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Tom,
> > > >
> > > > Great idea with a limitation however.
> > > >
> > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > If it's not on the page, R/S can't "see it"
> > > >
> > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > assigned to it.
> > > >
> > > > This will happen in the list control extends past one page. This is exactly
> > > > the problem I'm having.
> > > >
> > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > for sure.
> > > >
> > > > Karl
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > refer to the textbox in the page header using the normal
> > > > > ReportItems!textbox.Value expression.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > invoice at a time.
> > > > > >
> > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > on other criteria.
> > > > > >
> > > > > > Thank you again for your suggestion.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "MACNR" wrote:
> > > > > >
> > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > that at the top of the page. May work a little better
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > >
> > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > reports.
> > > > > > > >
> > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > >
> > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > invoice number not printing on the page.
> > > > > > > >
> > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > with .pdf rendering.
> > > > > > > >
> > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > >
> > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > >
> > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > working fine.
> > > > > > > >
> > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > >
> > > > > > > > Please help and thank you so very much,
> > > > > > > >
> > > > > > > > Karl|||Please Karl ... I need the workaround too ... and it looks like others do
too. Thanks!
"Karl 140.6" wrote:
> Sherri,
> Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> with code that I received from Microsoft. There is a workaround that's not
> "TO" bad.
> Cheers,
> Karl
> "Sherri French" wrote:
> > This sounded like such a good idea as I am trying something similar to Karl.
> > I thought of the one column table, but it would not let me put tables in the
> > detail rows. I tried putting the tables into the table footer rows and
> > repeating the table header, but the header would not repeat on each page.
> > So, upon reading your post, I put rectangles in the detail rows and then put
> > the tables inside the rectangles. It looked like it was going to work. But
> > when I tried to run my report, I got an error saying "The table â'table10â' is
> > contained inside a table detail row. Data regions are not allowed inside a
> > table detail row." for each table I tried to put inside the main table. Is
> > there a way around this? It's ridiculous that's there's no easy way to
> > repeat an item that contains a field on each page. Thanks.
> >
> > -Sherri
> >
> > "Tom" wrote:
> >
> > > Karl,
> > >
> > > Have you tried using a simple one column table to emulate the list. You'll
> > > need to put a rectangle in each cell before you then add fields. You can
> > > then use the Repeat On New Page flag for the table's group header.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Tom,
> > > >
> > > > Great idea with a limitation however.
> > > >
> > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > If it's not on the page, R/S can't "see it"
> > > >
> > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > assigned to it.
> > > >
> > > > This will happen in the list control extends past one page. This is exactly
> > > > the problem I'm having.
> > > >
> > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > for sure.
> > > >
> > > > Karl
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > refer to the textbox in the page header using the normal
> > > > > ReportItems!textbox.Value expression.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > invoice at a time.
> > > > > >
> > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > on other criteria.
> > > > > >
> > > > > > Thank you again for your suggestion.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "MACNR" wrote:
> > > > > >
> > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > that at the top of the page. May work a little better
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > >
> > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > reports.
> > > > > > > >
> > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > >
> > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > invoice number not printing on the page.
> > > > > > > >
> > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > with .pdf rendering.
> > > > > > > >
> > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > >
> > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > >
> > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > working fine.
> > > > > > > >
> > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > >
> > > > > > > > Please help and thank you so very much,
> > > > > > > >
> > > > > > > > Karl|||MJT,
Please send me your email and I'll forward the information to you.
Send your email to : ks923z@.yahoo.com
Karl
"MJT" wrote:
> Please Karl ... I need the workaround too ... and it looks like others do
> too. Thanks!
> "Karl 140.6" wrote:
> > Sherri,
> >
> > Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> > with code that I received from Microsoft. There is a workaround that's not
> > "TO" bad.
> >
> > Cheers,
> >
> > Karl
> >
> > "Sherri French" wrote:
> >
> > > This sounded like such a good idea as I am trying something similar to Karl.
> > > I thought of the one column table, but it would not let me put tables in the
> > > detail rows. I tried putting the tables into the table footer rows and
> > > repeating the table header, but the header would not repeat on each page.
> > > So, upon reading your post, I put rectangles in the detail rows and then put
> > > the tables inside the rectangles. It looked like it was going to work. But
> > > when I tried to run my report, I got an error saying "The table â'table10â' is
> > > contained inside a table detail row. Data regions are not allowed inside a
> > > table detail row." for each table I tried to put inside the main table. Is
> > > there a way around this? It's ridiculous that's there's no easy way to
> > > repeat an item that contains a field on each page. Thanks.
> > >
> > > -Sherri
> > >
> > > "Tom" wrote:
> > >
> > > > Karl,
> > > >
> > > > Have you tried using a simple one column table to emulate the list. You'll
> > > > need to put a rectangle in each cell before you then add fields. You can
> > > > then use the Repeat On New Page flag for the table's group header.
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Tom,
> > > > >
> > > > > Great idea with a limitation however.
> > > > >
> > > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > > If it's not on the page, R/S can't "see it"
> > > > >
> > > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > > assigned to it.
> > > > >
> > > > > This will happen in the list control extends past one page. This is exactly
> > > > > the problem I'm having.
> > > > >
> > > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > > for sure.
> > > > >
> > > > > Karl
> > > > >
> > > > > "Tom" wrote:
> > > > >
> > > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > > refer to the textbox in the page header using the normal
> > > > > > ReportItems!textbox.Value expression.
> > > > > >
> > > > > > "Karl 140.6" wrote:
> > > > > >
> > > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > > invoice at a time.
> > > > > > >
> > > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > > on other criteria.
> > > > > > >
> > > > > > > Thank you again for your suggestion.
> > > > > > >
> > > > > > > Karl
> > > > > > >
> > > > > > > "MACNR" wrote:
> > > > > > >
> > > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > > that at the top of the page. May work a little better
> > > > > > > >
> > > > > > > > "Karl 140.6" wrote:
> > > > > > > >
> > > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > > >
> > > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > > reports.
> > > > > > > > >
> > > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > > >
> > > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > > invoice number not printing on the page.
> > > > > > > > >
> > > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > > with .pdf rendering.
> > > > > > > > >
> > > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > > >
> > > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > > >
> > > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > > working fine.
> > > > > > > > >
> > > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > > >
> > > > > > > > > Please help and thank you so very much,
> > > > > > > > >
> > > > > > > > > Karl|||Thanks Karl ... I did send it
"Karl 140.6" wrote:
> MJT,
> Please send me your email and I'll forward the information to you.
> Send your email to : ks923z@.yahoo.com
> Karl
> "MJT" wrote:
> > Please Karl ... I need the workaround too ... and it looks like others do
> > too. Thanks!
> >
> > "Karl 140.6" wrote:
> >
> > > Sherri,
> > >
> > > Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> > > with code that I received from Microsoft. There is a workaround that's not
> > > "TO" bad.
> > >
> > > Cheers,
> > >
> > > Karl
> > >
> > > "Sherri French" wrote:
> > >
> > > > This sounded like such a good idea as I am trying something similar to Karl.
> > > > I thought of the one column table, but it would not let me put tables in the
> > > > detail rows. I tried putting the tables into the table footer rows and
> > > > repeating the table header, but the header would not repeat on each page.
> > > > So, upon reading your post, I put rectangles in the detail rows and then put
> > > > the tables inside the rectangles. It looked like it was going to work. But
> > > > when I tried to run my report, I got an error saying "The table â'table10â' is
> > > > contained inside a table detail row. Data regions are not allowed inside a
> > > > table detail row." for each table I tried to put inside the main table. Is
> > > > there a way around this? It's ridiculous that's there's no easy way to
> > > > repeat an item that contains a field on each page. Thanks.
> > > >
> > > > -Sherri
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Karl,
> > > > >
> > > > > Have you tried using a simple one column table to emulate the list. You'll
> > > > > need to put a rectangle in each cell before you then add fields. You can
> > > > > then use the Repeat On New Page flag for the table's group header.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Tom,
> > > > > >
> > > > > > Great idea with a limitation however.
> > > > > >
> > > > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > > > If it's not on the page, R/S can't "see it"
> > > > > >
> > > > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > > > assigned to it.
> > > > > >
> > > > > > This will happen in the list control extends past one page. This is exactly
> > > > > > the problem I'm having.
> > > > > >
> > > > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > > > for sure.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "Tom" wrote:
> > > > > >
> > > > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > > > refer to the textbox in the page header using the normal
> > > > > > > ReportItems!textbox.Value expression.
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > > > invoice at a time.
> > > > > > > >
> > > > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > > > on other criteria.
> > > > > > > >
> > > > > > > > Thank you again for your suggestion.
> > > > > > > >
> > > > > > > > Karl
> > > > > > > >
> > > > > > > > "MACNR" wrote:
> > > > > > > >
> > > > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > > > that at the top of the page. May work a little better
> > > > > > > > >
> > > > > > > > > "Karl 140.6" wrote:
> > > > > > > > >
> > > > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > > > >
> > > > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > > > reports.
> > > > > > > > > >
> > > > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > > > >
> > > > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > > > invoice number not printing on the page.
> > > > > > > > > >
> > > > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > > > with .pdf rendering.
> > > > > > > > > >
> > > > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > > > >
> > > > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > > > >
> > > > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > > > working fine.
> > > > > > > > > >
> > > > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > > > >
> > > > > > > > > > Please help and thank you so very much,
> > > > > > > > > >
> > > > > > > > > > Karl|||Everyone,
Below is email I received from Microsoft with the solution. I hope this
work around helps everyone.
As I discussed with Karl, the issue want assistance with is generating a
report with Invoice Number (or some other group information) appearing in the
Page Header. I am attaching a project with a single report that accomplishes
this objective. I created a custom function and used it to store the data
between pages. The code for that function is:
Shared employeeID as Object
Public Function GetGroupEmployeeID(empID as Object) as Object
If Not (empID is Nothing)
If Not employeeID = empID
employeeID = empID
End If
End If
return employeeID
End Function
The text box at the top of the form gets the value:
=Code.GetGroupEmployeeID(ReportItems!EmployeeID.Value)
Note that EmployeeID is the name of the text box in the top left of the
outer List. It must be in the list, but you can set its Visibility.Hidden
property to true. You access the custom code section of a report by right
clicking on the report layout background and choosing properties. Then go to
the code tab and enter your code.
This custom function is just a sample of what you want to do. It is not the
solution to your problem. It uses a single, shared variable. This means
that multiple individuals rendering reports simultaneously can cause
unpredictable behavior. The real solution would be to create a custom
assembly that uses a Hashtable and access it within your custom function.
Pass the Globals!UserID and the value you want to store
(ReportItems!EmployeeID.Value in this case) and manage them there.
"Karl 140.6" wrote:
> Sorry if this is a repeat question. I've been searching for three hours
> trying to find a solution to a simple problem. Thank you in advance.
> I have a report with a list control that has 20 textboxes and three sub
> reports.
> The report usually renders between 1-3 pages, depending on the content.
> The report is an invoice report. All I want to do, is repeat the invoice
> number at the top of each page. I know the textbox trick, but with a list
> control, I can't guarantee that this control will be on each rendered page.
> It's on the first page so the invoice number will print at the top. But on
> all other pages, that control does not get rendered, which results in the
> invoice number not printing on the page.
> I have tried nesting list controls but this does not work either, especially
> with .pdf rendering.
> I understand the how's and why's Reporting Services renders reports.
> But this functionality is basic and really a requirement for reports like
> invoices where having the invoice number on each page is a requirement.
> I also have to be able to print more that one invoice at a time. Currently
> my dataset returns all invoice that need printing. My page breaking is
> working fine.
> I just can't get the invoice number on each rendered page.
> Please help and thank you so very much,
> Karl
trying to find a solution to a simple problem. Thank you in advance.
I have a report with a list control that has 20 textboxes and three sub
reports.
The report usually renders between 1-3 pages, depending on the content.
The report is an invoice report. All I want to do, is repeat the invoice
number at the top of each page. I know the textbox trick, but with a list
control, I can't guarantee that this control will be on each rendered page.
It's on the first page so the invoice number will print at the top. But on
all other pages, that control does not get rendered, which results in the
invoice number not printing on the page.
I have tried nesting list controls but this does not work either, especially
with .pdf rendering.
I understand the how's and why's Reporting Services renders reports.
But this functionality is basic and really a requirement for reports like
invoices where having the invoice number on each page is a requirement.
I also have to be able to print more that one invoice at a time. Currently
my dataset returns all invoice that need printing. My page breaking is
working fine.
I just can't get the invoice number on each rendered page.
Please help and thank you so very much,
KarlHave you tried passing the invoice number through as a parameter, and having
that at the top of the page. May work a little better
"Karl 140.6" wrote:
> Sorry if this is a repeat question. I've been searching for three hours
> trying to find a solution to a simple problem. Thank you in advance.
> I have a report with a list control that has 20 textboxes and three sub
> reports.
> The report usually renders between 1-3 pages, depending on the content.
> The report is an invoice report. All I want to do, is repeat the invoice
> number at the top of each page. I know the textbox trick, but with a list
> control, I can't guarantee that this control will be on each rendered page.
> It's on the first page so the invoice number will print at the top. But on
> all other pages, that control does not get rendered, which results in the
> invoice number not printing on the page.
> I have tried nesting list controls but this does not work either, especially
> with .pdf rendering.
> I understand the how's and why's Reporting Services renders reports.
> But this functionality is basic and really a requirement for reports like
> invoices where having the invoice number on each page is a requirement.
> I also have to be able to print more that one invoice at a time. Currently
> my dataset returns all invoice that need printing. My page breaking is
> working fine.
> I just can't get the invoice number on each rendered page.
> Please help and thank you so very much,
> Karl|||Thank you for your suggestion. This would work if we are only printing one
invoice at a time.
Howerver we are printing between 1 - 50 invoices at a time. The parameter
wouldn't work in this case. The data comes from a Dataset that queries based
on other criteria.
Thank you again for your suggestion.
Karl
"MACNR" wrote:
> Have you tried passing the invoice number through as a parameter, and having
> that at the top of the page. May work a little better
> "Karl 140.6" wrote:
> > Sorry if this is a repeat question. I've been searching for three hours
> > trying to find a solution to a simple problem. Thank you in advance.
> >
> > I have a report with a list control that has 20 textboxes and three sub
> > reports.
> >
> > The report usually renders between 1-3 pages, depending on the content.
> >
> > The report is an invoice report. All I want to do, is repeat the invoice
> > number at the top of each page. I know the textbox trick, but with a list
> > control, I can't guarantee that this control will be on each rendered page.
> > It's on the first page so the invoice number will print at the top. But on
> > all other pages, that control does not get rendered, which results in the
> > invoice number not printing on the page.
> >
> > I have tried nesting list controls but this does not work either, especially
> > with .pdf rendering.
> >
> > I understand the how's and why's Reporting Services renders reports.
> >
> > But this functionality is basic and really a requirement for reports like
> > invoices where having the invoice number on each page is a requirement.
> >
> > I also have to be able to print more that one invoice at a time. Currently
> > my dataset returns all invoice that need printing. My page breaking is
> > working fine.
> >
> > I just can't get the invoice number on each rendered page.
> >
> > Please help and thank you so very much,
> >
> > Karl|||Try putting the invoice within the innermost list, then hide it. You can then
refer to the textbox in the page header using the normal
ReportItems!textbox.Value expression.
"Karl 140.6" wrote:
> Thank you for your suggestion. This would work if we are only printing one
> invoice at a time.
> Howerver we are printing between 1 - 50 invoices at a time. The parameter
> wouldn't work in this case. The data comes from a Dataset that queries based
> on other criteria.
> Thank you again for your suggestion.
> Karl
> "MACNR" wrote:
> > Have you tried passing the invoice number through as a parameter, and having
> > that at the top of the page. May work a little better
> >
> > "Karl 140.6" wrote:
> >
> > > Sorry if this is a repeat question. I've been searching for three hours
> > > trying to find a solution to a simple problem. Thank you in advance.
> > >
> > > I have a report with a list control that has 20 textboxes and three sub
> > > reports.
> > >
> > > The report usually renders between 1-3 pages, depending on the content.
> > >
> > > The report is an invoice report. All I want to do, is repeat the invoice
> > > number at the top of each page. I know the textbox trick, but with a list
> > > control, I can't guarantee that this control will be on each rendered page.
> > > It's on the first page so the invoice number will print at the top. But on
> > > all other pages, that control does not get rendered, which results in the
> > > invoice number not printing on the page.
> > >
> > > I have tried nesting list controls but this does not work either, especially
> > > with .pdf rendering.
> > >
> > > I understand the how's and why's Reporting Services renders reports.
> > >
> > > But this functionality is basic and really a requirement for reports like
> > > invoices where having the invoice number on each page is a requirement.
> > >
> > > I also have to be able to print more that one invoice at a time. Currently
> > > my dataset returns all invoice that need printing. My page breaking is
> > > working fine.
> > >
> > > I just can't get the invoice number on each rendered page.
> > >
> > > Please help and thank you so very much,
> > >
> > > Karl|||Tom,
Great idea with a limitation however.
R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
If it's not on the page, R/S can't "see it"
If it can't "see it" the Invoice Number textbox will end up without a value
assigned to it.
This will happen in the list control extends past one page. This is exactly
the problem I'm having.
Thank you for your suggestion. If I come up with a fix I'll post it here
for sure.
Karl
"Tom" wrote:
> Try putting the invoice within the innermost list, then hide it. You can then
> refer to the textbox in the page header using the normal
> ReportItems!textbox.Value expression.
> "Karl 140.6" wrote:
> > Thank you for your suggestion. This would work if we are only printing one
> > invoice at a time.
> >
> > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > wouldn't work in this case. The data comes from a Dataset that queries based
> > on other criteria.
> >
> > Thank you again for your suggestion.
> >
> > Karl
> >
> > "MACNR" wrote:
> >
> > > Have you tried passing the invoice number through as a parameter, and having
> > > that at the top of the page. May work a little better
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > trying to find a solution to a simple problem. Thank you in advance.
> > > >
> > > > I have a report with a list control that has 20 textboxes and three sub
> > > > reports.
> > > >
> > > > The report usually renders between 1-3 pages, depending on the content.
> > > >
> > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > number at the top of each page. I know the textbox trick, but with a list
> > > > control, I can't guarantee that this control will be on each rendered page.
> > > > It's on the first page so the invoice number will print at the top. But on
> > > > all other pages, that control does not get rendered, which results in the
> > > > invoice number not printing on the page.
> > > >
> > > > I have tried nesting list controls but this does not work either, especially
> > > > with .pdf rendering.
> > > >
> > > > I understand the how's and why's Reporting Services renders reports.
> > > >
> > > > But this functionality is basic and really a requirement for reports like
> > > > invoices where having the invoice number on each page is a requirement.
> > > >
> > > > I also have to be able to print more that one invoice at a time. Currently
> > > > my dataset returns all invoice that need printing. My page breaking is
> > > > working fine.
> > > >
> > > > I just can't get the invoice number on each rendered page.
> > > >
> > > > Please help and thank you so very much,
> > > >
> > > > Karl|||Karl,
Have you tried using a simple one column table to emulate the list. You'll
need to put a rectangle in each cell before you then add fields. You can
then use the Repeat On New Page flag for the table's group header.
"Karl 140.6" wrote:
> Tom,
> Great idea with a limitation however.
> R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> If it's not on the page, R/S can't "see it"
> If it can't "see it" the Invoice Number textbox will end up without a value
> assigned to it.
> This will happen in the list control extends past one page. This is exactly
> the problem I'm having.
> Thank you for your suggestion. If I come up with a fix I'll post it here
> for sure.
> Karl
> "Tom" wrote:
> > Try putting the invoice within the innermost list, then hide it. You can then
> > refer to the textbox in the page header using the normal
> > ReportItems!textbox.Value expression.
> >
> > "Karl 140.6" wrote:
> >
> > > Thank you for your suggestion. This would work if we are only printing one
> > > invoice at a time.
> > >
> > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > on other criteria.
> > >
> > > Thank you again for your suggestion.
> > >
> > > Karl
> > >
> > > "MACNR" wrote:
> > >
> > > > Have you tried passing the invoice number through as a parameter, and having
> > > > that at the top of the page. May work a little better
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > >
> > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > reports.
> > > > >
> > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > >
> > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > all other pages, that control does not get rendered, which results in the
> > > > > invoice number not printing on the page.
> > > > >
> > > > > I have tried nesting list controls but this does not work either, especially
> > > > > with .pdf rendering.
> > > > >
> > > > > I understand the how's and why's Reporting Services renders reports.
> > > > >
> > > > > But this functionality is basic and really a requirement for reports like
> > > > > invoices where having the invoice number on each page is a requirement.
> > > > >
> > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > working fine.
> > > > >
> > > > > I just can't get the invoice number on each rendered page.
> > > > >
> > > > > Please help and thank you so very much,
> > > > >
> > > > > Karl|||I was trying to avoid that but I think you right.
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||ok ... now you lost me. His original set up was a list box with 20 text
boxes and a number of subreports. So the one column table will do what? and
why would he need to enter rectangles before adding fields? I am quite
interested in this ... also ... as you can see ... the "repeat item with
data area on each page" when checked doesnt seem to be working ... and that
has been my experience as well. I have a list box which contains a text box
and 2 tables (which the text box represents the heading for both tables since
they would be the same heading repeated) I have it set up to repeat the text
box with the table on each page ... and when the table spans more than one
page ... the text box doesnt show up (it isnt set to hidden or anything like
that either). The only way I was able to resolve this was to use a table
header ... which WILL repeat on each page ... however the second table would
need the same header and I dont want it repeated (looks redundant). However
there are cases where the second table renders by itself on a new page and
then there is no heading to describe what the table represents - all you see
are the group headings describing the fields them selves (the heading tells
what resource the fields relate to )
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||This sounded like such a good idea as I am trying something similar to Karl.
I thought of the one column table, but it would not let me put tables in the
detail rows. I tried putting the tables into the table footer rows and
repeating the table header, but the header would not repeat on each page.
So, upon reading your post, I put rectangles in the detail rows and then put
the tables inside the rectangles. It looked like it was going to work. But
when I tried to run my report, I got an error saying "The table â'table10â' is
contained inside a table detail row. Data regions are not allowed inside a
table detail row." for each table I tried to put inside the main table. Is
there a way around this? It's ridiculous that's there's no easy way to
repeat an item that contains a field on each page. Thanks.
-Sherri
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||Sherri,
Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
with code that I received from Microsoft. There is a workaround that's not
"TO" bad.
Cheers,
Karl
"Sherri French" wrote:
> This sounded like such a good idea as I am trying something similar to Karl.
> I thought of the one column table, but it would not let me put tables in the
> detail rows. I tried putting the tables into the table footer rows and
> repeating the table header, but the header would not repeat on each page.
> So, upon reading your post, I put rectangles in the detail rows and then put
> the tables inside the rectangles. It looked like it was going to work. But
> when I tried to run my report, I got an error saying "The table â'table10â' is
> contained inside a table detail row. Data regions are not allowed inside a
> table detail row." for each table I tried to put inside the main table. Is
> there a way around this? It's ridiculous that's there's no easy way to
> repeat an item that contains a field on each page. Thanks.
> -Sherri
> "Tom" wrote:
> > Karl,
> >
> > Have you tried using a simple one column table to emulate the list. You'll
> > need to put a rectangle in each cell before you then add fields. You can
> > then use the Repeat On New Page flag for the table's group header.
> >
> > "Karl 140.6" wrote:
> >
> > > Tom,
> > >
> > > Great idea with a limitation however.
> > >
> > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > If it's not on the page, R/S can't "see it"
> > >
> > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > assigned to it.
> > >
> > > This will happen in the list control extends past one page. This is exactly
> > > the problem I'm having.
> > >
> > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > for sure.
> > >
> > > Karl
> > >
> > > "Tom" wrote:
> > >
> > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > refer to the textbox in the page header using the normal
> > > > ReportItems!textbox.Value expression.
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > invoice at a time.
> > > > >
> > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > on other criteria.
> > > > >
> > > > > Thank you again for your suggestion.
> > > > >
> > > > > Karl
> > > > >
> > > > > "MACNR" wrote:
> > > > >
> > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > that at the top of the page. May work a little better
> > > > > >
> > > > > > "Karl 140.6" wrote:
> > > > > >
> > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > >
> > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > reports.
> > > > > > >
> > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > >
> > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > invoice number not printing on the page.
> > > > > > >
> > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > with .pdf rendering.
> > > > > > >
> > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > >
> > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > >
> > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > working fine.
> > > > > > >
> > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > >
> > > > > > > Please help and thank you so very much,
> > > > > > >
> > > > > > > Karl|||Hi Karl,
I am having the same problem. In the body section of my RDL I have 10
text boxes that are feeding information to the report header and
footer. I have also created a table in the same body section right
below the text boxes. But these text boxes are not displayed from the
second page onwards in the report. Seems like the table gets a
preference in being rendered than my text boxes. For days now, I have
been trying to repeat items on all report pages and i just cant.
Could you please perhaps tell me the work around for this that u
recommended to Sherri?
Thanks a lot!
Noorie
Karl 140.6 wrote:
> Sherri,
> Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> with code that I received from Microsoft. There is a workaround that's not
> "TO" bad.
> Cheers,
> Karl
> "Sherri French" wrote:
> > This sounded like such a good idea as I am trying something similar to Karl.
> > I thought of the one column table, but it would not let me put tables in the
> > detail rows. I tried putting the tables into the table footer rows and
> > repeating the table header, but the header would not repeat on each page.
> > So, upon reading your post, I put rectangles in the detail rows and then put
> > the tables inside the rectangles. It looked like it was going to work. But
> > when I tried to run my report, I got an error saying "The table 'table10' is
> > contained inside a table detail row. Data regions are not allowed inside a
> > table detail row." for each table I tried to put inside the main table. Is
> > there a way around this? It's ridiculous that's there's no easy way to
> > repeat an item that contains a field on each page. Thanks.
> >
> > -Sherri
> >
> > "Tom" wrote:
> >
> > > Karl,
> > >
> > > Have you tried using a simple one column table to emulate the list. You'll
> > > need to put a rectangle in each cell before you then add fields. You can
> > > then use the Repeat On New Page flag for the table's group header.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Tom,
> > > >
> > > > Great idea with a limitation however.
> > > >
> > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > If it's not on the page, R/S can't "see it"
> > > >
> > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > assigned to it.
> > > >
> > > > This will happen in the list control extends past one page. This is exactly
> > > > the problem I'm having.
> > > >
> > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > for sure.
> > > >
> > > > Karl
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > refer to the textbox in the page header using the normal
> > > > > ReportItems!textbox.Value expression.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > invoice at a time.
> > > > > >
> > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > on other criteria.
> > > > > >
> > > > > > Thank you again for your suggestion.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "MACNR" wrote:
> > > > > >
> > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > that at the top of the page. May work a little better
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > >
> > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > reports.
> > > > > > > >
> > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > >
> > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > invoice number not printing on the page.
> > > > > > > >
> > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > with .pdf rendering.
> > > > > > > >
> > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > >
> > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > >
> > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > working fine.
> > > > > > > >
> > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > >
> > > > > > > > Please help and thank you so very much,
> > > > > > > >
> > > > > > > > Karl|||Please Karl ... I need the workaround too ... and it looks like others do
too. Thanks!
"Karl 140.6" wrote:
> Sherri,
> Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> with code that I received from Microsoft. There is a workaround that's not
> "TO" bad.
> Cheers,
> Karl
> "Sherri French" wrote:
> > This sounded like such a good idea as I am trying something similar to Karl.
> > I thought of the one column table, but it would not let me put tables in the
> > detail rows. I tried putting the tables into the table footer rows and
> > repeating the table header, but the header would not repeat on each page.
> > So, upon reading your post, I put rectangles in the detail rows and then put
> > the tables inside the rectangles. It looked like it was going to work. But
> > when I tried to run my report, I got an error saying "The table â'table10â' is
> > contained inside a table detail row. Data regions are not allowed inside a
> > table detail row." for each table I tried to put inside the main table. Is
> > there a way around this? It's ridiculous that's there's no easy way to
> > repeat an item that contains a field on each page. Thanks.
> >
> > -Sherri
> >
> > "Tom" wrote:
> >
> > > Karl,
> > >
> > > Have you tried using a simple one column table to emulate the list. You'll
> > > need to put a rectangle in each cell before you then add fields. You can
> > > then use the Repeat On New Page flag for the table's group header.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Tom,
> > > >
> > > > Great idea with a limitation however.
> > > >
> > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > If it's not on the page, R/S can't "see it"
> > > >
> > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > assigned to it.
> > > >
> > > > This will happen in the list control extends past one page. This is exactly
> > > > the problem I'm having.
> > > >
> > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > for sure.
> > > >
> > > > Karl
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > refer to the textbox in the page header using the normal
> > > > > ReportItems!textbox.Value expression.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > invoice at a time.
> > > > > >
> > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > on other criteria.
> > > > > >
> > > > > > Thank you again for your suggestion.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "MACNR" wrote:
> > > > > >
> > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > that at the top of the page. May work a little better
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > >
> > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > reports.
> > > > > > > >
> > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > >
> > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > invoice number not printing on the page.
> > > > > > > >
> > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > with .pdf rendering.
> > > > > > > >
> > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > >
> > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > >
> > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > working fine.
> > > > > > > >
> > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > >
> > > > > > > > Please help and thank you so very much,
> > > > > > > >
> > > > > > > > Karl|||MJT,
Please send me your email and I'll forward the information to you.
Send your email to : ks923z@.yahoo.com
Karl
"MJT" wrote:
> Please Karl ... I need the workaround too ... and it looks like others do
> too. Thanks!
> "Karl 140.6" wrote:
> > Sherri,
> >
> > Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> > with code that I received from Microsoft. There is a workaround that's not
> > "TO" bad.
> >
> > Cheers,
> >
> > Karl
> >
> > "Sherri French" wrote:
> >
> > > This sounded like such a good idea as I am trying something similar to Karl.
> > > I thought of the one column table, but it would not let me put tables in the
> > > detail rows. I tried putting the tables into the table footer rows and
> > > repeating the table header, but the header would not repeat on each page.
> > > So, upon reading your post, I put rectangles in the detail rows and then put
> > > the tables inside the rectangles. It looked like it was going to work. But
> > > when I tried to run my report, I got an error saying "The table â'table10â' is
> > > contained inside a table detail row. Data regions are not allowed inside a
> > > table detail row." for each table I tried to put inside the main table. Is
> > > there a way around this? It's ridiculous that's there's no easy way to
> > > repeat an item that contains a field on each page. Thanks.
> > >
> > > -Sherri
> > >
> > > "Tom" wrote:
> > >
> > > > Karl,
> > > >
> > > > Have you tried using a simple one column table to emulate the list. You'll
> > > > need to put a rectangle in each cell before you then add fields. You can
> > > > then use the Repeat On New Page flag for the table's group header.
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Tom,
> > > > >
> > > > > Great idea with a limitation however.
> > > > >
> > > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > > If it's not on the page, R/S can't "see it"
> > > > >
> > > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > > assigned to it.
> > > > >
> > > > > This will happen in the list control extends past one page. This is exactly
> > > > > the problem I'm having.
> > > > >
> > > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > > for sure.
> > > > >
> > > > > Karl
> > > > >
> > > > > "Tom" wrote:
> > > > >
> > > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > > refer to the textbox in the page header using the normal
> > > > > > ReportItems!textbox.Value expression.
> > > > > >
> > > > > > "Karl 140.6" wrote:
> > > > > >
> > > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > > invoice at a time.
> > > > > > >
> > > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > > on other criteria.
> > > > > > >
> > > > > > > Thank you again for your suggestion.
> > > > > > >
> > > > > > > Karl
> > > > > > >
> > > > > > > "MACNR" wrote:
> > > > > > >
> > > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > > that at the top of the page. May work a little better
> > > > > > > >
> > > > > > > > "Karl 140.6" wrote:
> > > > > > > >
> > > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > > >
> > > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > > reports.
> > > > > > > > >
> > > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > > >
> > > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > > invoice number not printing on the page.
> > > > > > > > >
> > > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > > with .pdf rendering.
> > > > > > > > >
> > > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > > >
> > > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > > >
> > > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > > working fine.
> > > > > > > > >
> > > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > > >
> > > > > > > > > Please help and thank you so very much,
> > > > > > > > >
> > > > > > > > > Karl|||Thanks Karl ... I did send it
"Karl 140.6" wrote:
> MJT,
> Please send me your email and I'll forward the information to you.
> Send your email to : ks923z@.yahoo.com
> Karl
> "MJT" wrote:
> > Please Karl ... I need the workaround too ... and it looks like others do
> > too. Thanks!
> >
> > "Karl 140.6" wrote:
> >
> > > Sherri,
> > >
> > > Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> > > with code that I received from Microsoft. There is a workaround that's not
> > > "TO" bad.
> > >
> > > Cheers,
> > >
> > > Karl
> > >
> > > "Sherri French" wrote:
> > >
> > > > This sounded like such a good idea as I am trying something similar to Karl.
> > > > I thought of the one column table, but it would not let me put tables in the
> > > > detail rows. I tried putting the tables into the table footer rows and
> > > > repeating the table header, but the header would not repeat on each page.
> > > > So, upon reading your post, I put rectangles in the detail rows and then put
> > > > the tables inside the rectangles. It looked like it was going to work. But
> > > > when I tried to run my report, I got an error saying "The table â'table10â' is
> > > > contained inside a table detail row. Data regions are not allowed inside a
> > > > table detail row." for each table I tried to put inside the main table. Is
> > > > there a way around this? It's ridiculous that's there's no easy way to
> > > > repeat an item that contains a field on each page. Thanks.
> > > >
> > > > -Sherri
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Karl,
> > > > >
> > > > > Have you tried using a simple one column table to emulate the list. You'll
> > > > > need to put a rectangle in each cell before you then add fields. You can
> > > > > then use the Repeat On New Page flag for the table's group header.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Tom,
> > > > > >
> > > > > > Great idea with a limitation however.
> > > > > >
> > > > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > > > If it's not on the page, R/S can't "see it"
> > > > > >
> > > > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > > > assigned to it.
> > > > > >
> > > > > > This will happen in the list control extends past one page. This is exactly
> > > > > > the problem I'm having.
> > > > > >
> > > > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > > > for sure.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "Tom" wrote:
> > > > > >
> > > > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > > > refer to the textbox in the page header using the normal
> > > > > > > ReportItems!textbox.Value expression.
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > > > invoice at a time.
> > > > > > > >
> > > > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > > > on other criteria.
> > > > > > > >
> > > > > > > > Thank you again for your suggestion.
> > > > > > > >
> > > > > > > > Karl
> > > > > > > >
> > > > > > > > "MACNR" wrote:
> > > > > > > >
> > > > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > > > that at the top of the page. May work a little better
> > > > > > > > >
> > > > > > > > > "Karl 140.6" wrote:
> > > > > > > > >
> > > > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > > > >
> > > > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > > > reports.
> > > > > > > > > >
> > > > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > > > >
> > > > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > > > invoice number not printing on the page.
> > > > > > > > > >
> > > > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > > > with .pdf rendering.
> > > > > > > > > >
> > > > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > > > >
> > > > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > > > >
> > > > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > > > working fine.
> > > > > > > > > >
> > > > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > > > >
> > > > > > > > > > Please help and thank you so very much,
> > > > > > > > > >
> > > > > > > > > > Karl|||Everyone,
Below is email I received from Microsoft with the solution. I hope this
work around helps everyone.
As I discussed with Karl, the issue want assistance with is generating a
report with Invoice Number (or some other group information) appearing in the
Page Header. I am attaching a project with a single report that accomplishes
this objective. I created a custom function and used it to store the data
between pages. The code for that function is:
Shared employeeID as Object
Public Function GetGroupEmployeeID(empID as Object) as Object
If Not (empID is Nothing)
If Not employeeID = empID
employeeID = empID
End If
End If
return employeeID
End Function
The text box at the top of the form gets the value:
=Code.GetGroupEmployeeID(ReportItems!EmployeeID.Value)
Note that EmployeeID is the name of the text box in the top left of the
outer List. It must be in the list, but you can set its Visibility.Hidden
property to true. You access the custom code section of a report by right
clicking on the report layout background and choosing properties. Then go to
the code tab and enter your code.
This custom function is just a sample of what you want to do. It is not the
solution to your problem. It uses a single, shared variable. This means
that multiple individuals rendering reports simultaneously can cause
unpredictable behavior. The real solution would be to create a custom
assembly that uses a Hashtable and access it within your custom function.
Pass the Globals!UserID and the value you want to store
(ReportItems!EmployeeID.Value in this case) and manage them there.
"Karl 140.6" wrote:
> Sorry if this is a repeat question. I've been searching for three hours
> trying to find a solution to a simple problem. Thank you in advance.
> I have a report with a list control that has 20 textboxes and three sub
> reports.
> The report usually renders between 1-3 pages, depending on the content.
> The report is an invoice report. All I want to do, is repeat the invoice
> number at the top of each page. I know the textbox trick, but with a list
> control, I can't guarantee that this control will be on each rendered page.
> It's on the first page so the invoice number will print at the top. But on
> all other pages, that control does not get rendered, which results in the
> invoice number not printing on the page.
> I have tried nesting list controls but this does not work either, especially
> with .pdf rendering.
> I understand the how's and why's Reporting Services renders reports.
> But this functionality is basic and really a requirement for reports like
> invoices where having the invoice number on each page is a requirement.
> I also have to be able to print more that one invoice at a time. Currently
> my dataset returns all invoice that need printing. My page breaking is
> working fine.
> I just can't get the invoice number on each rendered page.
> Please help and thank you so very much,
> Karl
Subscribe to:
Posts (Atom)