Help with creating an MS Report with multiple pages

Hi,

I am putting my Textboxes directly on the form, is there a differemt approach when not using tables or other controls to include my textboxes?

Thanks.

Hi Victor,
You can put text boxes directly on the page as well. But for the functionality you need you will have to add the Tablix on the report anyhow.
However please look at this link, it may solve your problem. If possible have a look at the msdn article shared, it will help you a lot.

http://stackoverflow.com/questions/6698930/how-to-do-page-grouping-in-ssrs

Mark if helped.
Enjoy!!

Hello,

For some reason I can't find the Grouping pane.

I included two List controls on my form each containing two controls as shown below

List1:

Link_ID    Field Value
Receiver  Field Value


List 2
Donor       Field value
Item         Field value


For each record (Link_ID) I would like to see 2 pages.

Page 1:

Link_ID   1
Receiver BEL

Page 2:

Donor     CAN
Item        CAR

But instead I see

Page 1:

Link_ID   1
Receiver BEL

Link_ID   2
Receiver DEU

Link_ID   3
Receiver FRA

Page 2:

Donor      CAN
Item        CAR

Donor       USA
Item        TRUCK

Donor      ESP
Item        MOTOR


Below is the code I am using (Item part not included)

Dim dt As New DataTable()
        dt.TableName = "Links"
        dt.Columns.Add("Link_ID")

        dt.Columns.Add("Receiver")

        dt.Columns.Add("Donor")



        Dim linker As XElement = XElement.Load(Application.StartupPath + "\Link.xml")
        Dim receiver As XElement = XElement.Load(Application.StartupPath + "\Receiver.xml")
        Dim Donor As XElement = XElement.Load(Application.StartupPath + "\Donor.xml")



        For Each item As XElement In linker.Elements("Row")

            Dim linkID As String = item.Element("Link_ID").Value
            Dim receiverId As String = item.Element("Receiver_ID").Value
            Dim DonorID As String = item.Element("Donor_ID").Value 'Add (3)
            Dim receiverVal As String = String.Empty
            Dim xe As XElement = receiver.Elements("Row").Cast(Of XElement)().Where(Function(n) n.Element("Receiver_ID").Value = receiverId).FirstOrDefault()



            If xe IsNot Nothing Then

                receiverVal = xe.Element("Receiver").Value

            End If



            Dim DonorVal As String = String.Empty

            xe = Donor.Elements("Row").Cast(Of XElement)().Where(Function(n) n.Element("Donor_ID").Value = DonorID).FirstOrDefault()

            If xe IsNot Nothing Then

                DonorVal = xe.Element("Donor").Value

            End If


            Dim dr As DataRow = dt.NewRow()
            dr("Link_ID") = linkID
            dr("Receiver") = receiverVal
            dr("Donor") = DonorVal 'Add (5)
            dt.Rows.Add(dr)

        Next


        Dim bs As New BindingSource()

        bs.DataSource = dt
        'dt.WriteXml(" D:\XMLoutput.xml") - Use this trick to create XML to design report

        Dim reportDataSource As New Microsoft.Reporting.WinForms.ReportDataSource()
        'reportDataSource.Name = "DocumentElement_Links"
        reportDataSource.Name = "MyDataSet_Links"
        reportDataSource.Value = dt

        ReportViewer1.LocalReport.DataSources.Add(reportDataSource)
        ReportViewer1.LocalReport.Refresh()
        ReportViewer1.RefreshReport()

Any ideas why I am unable to get 2 pages per record?

Victor

Hi,

I increased the size of my for to 8.875in, 22.125in and increased
both Lists to 8.5 x 11, but it still doesn't work. The second List below doesn't appear when I run the report. Help!

Help!!

Help!