sql - how to display parent record and children from multiple tables -

-

I have three tables, 1 parent with 2 parents 1-to-1 relationship with parents.
Table 1: People

I want a report that looks like this :

Person1:
First_Name ------- Last_name
Phone 1: ------ 12345 ---- Home - Phone 2: ----- - 54321 ---- Work
Mail 1: ------- first@mail.com .work
Mail 2: ------- first@mail.com .work
Mail 3: ---- ---first@mail.com .work

Person 2:
------- First_nem ------ - Last_name
Phone 1: ------ 12345 ---- Home - Phone 2: ------ 54321 ---- Work
mail1: ------- first @ Mail.com-- --work
Mail 2: ------- first @ mail.com @ w Ork
Mail 3: ------- first@mail.com.twork

I love using this reporting services.

EDIT: I know how to add all the tables with the left join, I have no idea how to get it done.

OK, this is a type of summary that you need to contact. I can not give you a step-by-step because it will be impossible long, but you should start it. (Also keep in mind that I am doing this with memory):

  1. You will need three datasets, for each one, phone number and email address. I'm assuming that there is a similar type of ID field in the phone number and email address, a way to call people and tie on an email address You will need that field in your area.

    You do not have to join your SQL: The report will be linked between three datasets.

  2. Put a matrix on your report Is it attracted by people's datasets? Enter the first and last name in the matrix expansion row.

  3. Under your first and last name, add a new extension line to your matrix.

  4. Combine cells in your new extension row so that you have a very wide cell.

  5. Embed (drag and drop) a new matrix in a single wide cell in its new extension row.

  6. Link your matrix to the phone dataset. Set up a record filter in the matrix to limit those records that match the ID field in the parent matrix.

  7. Set up the phone as much as you like in embedded hair matrix.

  8. Repeat step 3-7 dataset with email address.

You do not really need to create a group (unless you want to include any sort of subtotal) because you really do not group anything Are: displaying a list with just the embedded sub-lists


Comments

Post a Comment

Popular posts from this blog

winforms - C# Form - Property Change -

-
I have a form that has a property named car A class with many properties. The Properties is being displayed on the current car on the basis of some user actions that are being displayed. So I have to know whether the property has been allocated or set to zero. I'm aware of INotifyPropertyChanged , but in my case I'm not sure that since this change I have changed my car properties car do not want to monitor the property. Any idea how to accomplish this? In advance thank you If you have created a true asset in your class then You should be a great and setter, you can add the code directly to the form property in order to take action on the basis of "form": Public partial category Form 1: form {public form 1 () {InitializeComponent (); } // define car square public class car {public string name = string. Empty; } // private car to keep the value of the current car private variable _car = null; // Property of public form which you can ru...
Read more

javascript - amcharts makechart not working -

-
I am trying to create an amiratars serial chart on my Durandal single page application. This chart was working fine on Chrome browser but it is not working on IE. Can you please help me in this regard. Error while using Amcharts. The Macchart () method does not support the object in this object in IE.
Read more

java - Algorithm negotiation fail SSH in Jenkins -

-
I am trying to do SSH on the local server from Jenkins, but the following error has been thrown: [SSH] Exception: Algorithm negotiation fail com.jcraft.jsch.JSchException: algorithm talk com.jcraft.jsch.Session.receive_kexinit (Session.javaatar20) at com.jcraft.jsch.Session.connect (Sesson at com.jcraft.jsch.Session.connect (Session.java:150) at org.jvnet.hudson.plugins.SSHSite.createSession (SSHSite.java:141) on failed failed org.jvnet.hudson.plugins. java: 286) .SSHS on org.jvnet.hudson.plugins.SSHBuildWrapper.executePreBuildScript (SSHBuildWrapper.java:75) on Org.jvnet.hudson.plugins.SSHBuildWrapper.setUp (SSHBuildWrapper.java59) ite.executeCommand (SSHSite.java151) on hudson.model.Build $ BuildExecution.doRun hudson.model.AbstractBuild $ AbstractBuildExecution.run (AbstractBuild.java:533) to (Build.java:154) hudson.model.Run.execute ( Run.java:1754) in ended .model.FreeStyleBuild.run (FreeStyl hudson.model.ResourceController.execute (ResourceController.java:89) on hudson.mod...
Read more