Groups, tables and relations
Hi I have recently made the choice between Visual Studio Reports and Crystal Reports where I chose VS Reports after having tried out both of them. I have looked for answers to this simple question for a very long time, but haven't found a satisfying solution. I might not have used the right keywords in my search, so therefore I ask you. In Crystal Reports I could have two tables, let's say People and Pets. Then I could make an outer group using the People table and for every person I could make a subgroup with only the pets owned by the corresponding person. I want to do this in VS Reports also. The Data Source-tab shows my relations in the correct way, but as far as I have read and seen myself, when I import them to my Report project, they will only show up as single tabels (no nesting). But how can I make my groups? I have tried to add a new Row Group, but it will only let me select fields from the outer table (People). I found a thread that said I could make subreports, but that wasn't the right/best way to do it in Crystal, so I'm guessing it also isn't in VS. Does anyone have a solution for this? Thanks in advance. Mark
May 12th, 2011 1:09pm

Mark, This is one of the fundamental basics of report design in both Crystal Reports and Reporting Services. You really need to get a good book on SSRS and work through some examples before you even attempt writing real reports. The concept of linking tables and creating groups is exactly the same in both Crystal Reports and SSRS. The actual controls and their placement in the ide is different but conceptually, they are identical in this regard. You create a group based in the person. Once you have that all of the data rows will be grouped by the person.Jason Long
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2011 3:27pm

Thank you for your answer. I have found a solution to my problem by taking your advice and reading a book on the subject. It seems that I have to join the data before my report gets it. I think my problem was that I thought I could use grouping in a more advanced way than it is actually possible (that is, not only grouping, but also joining).
May 17th, 2011 8:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics