[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Help with creating an MS Report with multiple pages

Posted on 2012-04-01
7
Medium Priority
?
323 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 7

Accepted Solution

by:
dhawalseth earned 2000 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

656 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