Replacing "Reporting Services Error" page with custom one?

Hi All!!
Looked everywhere... I think ;)
Is there a way to replace/override the "Reporting Services Error" page.
Tried with customErrors on in web.config as well as a onError method in
a httpModule. None of these seems to fetch the errors from reporting
services. Is the error handled internally, without raising i error to
the IIS?
I would like to be able to parse the error content, and in some cases
replace it with a more userfriendly version.
Is there a way?
Regards
Jonas MontonenThis is not a supported scenario. We did not create any mechanism for doing
this. All errors are handled internally and we almost always return success
from the http call.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonas Montonen" <jonas.montonen@.ascade.se> wrote in message
news:u5zl5PY%23EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Hi All!!
> Looked everywhere... I think ;)
> Is there a way to replace/override the "Reporting Services Error" page.
> Tried with customErrors on in web.config as well as a onError method in a
> httpModule. None of these seems to fetch the errors from reporting
> services. Is the error handled internally, without raising i error to the
> IIS?
> I would like to be able to parse the error content, and in some cases
> replace it with a more userfriendly version.
> Is there a way?
> Regards
> Jonas Montonen

Replacement Root Query string

anyone can tell me how it is used it in Reportviewer to render
drillthrough links in the same page. I have been experimenting for a
while. would like to know if anything i need to take care of
thanx
raviHere's a thread on this topic:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/fc71a51d020123ed/a295a0d77da59b6c?q=replacementroot&_done=%2Fgroup%2Fmicrosoft.public.sqlserver.reportingsvcs%2Fsearch%3Fq%3Dreplacementroot%26start%3D10%26&_doneTitle=Back+to+Search&&d#a295a0d77da59b6c
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
news:1109378507.771712.185840@.g14g2000cwa.googlegroups.com...
> anyone can tell me how it is used it in Reportviewer to render
> drillthrough links in the same page. I have been experimenting for a
> while. would like to know if anything i need to take care of
> thanx
> ravi
>|||Building on the thread I linked below...
In the code behind the page that contains ReportViewer, you need to set the
ReplacementRoot property, something like this:
reportView.ReplacementRoot = Protocol +
Request.ServerVariables["SERVER_NAME"] + Port + Request.FilePath +
"?report=";
You also have to add a bit more code to strip out extra rc: parameters that
build up as the user clicks on links. I hope that makes sense.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:uWnN6inHFHA.2620@.tk2msftngp13.phx.gbl...
> Here's a thread on this topic:
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/fc71a51d020123ed/a295a0d77da59b6c?q=replacementroot&_done=%2Fgroup%2Fmicrosoft.public.sqlserver.reportingsvcs%2Fsearch%3Fq%3Dreplacementroot%26start%3D10%26&_doneTitle=Back+to+Search&&d#a295a0d77da59b6c
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "RemoteDeploy" <bofobofo@.yahoo.com> wrote in message
> news:1109378507.771712.185840@.g14g2000cwa.googlegroups.com...
>> anyone can tell me how it is used it in Reportviewer to render
>> drillthrough links in the same page. I have been experimenting for a
>> while. would like to know if anything i need to take care of
>> thanx
>> ravi
>|||Hello Jeff,
Thanks for the reply. And I will make sure I dont create multiple
threads of the same topic.
Sadly, the problem still exists. I havent had time to work much on the
interface for the past week or so. I tried all you have said and also
looked at your past posts regarding this topic. I am send the code I
have regarding this whole thing. If you can tell where the problem is i
will appreciate very much.
I have a treeview control, which uses the ListChildren method of RS web
service to get all the reports listed as a tree. When I click on a
report (or rather the selected node changes) the following event is
fired.
BEGIN SUB---
Private Sub TreeView1_SelectedIndexChange(ByVal sender As Object, ByVal
e As Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs) Handles
TreeView1.SelectedIndexChange
Dim curnode As Microsoft.Web.UI.WebControls.TreeNode
curnode = TreeView1.GetNodeFromIndex(e.NewNode)
Xflag = True
ReportViewer1.ServerUrl = "http://serverIP/ReportServer"
ReportViewer1.ReportPath = curnode.ID
ReportViewer1.Toolbar = ReportViewer.multiState.True
ReportViewer1.Zoom = "95"
ReportViewer1.ReplacementRoot =Server.UrlEncode("http://localhost/Reportdashboard/default.aspx?Report=")
If (ReportViewer1.ReportPath.IndexOf("&rc") > 0) Then
ReportViewer1.ReportPath =ReportViewer1.ReportPath.Substring(0,
ReportViewer1.ReportPath.IndexOf("&rc"))
End If
ReportViewer1.Visible = True
END SUB.--
And this is the code i use to populate the Treeview will loading the
default page
BEGIN SUB--
Private Sub LoadSampleReports()
Dim rs As New ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim newNode As Microsoft.Web.UI.WebControls.TreeNode
For Each item In rs.ListChildren("/PGR1", False)
If item.Type = ItemTypeEnum.Report Then
newNode = New Microsoft.Web.UI.WebControls.TreeNode
newNode.Text = item.Name
newNode.ID = item.Path
newNode.Type = item.Type.ToString
newNode.HoverStyle.CssText ="font-size:8pt;color:dimgray;font-family:MS Sans
Serif;font-weight:bold;"
newNode.DefaultStyle.CssText = "font:MS Sans
Serif;color:Indigo; background:white;font-size:8pt"
& "/default.aspx?/PGR1/Averiguaciones" &
"&rc:LinkTarget=Myframe"
newNode.Expanded = False
newNode.Expandable =Microsoft.Web.UI.WebControls.ExpandableValue.Auto
TreeView1.Nodes.Add(newNode)
End If
Next
End Sub
END SUB---
When I click on a drillthrough link, it is opening the default page
again but without the report.
and the following is the URL associated with a drillthrough link
--
http://localhost/Reportdashboard/default.aspx?Report=http%3a%2f%2fserverIP%2fReportServer%3f%252fPGR1%252fPersonalPGR%26param_O2%3dAAAJ710623%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252flocalhost%252fReportdashboard%252fdefault.aspx%253fReport%253d
--
Reportdashboard is the Web app.
Thanks very much
Ravi|||Okay, here's a tangent. If you test the reports in the report manager, does
the drill through work correctly?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Ravi R" <bofobofo@.yahoo.com> wrote in message
news:1109898353.744329.74340@.z14g2000cwz.googlegroups.com...
> Hello Jeff,
> Thanks for the reply. And I will make sure I dont create multiple
> threads of the same topic.
> Sadly, the problem still exists. I havent had time to work much on the
> interface for the past week or so. I tried all you have said and also
> looked at your past posts regarding this topic. I am send the code I
> have regarding this whole thing. If you can tell where the problem is i
> will appreciate very much.
> I have a treeview control, which uses the ListChildren method of RS web
> service to get all the reports listed as a tree. When I click on a
> report (or rather the selected node changes) the following event is
> fired.
> BEGIN SUB---
> Private Sub TreeView1_SelectedIndexChange(ByVal sender As Object, ByVal
> e As Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs) Handles
> TreeView1.SelectedIndexChange
> Dim curnode As Microsoft.Web.UI.WebControls.TreeNode
> curnode = TreeView1.GetNodeFromIndex(e.NewNode)
> Xflag = True
> ReportViewer1.ServerUrl = "http://serverIP/ReportServer"
> ReportViewer1.ReportPath = curnode.ID
> ReportViewer1.Toolbar = ReportViewer.multiState.True
> ReportViewer1.Zoom = "95"
> ReportViewer1.ReplacementRoot => Server.UrlEncode("http://localhost/Reportdashboard/default.aspx?Report=")
> If (ReportViewer1.ReportPath.IndexOf("&rc") > 0) Then
> ReportViewer1.ReportPath => ReportViewer1.ReportPath.Substring(0,
> ReportViewer1.ReportPath.IndexOf("&rc"))
> End If
> ReportViewer1.Visible = True
> END SUB.--
> And this is the code i use to populate the Treeview will loading the
> default page
> BEGIN SUB--
> Private Sub LoadSampleReports()
> Dim rs As New ReportingService
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> Dim newNode As Microsoft.Web.UI.WebControls.TreeNode
> For Each item In rs.ListChildren("/PGR1", False)
> If item.Type = ItemTypeEnum.Report Then
> newNode = New Microsoft.Web.UI.WebControls.TreeNode
> newNode.Text = item.Name
> newNode.ID = item.Path
> newNode.Type = item.Type.ToString
> newNode.HoverStyle.CssText => "font-size:8pt;color:dimgray;font-family:MS Sans
> Serif;font-weight:bold;"
> newNode.DefaultStyle.CssText = "font:MS Sans
> Serif;color:Indigo; background:white;font-size:8pt"
> & "/default.aspx?/PGR1/Averiguaciones" &
> "&rc:LinkTarget=Myframe"
> newNode.Expanded = False
> newNode.Expandable => Microsoft.Web.UI.WebControls.ExpandableValue.Auto
> TreeView1.Nodes.Add(newNode)
> End If
> Next
> End Sub
> END SUB---
> When I click on a drillthrough link, it is opening the default page
> again but without the report.
> and the following is the URL associated with a drillthrough link
> --
> http://localhost/Reportdashboard/default.aspx?Report=http%3a%2f%2fserverIP%2fReportServer%3f%252fPGR1%252fPersonalPGR%26param_O2%3dAAAJ710623%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252flocalhost%252fReportdashboard%252fdefault.aspx%253fReport%253d
> --
> Reportdashboard is the Web app.
>
> Thanks very much
> Ravi
>|||Hello Jeff,
Yes the drillthrough and the drilldown both work fine in the
ReportManager.
Thanks
Ravi|||Hello Jeff,
The following are the URLs First one from the ReportManager where the
drillthrough works. And the second one from my web app.
The reportserver is running on another machine.
http://servename/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2fservername%2fReportServer%3f%252fPGR1%252fPersonalPGR%26param_1%3dAACA7113%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252fservername%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d
------
http://localhost/Reportdashboard/default.aspx?ServerUrl=http%3a%2f%2fservername%2fReportServer%3f%252fPGR1%252fPersonalPGR%26param_1%3dAACA7113%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252flocalhost%252fReportdashboard%252fdefault.aspx%253fServerUrl%253d
------
Thanks
Ravisql

Replace LoginName control with other data fields from aspnetdb.mdf

I currently have a LoginStatus and LoginName control on my asp.net 2.0 master page. When successfully logged in a message displays "You are logged in as" LoginName. Since I am using the user's e-mail address as the UserName the message will display as "You are logged in as johndoe@.foo.com".

What I want to do is have the message display as "You are logged in as " FirstName LastName. FirstName and LastName are two new fields that I added to the table, aspnet_Users.

What I have done is to use the FormView control to display FirstName and LastName; however this always displays the first record in the aspnetdb database.

Is there a cleaner way (than the FormView control) to display the requested data, using the currently logged in user? I have access to Microsoft Expression Web and Visual Studio 2005, but I prefer Expression Web.

Thank you in advance

Hi,

From your description, it seems that you want to get the FirstName and LastName field for the logon user, right?

If so, I think you can get the current user's name by using User.Identity.Name, and then, invoke the GetUser method of Membership with the current user's name, which can return a MembershipUser typed object. You can access the data filed in the membership tables.

Thanks.

repeatwith property

I have tried for days to get certain textboxes and tables in page body

to repeat on multiple page reports

Any help is appreciated.

Hello,

The repeatwith property is not available on tables and is not supported by physical paginated renderes.

However, the RepeateOnNewPage property of table&group headers and footers is supported by all renderers.

Thank you,

Nico

|||

How to transfer parameter to Header and display it on next page.

I reference one report textbox to header textbox "= ReportItems!textbox1.Value "

But it didn't display on second page....

What can I do?

|||

Hello,

Could you provide the rdl so I can understand what you are trying to achieve?

Thanks,

Nico

|||

How to use static query in my header textbox

= "SELECT [Contractor Name] FROM tblvendor WHERE vendorID=" & Parameters!vendorID.Value

It display the text "SELECT [Contractor Name] FROM tblvendor WHERE vendorID=354" not the query result

RepeatWith problem

I have a report where, among other things, I want to show a multi-page table
with some text on top of each page containing that table. So I placed a
textbox above the table and set the RepeatWith property of that textbox to
repeat with the table.
But when I run the report , the textbox is not there (except on the first
page).
However if I place the same textbox next to the table (on either side) then
the textbox shows up with each new page. Is this by design or is this a bug?
Does RepeatWith actually mean RepeatNextTo?Isaak,
I had a similar issue however I put both the textbox and the table inside
a list box to keep them together. Both were tied to the same dataset (since
I had read that could be an issue). and I had the box checked on the advanced
properties of the textbox to repeat item with data region on new page ==> and
the data region was the table just below it. It didnt work. I had to
abandon that idea and create a TABLE HEADER which contained the field that I
wanted to put in the textbox. I checked to repeat table header on each new
page ... and I have been able to see that work perfectly for my situation.
Hope this helps you ... I would *still* like to know why the Repeat Item is
NOT working ... as the table header solution wont be useful in all cases.
"isaak" wrote:
> I have a report where, among other things, I want to show a multi-page table
> with some text on top of each page containing that table. So I placed a
> textbox above the table and set the RepeatWith property of that textbox to
> repeat with the table.
> But when I run the report , the textbox is not there (except on the first
> page).
> However if I place the same textbox next to the table (on either side) then
> the textbox shows up with each new page. Is this by design or is this a bug?
> Does RepeatWith actually mean RepeatNextTo?
>|||I contacted Microsoftt about this problem and was able to confirm that
this is an outstanding issue with Reporting Services 2005. Microsoft has
scheduled a fix for the problem in the next release of SQL Server, which
should be available in 18-24 months.
"MJT" wrote:
> Isaak,
> I had a similar issue however I put both the textbox and the table inside
> a list box to keep them together. Both were tied to the same dataset (since
> I had read that could be an issue). and I had the box checked on the advanced
> properties of the textbox to repeat item with data region on new page ==> and
> the data region was the table just below it. It didnt work. I had to
> abandon that idea and create a TABLE HEADER which contained the field that I
> wanted to put in the textbox. I checked to repeat table header on each new
> page ... and I have been able to see that work perfectly for my situation.
> Hope this helps you ... I would *still* like to know why the Repeat Item is
> NOT working ... as the table header solution wont be useful in all cases.
> "isaak" wrote:
> > I have a report where, among other things, I want to show a multi-page table
> > with some text on top of each page containing that table. So I placed a
> > textbox above the table and set the RepeatWith property of that textbox to
> > repeat with the table.
> > But when I run the report , the textbox is not there (except on the first
> > page).
> > However if I place the same textbox next to the table (on either side) then
> > the textbox shows up with each new page. Is this by design or is this a bug?
> > Does RepeatWith actually mean RepeatNextTo?
> >

RepeatWith not working

Hi,
I have listing with a few rectangles and one table in it.
One two recetangles at top of page I have set the RepeatWith to be set to
name of the table (table1).
When the table spans multiple pages, I would expect that the two rectangles
would be repeated at the top of the page.
This does not work. The RepeatWith property appears to have no effect.
Is there is good work-around or fix for this?
What I am trying to accomplish is having a few header values and a logo
repeated on all pages.
Thanks,
KevinI'm not sure how to use RepeatWith, but have you tried using a page
header? In the report designer, go to the Report menu, select Page
Header. Then put your logo etc in the page header area.
Eva Pierce Monsen
Kevin VanRiper wrote:
> Hi,
> I have listing with a few rectangles and one table in it.
> One two recetangles at top of page I have set the RepeatWith to be set to
> name of the table (table1).
> When the table spans multiple pages, I would expect that the two rectangles
> would be repeated at the top of the page.
> This does not work. The RepeatWith property appears to have no effect.
> Is there is good work-around or fix for this?
> What I am trying to accomplish is having a few header values and a logo
> repeated on all pages.
> Thanks,
> Kevin|||I tried Page Header but this does not allow values from my dataset to be
placed there.
I found on a MS blog a work-around to use a Report Parameter to be able to
place dataset value into Page Header but this did not update to correct /
current value of the listing but remained with the value of the first
record.
"Eva Pierce Monsen" <eva.monsen@.gmail.com> wrote in message
news:1150921305.672198.191490@.i40g2000cwc.googlegroups.com...
> I'm not sure how to use RepeatWith, but have you tried using a page
> header? In the report designer, go to the Report menu, select Page
> Header. Then put your logo etc in the page header area.
> Eva Pierce Monsen
> Kevin VanRiper wrote:
>> Hi,
>> I have listing with a few rectangles and one table in it.
>> One two recetangles at top of page I have set the RepeatWith to be set to
>> name of the table (table1).
>> When the table spans multiple pages, I would expect that the two
>> rectangles
>> would be repeated at the top of the page.
>> This does not work. The RepeatWith property appears to have no effect.
>> Is there is good work-around or fix for this?
>> What I am trying to accomplish is having a few header values and a logo
>> repeated on all pages.
>> Thanks,
>> Kevin
>

RepeatOnNewPage

I have this property set to true for several table header rows in a table
that I want repeated on each page. It doesn't seem to be working. it
displays on the first page and that's it... Any ideas...?
TIA,
DanWhich property have you set to true..'
there is a 'RepeatOnNewPage' property which will set for the whole page
header. you don't really set them one by one. you can click this on the most
left of your header row. one thing to indicate that you are clicking the
right thing is that, it will select the whole row, and show the
RepeatOnNewPage property.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> I have this property set to true for several table header rows in a table
> that I want repeated on each page. It doesn't seem to be working. it
> displays on the first page and that's it... Any ideas...?
> TIA,
> Dan
>|||The property name is RepeatOnNewPage, I have it set to true and it's not
repeating, displays only on the first page...
Dan
"Daniel" <danielk@.adstream.com.au> wrote in message
news:OJ8Pg7ofEHA.2896@.TK2MSFTNGP11.phx.gbl...
> Which property have you set to true..'
> there is a 'RepeatOnNewPage' property which will set for the whole page
> header. you don't really set them one by one. you can click this on the
most
> left of your header row. one thing to indicate that you are clicking the
> right thing is that, it will select the whole row, and show the
> RepeatOnNewPage property.
>
> "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
wrote
> in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have this property set to true for several table header rows in a
table
> > that I want repeated on each page. It doesn't seem to be working. it
> > displays on the first page and that's it... Any ideas...?
> >
> > TIA,
> >
> > Dan
> >
> >
>|||Does that table only have items on the first page? If so that is your
problem. What it really should say is repeat on every page which has
items in this table.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote in message news:<evwuUEvfEHA.592@.TK2MSFTNGP11.phx.gbl>...
> The property name is RepeatOnNewPage, I have it set to true and it's not
> repeating, displays only on the first page...
> Dan
>
> "Daniel" <danielk@.adstream.com.au> wrote in message
> news:OJ8Pg7ofEHA.2896@.TK2MSFTNGP11.phx.gbl...
> > Which property have you set to true..'
> > there is a 'RepeatOnNewPage' property which will set for the whole page
> > header. you don't really set them one by one. you can click this on the
> most
> > left of your header row. one thing to indicate that you are clicking the
> > right thing is that, it will select the whole row, and show the
> > RepeatOnNewPage property.
> >
> >
> >
> > "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
> wrote
> > in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> > > I have this property set to true for several table header rows in a
> table
> > > that I want repeated on each page. It doesn't seem to be working. it
> > > displays on the first page and that's it... Any ideas...?
> > >
> > > TIA,
> > >
> > > Dan
> > >
> > >
> >
> >

Repeating table headers overwriting data

I'm using RS2000 SP2 and am getting an issue when exporting to PDF. If I have a table that spans more than one page and I set the RepeatHeaderOnNewPage to True, then on occasion the table header will be displayed on top of the first few rows of data. It does not happen on all the pages or all the time and I can not find any information on this issue. Has anyone come across this before and solved it?

Hi,

Did you ever solve this problem? The same things is happening to me and I can't figure it out....

Barbara|||

Hi Barbara,

Unfortunately I was never able to solve this issue using RS 2000. In the end I turned off the repeating headers. I came to the conclusion that it was a bug in Microsofts PDF rendering engine.

I did run the same report using RS 2005 and it worked fine, but I'm not sure that will be of any help to you.

Regards,

Jeff.

Repeating table headers overwriting data

I'm using RS2000 SP2 and am getting an issue when exporting to PDF. If I have a table that spans more than one page and I set the RepeatHeaderOnNewPage to True, then on occasion the table header will be displayed on top of the first few rows of data. It does not happen on all the pages or all the time and I can not find any information on this issue. Has anyone come across this before and solved it?

Hi,

Did you ever solve this problem? The same things is happening to me and I can't figure it out....

Barbara|||

Hi Barbara,

Unfortunately I was never able to solve this issue using RS 2000. In the end I turned off the repeating headers. I came to the conclusion that it was a bug in Microsofts PDF rendering engine.

I did run the same report using RS 2005 and it worked fine, but I'm not sure that will be of any help to you.

Regards,

Jeff.

Repeating table header on "every" page

Hi guys,

I have a question and want to ask you a favor in terms of question. How do I let a table header repeat on every page. I know the "repeat on every page" property and I set that to true, but the problem is that, when the table is not displayed on a certain page, the header doesn't get displayed, especially if the sub-report in the page is large. In other words table is not displaying header on every page when itself is not on every page or something like that? I want that table header to repeat on every single page without glitching.

Any help and pointers?

Thanks for the help,

Enkh.

I have created many reports with subreports. Have you considered making one generic header in the header of the page? It will print on every page, even the subreports. Then you can add a simple text box if you want some unique text for a subreport. Just a thought.

Repeating subreport header on each page

Hi All

I'm new to Crystal XI so have a basic question for you guys. I have a report with 3 subreports and sometimes some of the subreports run onto more than one page. I would like to be able to repeat the subreport header on each page when this happens. Any ideas?

Much appreciated
OzHello I have got the same problem but, I am using the version 8.5.0.217

I have a report with 3 subreports each one giving some totally different information from one to the other and only the Header of the main report has common information. I need to print a subreport header in each page this subreports needs

Example
TITLE
A.- details main rep
B.- subreport_1
b.0 Title Subreport_1
b.1 detail Subreport_1
C.- subreport_2
c.0 title subreport_2
c.1 detail Subreport_2
D.- subreport_3
d.0 title Subreport_3
d.1 detail Subreport_3

The page header involves TITLE + A (details main rep)
The report detail involves the different subreports (B+C+D).
I need this b.0 (Title Subreport_1) line at the top of each page (under the main report Page header) the Subreport 1 is displaying.

Do you have any idea about how to solve this? Thank you very much

Repeating Rows

Is there any way by which we can force to repeat the column headers to repeat
if the page changes. Like in EXCEL where we can mention those rows that need
to be repeat with the new pages.
ThanksClick on the header of the table (far left), there is a property called
repeatonnewpage that you set to true.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Asim" <Asim@.discussions.microsoft.com> wrote in message
news:7DD34123-91DC-44CD-BB57-9A2C018292AC@.microsoft.com...
> Is there any way by which we can force to repeat the column headers to
repeat
> if the page changes. Like in EXCEL where we can mention those rows that
need
> to be repeat with the new pages.
> Thanks
>|||Thanks! This is a matrix and when i go in properties of the particular FIELD
(Months), there is an option (ADVANCED TAB) which says
"REPEAT REPORT ITEM WITH DATA REGION ON EVERY PAGE" and then you can pick up
the specific data region from drop down. The problem here is that this option
is not available for me and couldnt be chosen.
"Bruce L-C [MVP]" wrote:
> Click on the header of the table (far left), there is a property called
> repeatonnewpage that you set to true.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Asim" <Asim@.discussions.microsoft.com> wrote in message
> news:7DD34123-91DC-44CD-BB57-9A2C018292AC@.microsoft.com...
> > Is there any way by which we can force to repeat the column headers to
> repeat
> > if the page changes. Like in EXCEL where we can mention those rows that
> need
> > to be repeat with the new pages.
> > Thanks
> >
>
>|||Sorry, can't help you with the matrix problem you are having.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Asim" <Asim@.discussions.microsoft.com> wrote in message
news:AF07B84C-4D5A-4032-9BD5-014A795A6F6B@.microsoft.com...
> Thanks! This is a matrix and when i go in properties of the particular
FIELD
> (Months), there is an option (ADVANCED TAB) which says
> "REPEAT REPORT ITEM WITH DATA REGION ON EVERY PAGE" and then you can pick
up
> the specific data region from drop down. The problem here is that this
option
> is not available for me and couldnt be chosen.
>
> "Bruce L-C [MVP]" wrote:
> > Click on the header of the table (far left), there is a property called
> > repeatonnewpage that you set to true.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
> > news:7DD34123-91DC-44CD-BB57-9A2C018292AC@.microsoft.com...
> > > Is there any way by which we can force to repeat the column headers to
> > repeat
> > > if the page changes. Like in EXCEL where we can mention those rows
that
> > need
> > > to be repeat with the new pages.
> > > Thanks
> > >
> >
> >
> >

Repeating report item in page header

Hi,
In a SSRS 2005 I am having a problem:
My report consists of one table report en multiple subreports.
The report and subreports have to be paged by product. So page 1 contains
the data of product 1 for the report + each subreport.
I've achieved this by putting the report and subreports within a list item,
which is grouped by product.
To put the product of the current page in the header I put product on the
dataset of the report and put it in a textbox on the report. Next I put the
product in the header by refrencing the textbox with
=reportitems!product.value.
My problem with this solution is that when 1 product generates more then one
page, I only see the product in the header of the first page. The header of
the next page is empty. I would like to see the product repeated on every
page until the page shows the next product.
Does anyone have a solution or work-around for this?Hi Pieter,
not sure whether the following will help (or that you've tried this
already). If you select the table, right click and select 'properties' and in
the tab 'general' you'll see at the bottom the following option: 'repeat
header rows on each page'... you can even select that the header needs to
remain visible when scrolling. You'll have to tick both options if you want
the header to remain visible while scrolling on all pages.
hope it helps & best regards,
mischa
"Pieter M" wrote:
> Hi,
> In a SSRS 2005 I am having a problem:
> My report consists of one table report en multiple subreports.
> The report and subreports have to be paged by product. So page 1 contains
> the data of product 1 for the report + each subreport.
> I've achieved this by putting the report and subreports within a list item,
> which is grouped by product.
> To put the product of the current page in the header I put product on the
> dataset of the report and put it in a textbox on the report. Next I put the
> product in the header by refrencing the textbox with
> =reportitems!product.value.
> My problem with this solution is that when 1 product generates more then one
> page, I only see the product in the header of the first page. The header of
> the next page is empty. I would like to see the product repeated on every
> page until the page shows the next product.
> Does anyone have a solution or work-around for this?

Repeating Group headers on reports with subreports

I have a report that contains a table. The group header in the table is set
to repeat on a new page. However, as soon as I place a subreport in the table
of the main report and that subreport causes a page break...the group header
on the top-level report doesn't repeat. Is there a workaround for this
shortcoming?
Regards,
Dean NeroNero,
Did you ever find an answer for this? I am having the same issue...and
its killin' me!
Michael
"Dean Nero" wrote:
> I have a report that contains a table. The group header in the table is set
> to repeat on a new page. However, as soon as I place a subreport in the table
> of the main report and that subreport causes a page break...the group header
> on the top-level report doesn't repeat. Is there a workaround for this
> shortcoming?
> Regards,
> Dean Nero

Repeating Group Footer in a Subreport

I have a subreport that can be pages long. On each page, I need the group footer repeated. I can get the header to repeat, but not the footer.
Any help will be greatly appreciated!I think you can't.. as it appears at the end of the group...
could you use the page footer ?

Luc|||Thanks for letting me know that I can't repeat the group footer - now I'll have to try and take a different approach!

I suppose I could try sticking the subreports in the detail, so that I could have a page footer... I'll try it and see how it goes.

Repeating Footer on every page when printing

Using RS2005, but the same thing happened on RS2000.
This report has 4 matrices and 4 charts which causes the report to print on
3 pages of 11in by 8.5in paper (landscape). I have a Footer that references a
textbox in the body of the report, but when the report is printed, the footer
only appears on the last page. The textbox that the footer is referring to
has an aggregate expression in it such as First(Fields!REVIEW_MONTH.Value,
"Datasetname"). The Footer has the following expression: "= ReportItems!textbox53.value". I have tried everything including vertically
stretching textbox53 across all of the objects in the body. This almost
worked because the footer did appear on pages 1 & 2, but not page 3.
Can someone please help me. Thanks.
--
-RB
:)FYI - I found the solution by contacting MSN support.
The key is to create a hidden report parameter. In the default values
section, use "From Query" and select the dataset and the field that is
desired to be displayed in the footer. Then just reference the Hidden
parameter within a Textbox of the Page Footer. Now, the Page Footer will
repeat on every page of the report regardless of the number of different data
regions. The report parameter is treated like a Global variable in this
scenario.
--
-RB
:)
"capricorn" wrote:
> Using RS2005, but the same thing happened on RS2000.
> This report has 4 matrices and 4 charts which causes the report to print on
> 3 pages of 11in by 8.5in paper (landscape). I have a Footer that references a
> textbox in the body of the report, but when the report is printed, the footer
> only appears on the last page. The textbox that the footer is referring to
> has an aggregate expression in it such as First(Fields!REVIEW_MONTH.Value,
> "Datasetname"). The Footer has the following expression: "=> ReportItems!textbox53.value". I have tried everything including vertically
> stretching textbox53 across all of the objects in the body. This almost
> worked because the footer did appear on pages 1 & 2, but not page 3.
> Can someone please help me. Thanks.
> --
> -RB
> :)

Repeating data regions on every page

Hi all, I want to create an invoice that will repeat numbers dates and
shipping info on every page that the list of items grows on to. You know,
to simulate a standard preprinted invoice page but fully generated by
reporting services.
Any assistance is appreciated.
Raul RubioThe sample report, at the end of this posting, should point in the direction
you need to go.
Since you will have a fairly regular structure I suggest that you use a
table instead of lists.
I think you will find them much easier to work with than a List which
contains a number of textboxes.
Note the use of the table group on OrderID.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raul R" <roller8@.hotmail.com> wrote in message
news:e%23qgdx$nEHA.2900@.TK2MSFTNGP09.phx.gbl...
> Hi all, I want to create an invoice that will repeat numbers dates and
> shipping info on every page that the list of items grows on to. You know,
> to simulate a standard preprinted invoice page but fully generated by
> reporting services.
> Any assistance is appreciated.
> Raul Rubio
>
SampleInvoice.rdl
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Table Name="table1">
<Height>1.5in</Height>
<Style />
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>17</ZIndex>
<rd:DefaultName>textbox1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Order ID</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>16</ZIndex>
<rd:DefaultName>textbox2</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Order Date</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>15</ZIndex>
<rd:DefaultName>textbox3</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>Country</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="ProductName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>ProductName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!ProductName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="UnitPrice">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>UnitPrice</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!UnitPrice.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Quantity">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>Quantity</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!Quantity.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<DataSetName>Northwind</DataSetName>
<TableColumns>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="OrderID">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>14</ZIndex>
<rd:DefaultName>OrderID</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Fields!OrderID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="OrderDate">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>13</ZIndex>
<rd:DefaultName>OrderDate</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!OrderDate.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>12</ZIndex>
<rd:DefaultName>textbox12</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>11</ZIndex>
<rd:DefaultName>CompanyName</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!CompanyName.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="City">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>10</ZIndex>
<rd:DefaultName>City</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!City.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Country">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>9</ZIndex>
<rd:DefaultName>Country</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=First(Fields!Country.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="OrderIDGroup">
<GroupExpressions>
<GroupExpression>=Fields!OrderID.Value</GroupExpression>
</GroupExpressions>
<PageBreakAtEnd>true</PageBreakAtEnd>
</Grouping>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<rd:DefaultName>textbox4</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>textbox5</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Quantity_1">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<rd:DefaultName>Quantity_1</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!Quantity.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
</TableGroup>
</TableGroups>
<Footer>
<TableRows>
<TableRow>
<Height>0.25in</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>8</ZIndex>
<rd:DefaultName>textbox7</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>7</ZIndex>
<rd:DefaultName>textbox8</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>6</ZIndex>
<rd:DefaultName>textbox9</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
</Table>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>ca33ccc8-f580-468b-ae00-bdebbfd7a5f0</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>data source=localhost;initial
catalog=Northwind</ConnectString>
<IntegratedSecurity>true</IntegratedSecurity>
</ConnectionProperties>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="Northwind">
<Fields>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="City">
<DataField>City</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Country">
<DataField>Country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="OrderID">
<DataField>OrderID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="OrderDate">
<DataField>OrderDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="UnitPrice">
<DataField>UnitPrice</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="Quantity">
<DataField>Quantity</DataField>
<rd:TypeName>System.Int16</rd:TypeName>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT Customers.CompanyName, Customers.City,
Customers.Country, Orders.OrderID, Orders.OrderDate, [Order
Details].UnitPrice, [Order Details].Quantity,
Products.ProductName
FROM Customers INNER JOIN
Orders ON Customers.CustomerID = Orders.CustomerID
INNER JOIN
[Order Details] ON Orders.OrderID = [Order
Details].OrderID INNER JOIN
Products ON [Order Details].ProductID =Products.ProductID</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>4d305298-f219-4b15-ab25-32b10f38c465</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>

Repeating data on every page's header

My report has 9 subreports. When main report has 3 records then this report
goes into loop and run these 9 subreports 3 times. But I want the heading
in all the pages and should change the data as record changes.. This report
can be 30 - 40 pages long.
I am giving you an example on my report.
Suppose I want to show the detail of 3 staffs.
A, B and C
In heading, I want to show the name, age and gender of staff which will
change on next record.
In detail, In 1st subreport shows the brothers of the staff and 2nd
subreport shows the sisters of that staff etc.
I want to show the heading in all the page.
ThanksYou would have created a group in the table.. you have to check "Repeat
Group Header" checkbox.
Include Name,age, gender in Group Header in the table.
Edit Group -> General Tab -> Check Repeat Group Header.
hth
"Savita Gupta" <savita.r.gupta@.au.pwc.com> wrote in message
news:e6XRIZfoEHA.324@.TK2MSFTNGP11.phx.gbl...
> My report has 9 subreports. When main report has 3 records then this
> report
> goes into loop and run these 9 subreports 3 times. But I want the heading
> in all the pages and should change the data as record changes.. This
> report
> can be 30 - 40 pages long.
> I am giving you an example on my report.
> Suppose I want to show the detail of 3 staffs.
> A, B and C
> In heading, I want to show the name, age and gender of staff which will
> change on next record.
> In detail, In 1st subreport shows the brothers of the staff and 2nd
> subreport shows the sisters of that staff etc.
> I want to show the heading in all the page.
> Thanks
>
>|||Can anyone help me.
"Savita Gupta" <savita.r.gupta@.au.pwc.com> wrote in message
news:e6XRIZfoEHA.324@.TK2MSFTNGP11.phx.gbl...
> My report has 9 subreports. When main report has 3 records then this
report
> goes into loop and run these 9 subreports 3 times. But I want the heading
> in all the pages and should change the data as record changes.. This
report
> can be 30 - 40 pages long.
> I am giving you an example on my report.
> Suppose I want to show the detail of 3 staffs.
> A, B and C
> In heading, I want to show the name, age and gender of staff which will
> change on next record.
> In detail, In 1st subreport shows the brothers of the staff and 2nd
> subreport shows the sisters of that staff etc.
> I want to show the heading in all the page.
> Thanks
>
>

Repeating Data On Each Page

Hi

Pulled all my hair out now, can someone please offer some help before I go totally mad...

I have no page header, this is all in the body. I have a List with account number and job number in it at the top, called list1. In list1 I have list2, with the job details, basically a list of people who attended the job. The fields in list2 are textboxes, they're not in a table.

EG:

Acc No: 12345

Job No: 54321

Name

Fred Bloggs

Joe Bloggs

Etc

When my list2 of names goes over 1 page, I want to repeat the account number and job number on each subsequent page. In my real report I actually have 10 fields I want to repeat.

I then want to be able to export this report to a PDF.

I can't put the header in the page header and RepeatWith doesn't work when exporting to PDF, or at all depending on what mood it's in.

Does anyone have a workaround for this please?

Cheers

Hi

I don't want to ask the obvious but why can't you use a table? I initially used listboxes for most of my reports but have since found that I can use tables for almost anything once I start merging cells and things like that.
|||

Hello.

I can't use a table because I have all different spacing between the columns and rows. It's not a list of data as in my example, I've just made it simpler in that so it's easier to understand the problem.

For info, in the meantime, I've used an answer provided at the top of this page http://forums.microsoft.com/msdn/showpost.aspx?postid=638813&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1 which I really didn't want to do because it's so damn messy. But it does mean I can have information in the page header and it appears on more than just the first page. Silly me for thinking I can use a Repeat property and it will actually work.

It's so funny reading posts, MSDN and websites about this problem when MS try to justify why this is so difficult to achieve and what the problems are behind it, as if it's something so out of the ordinary people will just accept it the reasoning behind it. I'd love to have been in that meeting where someone said we're releasing RS without the ability to put data in the page header/footer, surely they were sacked on the spot....weren't they?

Repeating data

I want a table with fields from the dataset that repeats for every page in
the report. How can I do this...?
DanHello,
Have you tried to put your fields in table or group header and ask for
repeat on noew page in report properties ?
Jerome Berthaud (MCSD)
http://www.winsight.fr
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:umDmb4$eEHA.1356@.TK2MSFTNGP09.phx.gbl...
> I want a table with fields from the dataset that repeats for every page in
> the report. How can I do this...?
> Dan
>