Solved

Help with creating an MS Report with multiple pages

Posted on 2012-04-01
7
316 Views
Last Modified: 2012-05-16
Hello,


Where can I find the Group property to select particular column, page break tab  and check Between each instance ot the group. in order to create multiple pages. I can't seem to find it.

I am using VS 2008.

Victor
0
Comment
Question by:vcharles
  • 5
  • 2
7 Comments
 
LVL 7

Accepted Solution

by:
dhawalseth earned 500 total points
ID: 37795454
Hi Victor,

Please follow this link:
http://msdn.microsoft.com/en-us/library/ms156434(v=sql.100).aspx

Please mark this post as answer if helpful.
0
 

Author Comment

by:vcharles
ID: 37806510
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.
0
 
LVL 7

Expert Comment

by:dhawalseth
ID: 37809535
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!!
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:vcharles
ID: 37811874
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
0
 

Author Comment

by:vcharles
ID: 37812362
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!
0
 

Author Comment

by:vcharles
ID: 37906770
Help!!
0
 

Author Comment

by:vcharles
ID: 37909549
Help!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question