Solved

Help with creating an MS Report with multiple pages

Posted on 2012-04-01
7
309 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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now