Solved

Help with creating an MS Report with multiple pages

Posted on 2012-04-01
7
315 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 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